GNOME Bugzilla – Bug 365698
Cannot change font of cell imported from Excel format
Last modified: 2009-05-07 22:53:18 UTC
Open the attached Excel 97 file. There is only one cell, text: "Originally Arial 8". The font is Arial 8. Try to change the font or size, boldness, etc. You cannot. If you change the size, column height changes, that's all. Seen on 1.6.3 and CVS. When I write the file as gnumeric XML, the cell has this value format (line breaks added for clarity): ValueFormat=" @[family=Arial:0:2147483647] [size=8192:0:2147483647] [bold=0:0:2147483647] [italic=0:0:2147483647] [strikthrough=0:0:2147483647] [underline=none:0:2147483647] [rise=0:0:2147483647][ color=00x00x00:0:2147483647]" This does not happen when I create a spredsheet like this in Excel 2003. I think the example started out in Excel, but has been written both by OOCalc and Gnumeric. The uploaded version is a single cell extract.
Created attachment 75498 [details] Bug sample
See also libgoffice bug 475136. With that one fixed, opening the cell format dialog of HEAD on A1 results in format code @[Invalid][Invalid][Invalid][Invalid][Invalid][Invalid][Invalid][Color0]
This is really just a special case of 163410 you can change the font, size, boldness etc. if you first start editing the cell, select a range of characters (or all characters) and then apply your format changes. This cell has formatting at the character level for all cells and so changes at the cell level are overwritten at the character level. Thanks for the bug report. This particular bug has already been reported into our bug tracking system, but please feel free to report any further bugs you find. *** This bug has been marked as a duplicate of 163410 ***