Apache OpenOffice (AOO) Bugzilla – Issue 19400
Changing fonts is a whole cell, when saved and reopened opened in xls format
Last modified: 2013-08-07 15:15:02 UTC
When I save a file to an MS Excel format then reopen it I can't change the font for the whole cell if I have a manual line break in it. To change the font I must go in like I'm going to edit the text, select it, then change the font. This applies even if I then save to a .sxc format, however if I save it origanally as a .sxc then it works fine. To reproduce, 1. Open a spreed sheet document 2. Enter in some text to a cell with a manual line break using Arial font, (other fonts I'v tried also work) 3. Save document to as a .xls 4. close document 5. open it back up, 5. select the cell you added text to, 6. go to the font pulldown tab and select Bodoni font, (other fonts I've tried also work) Expected result all the text in cell changes to Bodoni, Actuall result, when selecting the cell it say the font for the cell is Bodoni, but it isn't, and if you edit the text inside the cell it gives you the actual font that it is, (i.e. Arial).
Created attachment 9177 [details] Spreedsheet showing the problem I'm having
I've atached a document that has example of what I'm talking about, one row has stuff that was saved to a xls at one point and one has stuff that has never been saved to xls. The cell with manual line breaks and that were saved to xls at one point wont allow you to change the font by selecting the cell(s).
Hi Daniel, please have a look
I will look at this
John, this seems to be a problem with the rich-text font data, that overwrites the cell font. Happens if the first character has a font set. I think you have already fixed this with the escapement export (#105281# in calc16).
yes, thanks Daniel, the insertion of the new-line was causing the xls export to create a formatting run for this string and thus the font is incorrect for this cell. This is now fixed and the fix went into CWS srx645/cws16. will mark this as fixed.
closed