Red Hat Bugzilla – Bug 985951
Libreoffice sometimes discards heterogenous formatting in a spreadsheet text cell
Last modified: 2014-03-19 07:24:02 EDT
Description of problem:
Cells with formatting changes in the middle (say ink colour changes) lose that information.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Open a new spreadsheet.
2. Into any cell, type "Bid 2", change the ink colour to red and then press "H". The ink colour reverts immediately to black - which shouldn't happen.
3. Press Enter to finish entering the text.
4. Select the 2H part of the text and select red ink colour and Press enter and the colour will stick - this is correct.
5. Go back to the cell and append a character (not space). It will appear red briefly, then the whole text will revert to black - which also shouldn't happen. Note that this doesn't happen if a space is entered next.
The same effects can be observed if you make the characters italic rather than making them red. Setting the cell to text format before trying this doesn't help.
Formatting information is discarded under some circumstances.
The formatting information should be retained. It is certainly possible for the spreadsheet to do this.
Whilst it is possible to make the formatting apparently stick, sometimes the program will just randomly unify the formatting in every cell in one go, rather than doing it on just the cell you're working on. This appears to be unrecoverable and could not be undone with Ctrl+Z. This _may_ be related to document recovery after a crash as that's the only time I've seen it.
Tried in 22.214.171.124-1.fc19 and couldn't reproduce, I assume this was fixed.
Works for me too (in F20).