Created attachment 104970 [details]
Simple spreadsheet where the contents of cells L8,10 & 11 contain individually formatted characters
If text is entered into a cell and individual characters are formatted on the text line then that formatting is not reproduced if the input text is then reproduced by being targeted from another cell
We are not talking about formatting an entire cell by selecting it and re-formatting
Steps to reproduce:
1. Enter text into a cell, say A1, and embolden/italicise a few characters of the input text
2. in another cell simply target the original cell with "=A1"
3. ....There is no third step
Current behavior: Doesn't reproduce text formatting
Expected behavior: Would expect it to reproduce text formatting
As can be seen from the enclosed sample, the contents of Cells L8, 10 & 11 have been subjected to discrete formatting but this has not been reproduced in the referred complements of those cells in the three replicated groups
Operating System: Windows 8
Version: 220.127.116.11 release
Looks like notabug. It also doesn't work if whole source cell bold/italic. Wondering if any office suite behaves like what is described.
But it's interesting..could be an enhancement request.. :)
Lets wait someone opinion if this could be a valid enhancement.
I agree that a formatted cell does not/should not carry its formatting into another referring cell because cells are their own discrete entities and should carry their own discrete attributes.
Additionally, I would expect a copied cell to carry the attributes with it, but, the content's attributes are just as valid as any cell with a numerical basis and I wouldn't expect to refer to a numeric cell with 12345 in it and get 54321. Would you disagree?
Also, is it significant whether other office suites are also flawed - surely the objective is to build a superior product not just an "also ran". However, I do accept that if the original spec was flawed then this particular facet may well be System Normal.....
How to proceed when A1 is Bold, B1 is Italic? C1 = A1&B1 -> format should be bold, italic or bold italic?
In simple case C1 = A1 maybe relevant, but in complex case the results can be weird (intersection or unification)
The original report was concerned with text strings where A1+B1 is a concatenation not a mathematical summation. Therefore, one might imagine that if something bold is concatenated with something italic then you end up with a text string where the first (A1) characters are bold and then the last (B1) characters are italic. Therefore, C1 characters would be copies of the data and their formatting.
Source numerical cells with formatting would have a result cell that would need further formatting/highlighting to reflect its own unique status.
The bar for enhancement requests is quite low - this is a fine suggestion. As to if anyone will ever implement it....we shall see :)
Marking as NEW.
*** Bug 96437 has been marked as a duplicate of this bug. ***
*** Bug 97202 has been marked as a duplicate of this bug. ***
Cell formulas never transport character formatting attributions. Won't implement.