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
  • 70,934
  • 124
  • 466
  • 653
user11833
  • 359
  • 2
  • 8
  • 2
    Does the same thing happen with the latest version of [LibreOffice](http://www.libreoffice.org/download)? They're essentially the same thing, but LibreOffice is the non-Oracle-owned, open source one. – John Lyon May 23 '11 at 04:24
  • Yes, the same problem is with `LibreOffice`. Any ideas? – user11833 May 23 '11 at 17:06
  • 1
    Have you tried saving it as an Excel 97/2000/XP compatible file? I find that they generally work much better with LibreOffice. – John Lyon May 23 '11 at 23:17
  • 2
    @user11833 You should probably [report](http://askubuntu.com/questions/5121/how-do-i-report-a-bug) this bug so the devs can work on a fix. – Knowledge Cube Sep 08 '11 at 01:54
  • Do you still get this issue? – RolandiXor Sep 23 '11 at 02:23

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.

Community
  • 1
Martin Owens -doctormo-
  • 19,860
  • 4
  • 63
  • 103
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
  • 24
  • 26