6

I have an Excel 2003 (.xls) spreadsheet that I created on my Windows box. I tried to open it on Open Office's Calc program, and it looks like all the cell values / formatting is indeed there.

Yet, for some reason, all the comments that are in the cells appear to be white text on yellow background -- which makes them impossible to read.

Any hints how to fix this bug? (I am using Ubuntu 10.04 LTS)

Jorge Castro
  • 71,754
user11833
  • 359

2 Answers2

1

Please report this bug so it can be fixed:

How do I report a bug?

The LibreOffice team I'm sure would be keen to solve the issue for you.

0

This bug has been reported to Launchpad as bug 1022640. The fix will be available in LibreOffice 4.0.4 which will be available in Saucy and probably Raring. A fix might be prepared for earlier Ubuntu releases, please see the bug report for more information.

A workaround is to change the colour settings in LibreOffice:

Go to 'Tools -> Options -> OpenOffice.org -> Appearance -> Notes Background' and 'Tools -> Options -> OpenOffice.org -> Appearance -> Comment' and change them to something that will work for you.

A second workaround is to install a macro, which resets the font colours for comments.

Both of the above workarounds have been created for OpenOffice.org but they should for for LibreOffice.

papukaija
  • 2,425