Re: [Bug 223660] Re: font color in spreadsheet not displayed correctly
Hi Chris, I finally reformated my PC, now I have Ubuntu 9.04, my PC is now fast and working beautifully. I am very happy with Ubuntu, OO and the open source community. Thanks a lot for your help. On Tue, Apr 28, 2009 at 3:16 PM, Chris Cheney cche...@ubuntu.com wrote: The icon theme in OOo doesn't look like the Human one so I am not sure what is up with that part. -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a direct subscriber of the bug. Status in The OpenOffice.org Suite: Invalid Status in “openoffice.org” source package in Ubuntu: Invalid Bug description: In hardy with openoffice.org 2.4.0, there is a problem with the spreadsheet where some sheets don't show grid lines. This is an existing spreadsheet that I created years ago and use with each new version of openoffice. It works ok with any new spreadsheet I create, but only is a problem with the old one. Therefore, I cannot repeat tell you how to reproduce this bug. This may be similar to a bug reported on gentoo: http://bugs.gentoo.org/show_bug.cgi?id=219351 but, in my case, the work around of changing the background color to white makes no difference. I downloaded the openoffice.org-2.4 binary from openoffice.org website and tried it and the grid lines worked fine on my old spreadsheet. For me, the only work around I could find is to select the whole sheet (Cntl-A), then go to menu format cells borders select all cells bordered and set border color to light grey. This at least looks like a grid when the sheet is displayed. -- Julio Prada Tel. 8345-1313 -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 223660] Re: font color in spreadsheet not displayed correctly
Confirming this bug. In summary, if you add a background fill to the cells, the gridlines disappear. Original OpenOffice builds do not have this bug. I'm attaching a spreadsheet so you can see what I mean. ** Attachment added: test1.ods http://launchpadlibrarian.net/26070014/test1.ods -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 223660] Re: font color in spreadsheet not displayed correctly
Ah, and I should mention it has nothing to do with font color or conditional formatting for me. -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 223660] Re: font color in spreadsheet not displayed correctly
Hi SB, my problem is different, I dont have any background fill on the cells, I can go again and select no fill and still I dont have gridlines. Attached is a screenshot of your test1.ods on my PC. Thanks a lot, On Tue, Apr 28, 2009 at 7:05 AM, Sb sb56...@gmail.com wrote: Confirming this bug. In summary, if you add a background fill to the cells, the gridlines disappear. Original OpenOffice builds do not have this bug. I'm attaching a spreadsheet so you can see what I mean. ** Attachment added: test1.ods http://launchpadlibrarian.net/26070014/test1.ods -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a direct subscriber of the bug. Status in The OpenOffice.org Suite: Invalid Status in “openoffice.org” source package in Ubuntu: Invalid Bug description: In hardy with openoffice.org 2.4.0, there is a problem with the spreadsheet where some sheets don't show grid lines. This is an existing spreadsheet that I created years ago and use with each new version of openoffice. It works ok with any new spreadsheet I create, but only is a problem with the old one. Therefore, I cannot repeat tell you how to reproduce this bug. This may be similar to a bug reported on gentoo: http://bugs.gentoo.org/show_bug.cgi?id=219351 but, in my case, the work around of changing the background color to white makes no difference. I downloaded the openoffice.org-2.4 binary from openoffice.org website and tried it and the grid lines worked fine on my old spreadsheet. For me, the only work around I could find is to select the whole sheet (Cntl-A), then go to menu format cells borders select all cells bordered and set border color to light grey. This at least looks like a grid when the sheet is displayed. -- Julio Prada Tel. 8345-1313 ** Attachment added: OO Calc gridline problem screenshot.png http://launchpadlibrarian.net/26080798/OO%20Calc%20gridline%20problem%20screenshot.png -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 223660] Re: font color in spreadsheet not displayed correctly
On 04/28/2009 10:53 AM, prad...@gmail.com wrote: Hi SB, my problem is different, I dont have any background fill on the cells, I can go again and select no fill and still I dont have gridlines. Attached is a screenshot of your test1.ods on my PC. Thanks a lot, Hmmm strange, your screenshot shows fine white lines between the cells, which would be fine with me. Mine does not show any lines between the cells. So, should I open a new bug? -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 223660] Re: font color in spreadsheet not displayed correctly
Guys this is not a bug hence why it is marked invalid, read the link I pasted above. Sb if you add border lines it shows up, the fact that the grid lines disappear when you set a background color is INTENDED behavior. Chris -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 223660] Re: font color in spreadsheet not displayed correctly
Interesting, so my bug would not be gridlines not showing but grid lines always white. I changed gridlines and background to several colors but the gridlines were always white. Chris Cheney already suggested a solution to erase some old OO directories, anyway I will do a fresh install of Ubuntu one of these days. Thanks Chris and SB, On Tue, Apr 28, 2009 at 10:18 AM, Sb sb56...@gmail.com wrote: On 04/28/2009 10:53 AM, prad...@gmail.com wrote: Hi SB, my problem is different, I dont have any background fill on the cells, I can go again and select no fill and still I dont have gridlines. Attached is a screenshot of your test1.ods on my PC. Thanks a lot, Hmmm strange, your screenshot shows fine white lines between the cells, which would be fine with me. Mine does not show any lines between the cells. So, should I open a new bug? -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a direct subscriber of the bug. Status in The OpenOffice.org Suite: Invalid Status in “openoffice.org” source package in Ubuntu: Invalid Bug description: In hardy with openoffice.org 2.4.0, there is a problem with the spreadsheet where some sheets don't show grid lines. This is an existing spreadsheet that I created years ago and use with each new version of openoffice. It works ok with any new spreadsheet I create, but only is a problem with the old one. Therefore, I cannot repeat tell you how to reproduce this bug. This may be similar to a bug reported on gentoo: http://bugs.gentoo.org/show_bug.cgi?id=219351 but, in my case, the work around of changing the background color to white makes no difference. I downloaded the openoffice.org-2.4 binary from openoffice.org website and tried it and the grid lines worked fine on my old spreadsheet. For me, the only work around I could find is to select the whole sheet (Cntl-A), then go to menu format cells borders select all cells bordered and set border color to light grey. This at least looks like a grid when the sheet is displayed. -- Julio Prada Tel. 8345-1313 -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 223660] Re: font color in spreadsheet not displayed correctly
On 04/28/2009 11:43 AM, Chris Cheney wrote: Guys this is not a bug hence why it is marked invalid, read the link I pasted above. Sb if you add border lines it shows up, the fact that the grid lines disappear when you set a background color is INTENDED behavior. Chris Thanks for the reply Chris. Although it may be intended behavior, I don't really think it's ideal behavior. The pure OpenOffice.org builds don't behave that way, and it makes it look like there are compatibility problems when opening ODS files created on other systems. Don't forget that there are a huge number of Windows users running OpenOffice and almost all of them use the pure OpenOffice.org package which also give different results than with the Ubuntu packages. -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 223660] Re: font color in spreadsheet not displayed correctly
prad...@gmail.com Your screenshot looks like some other sort of bug, but I can't seem to reproduce it. It might be related to your theme, does it look right if you use Ubuntu Human theme? Chris -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 223660] Re: font color in spreadsheet not displayed correctly
Sb, Official OOo doesn't work that way at the moment but as soon as they manage to apply the patch (probably for OOo 3.2) it will operate the same way. It is a bug fix to correct interoperability with Excel. Chris -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 223660] Re: font color in spreadsheet not displayed correctly
Yes, I changed to Human theme, even restarted the PC and got the same (see attached screenshot). On Tue, Apr 28, 2009 at 10:58 AM, Chris Cheney cche...@ubuntu.com wrote: prad...@gmail.com Your screenshot looks like some other sort of bug, but I can't seem to reproduce it. It might be related to your theme, does it look right if you use Ubuntu Human theme? Chris -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a direct subscriber of the bug. Status in The OpenOffice.org Suite: Invalid Status in “openoffice.org” source package in Ubuntu: Invalid Bug description: In hardy with openoffice.org 2.4.0, there is a problem with the spreadsheet where some sheets don't show grid lines. This is an existing spreadsheet that I created years ago and use with each new version of openoffice. It works ok with any new spreadsheet I create, but only is a problem with the old one. Therefore, I cannot repeat tell you how to reproduce this bug. This may be similar to a bug reported on gentoo: http://bugs.gentoo.org/show_bug.cgi?id=219351 but, in my case, the work around of changing the background color to white makes no difference. I downloaded the openoffice.org-2.4 binary from openoffice.org website and tried it and the grid lines worked fine on my old spreadsheet. For me, the only work around I could find is to select the whole sheet (Cntl-A), then go to menu format cells borders select all cells bordered and set border color to light grey. This at least looks like a grid when the sheet is displayed. -- Julio Prada Tel. 8345-1313 ** Attachment added: OO calc gridlines ubuntu human.png http://launchpadlibrarian.net/26090974/OO%20calc%20gridlines%20ubuntu%20human.png -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 223660] Re: font color in spreadsheet not displayed correctly
The icon theme in OOo doesn't look like the Human one so I am not sure what is up with that part. -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
Re: [Bug 223660] Re: font color in spreadsheet not displayed correctly
Hi Chris, I am planning to install a fresh Ubuntu 9.04 I hope that would solve some other minor issues besides OO calc not displaying grid lines. Thanks a lot, Julio On Mon, Apr 13, 2009 at 5:35 PM, Chris Cheney cche...@ubuntu.com wrote: You could try moving/removing the ~/.openoffice.org* directories to see if that resolves your problem, without needing to completely reinstall the program. Chris -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a direct subscriber of the bug. Status in The OpenOffice.org Suite: Invalid Status in “openoffice.org” source package in Ubuntu: Invalid Bug description: The original bug report was about a MS Excel compatibility feature that just hasn't been added to official openoffice.org yet. There is a real bug here however in that it does not show font colors for certain cells properly and this happens even in official openoffice.org3.0.0. === In hardy with openoffice.org 2.4.0, there is a problem with the spreadsheet where some sheets don't show grid lines. This is an existing spreadsheet that I created years ago and use with each new version of openoffice. It works ok with any new spreadsheet I create, but only is a problem with the old one. Therefore, I cannot repeat tell you how to reproduce this bug. This may be similar to a bug reported on gentoo: http://bugs.gentoo.org/show_bug.cgi?id=219351 but, in my case, the work around of changing the background color to white makes no difference. I downloaded the openoffice.org-2.4 binary from openoffice.org website and tried it and the grid lines worked fine on my old spreadsheet. For me, the only work around I could find is to select the whole sheet (Cntl-A), then go to menu format cells borders select all cells bordered and set border color to light grey. This at least looks like a grid when the sheet is displayed. -- Julio Prada Tel. 8345-1313 -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 223660] Re: font color in spreadsheet not displayed correctly
** Description changed: - The original bug report was about a MS Excel compatibility feature that - just hasn't been added to official openoffice.org yet. - - There is a real bug here however in that it does not show font colors - for certain cells properly and this happens even in official - openoffice.org 3.0.0. - - === - In hardy with openoffice.org 2.4.0, there is a problem with the spreadsheet where some sheets don't show grid lines. This is an existing spreadsheet that I created years ago and use with each new version of openoffice. It works ok with any new spreadsheet I create, but only is a problem with the old one. Therefore, I cannot repeat tell you how to reproduce this bug. This may be similar to a bug reported on gentoo: http://bugs.gentoo.org/show_bug.cgi?id=219351 but, in my case, the work around of changing the background color to white makes no difference. I downloaded the openoffice.org-2.4 binary from openoffice.org website and tried it and the grid lines worked fine on my old spreadsheet. For me, the only work around I could find is to select the whole sheet (Cntl-A), then go to menu format cells borders select all cells bordered and set border color to light grey. This at least looks like a grid when the sheet is displayed. -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 223660] Re: font color in spreadsheet not displayed correctly
I have the same problem, all grid lines disappeared on Calc weeks ago. I go to tools-options-calc-grid lines, whatever I put does not work. It is as if this command is not affecting a configuration file or that the gridline settings are ok but they don't show on the screen. -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 223660] Re: font color in spreadsheet not displayed correctly
pradacr, Are you also using conditional formatting for the cells like the previous user report? If not please attach a copy of the file you are having trouble with and I will look at it. Chris -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 223660] Re: font color in spreadsheet not displayed correctly
** Bug watch added: Gentoo Bugzilla #219351 http://bugs.gentoo.org/show_bug.cgi?id=219351 -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 223660] Re: font color in spreadsheet not displayed correctly
You could try moving/removing the ~/.openoffice.org* directories to see if that resolves your problem, without needing to completely reinstall the program. Chris -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 223660] Re: font color in spreadsheet not displayed correctly
I forgot about conditional formatting. Disable conditional formatting on the cells by going to Format-Conditional Formatting. Your spreadsheet is setup to override and color the cells depending on the words in them. ** Changed in: openoffice Importance: Unknown = Undecided Bugwatch: OpenOffice.org Issue Tracker #95669 = None Status: Unknown = New ** Changed in: openoffice Status: New = Invalid ** Changed in: openoffice.org (Ubuntu) Status: Triaged = Invalid -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 223660] Re: font color in spreadsheet not displayed correctly
So, conditional formatting is causing the font color to be sticky. Is conditional formatting also responsible for the background color??? It doesn't appear that it should be since you cannot specify the conditional background. -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 223660] Re: font color in spreadsheet not displayed correctly
Yes in a manner of speaking. You have it set to BLUE style and the BLUE style sets the background to white. -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 223660] Re: font color in spreadsheet not displayed correctly
To be completely clear, what you are setting in the conditional formatting is not a Font Color but a Cell Style which includes all sorts of formatting. -- font color in spreadsheet not displayed correctly https://bugs.launchpad.net/bugs/223660 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
