Applying a background color to a spreadsheet cell or range of cells does not affect the display - the background of the cell(s) continues to be shown as white. However on printing the correct background colors are printed. This problem has been noted since LibO3.1 I have noted it on Win7 and WinXP. It leads to the thought that it would be helpful to have a "cell-propeties display" option, accessed say by right-clicking on the cell.
(In reply to comment #0) > Applying a background color to a spreadsheet cell or range of cells does not > affect the display - the background of the cell(s) continues to be shown as > white. How are you setting the background color > However on printing the correct background colors are printed. This > problem has been noted since LibO3.1 I have tried with XP ( select range of cells, right-click | Format | Background ) and it works no problems
Hi Noel Thanks for quick response. I normally use the "fill" icon (paintcan pouring out paint) but your suggestion of right-click | format | Background produces the same problem. Currently I am running Win 7 Ultimate on an HP Compaq laptop. Tomorrow I'll set up an XP installation on another hardware platform and see whether the problem remains. Will inform you of outcome. On Mon, 09 May 2011 20:37:15 +0200, <bugzilla-daemon@freedesktop.org> wrote: > https://bugs.freedesktop.org/show_bug.cgi?id=36968 > > Noel Power <nopower@novell.com> changed: > > What |Removed |Added > ---------------------------------------------------------------------------- > Status Whiteboard| > |infoprovider:basil@pop.co.z > | |a > Keywords| |NEEDINFO > > --- Comment #1 from Noel Power <nopower@novell.com> 2011-05-09 11:37:15 > PDT --- > (In reply to comment #0) >> Applying a background color to a spreadsheet cell or range of cells >> does not >> affect the display - the background of the cell(s) continues to be >> shown as >> white. > How are you setting the background color >> However on printing the correct background colors are printed. This >> problem has been noted since LibO3.1 > I have tried with XP ( select range of cells, right-click | Format | > Background > ) and it works no problems >
[This is an automated message.] This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it started right out as NEW without ever being explicitly confirmed. The bug is changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases. Details on how to test the 3.5.0 beta1 can be found at: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
needinfo keyword redundant by needinfo status.
Dear bug submitter! Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs. To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem. Yours! Florian
This bug has not re-appeared in sunsequent versions of LO, so I consider ti resolved.
Thanks for additional testing Due to last comment, changing status to WorksForMe If problem will appear again, please, change status to Reopened
I see this problem in files *.xls, created in OpenOffice Calc 3.1 when "Value highlighting" is ON. I see it on Windows XP with LibreOffice Calc 3.6.5 and on Xubuntu 12.04 with LibreOffice Calc 4.0.2.2 from ppa. And I think that problem not solved.
@ Stanislav Thanks for additional information Please, attach small example file (ods or xls) which demonstrates this bug
Created attachment 78324 [details] problem file This is one of problem files. Russian language text.
Thanks for attachment Here I see difference between Excel and Calc only in table border on first page Please, tell where exactly to see (and if problem appears during saving ods to xls, attach ods also) Or write how to reproduce problem
Ok.. Please, see this video from my desktop. http://dfiles.ru/files/r3q2fjyce
Problem absent on LO 4.0.1.2 under Windows 7... Basil On Mon, 22 Apr 2013 06:16:01 +0200, <bugzilla-daemon@freedesktop.org> wrote: > Stanislav changed bug 36968 >What >Removed >Added > Status >RESOLVED >REOPENEDResolution >WORKSFORME >--- > > Comment # 11 on bug 36968 from StanislavI see this problem in files > *.xls, created in OpenOffice Calc 3.1 when "Value > highlighting" is ON. I see it on Windows XP with LibreOffice Calc 3.6.5 > and on > Xubuntu 12.04 with LibreOffice Calc 4.0.2.2 from ppa. And I think that > problem > not solved. > You are receiving this mail because:You reported the bug.
Thanks for video. Reproduced in 4.0.2.2 on Fedora (RFR) 64 bit Steps to reproduce: 0. Start Calc. New empty document appears. 1. Select some area and right mouse click it, select "Format cells" from context menu, tab "Cell protection", uncheck "Protected" check-box. Click "Ok". 2. menu Tools->Protect document->Sheet. Click "Ok". 3. Ensure that Tools->Options->LibreOffice Calc->View, option "Value highlighting" is enabled 4. Change color of any unprotected cell to another. (by context menu and "Format cells" or using tool "Background color" from "Formatting" toolbar) Expected: color of cell changes Actually: cell is white. (in dialog "Format Cells" we see that color changed) 5. type something in any cell 6. menu File->Page preview. We see that colors of cell changed, sough not seen in document
No activity for over a year - removing Stanislav from assigned to field and moving this back to UNCONFIRMED to get fresh perspective. Thanks for your understanding.
Reproduced with the steps in comment 17. Win 7 64-bit Version: 4.4.0.0.alpha2+ Build ID: b021b5983c62e266b82d9f0c5c6d8d8900553827 TinderBox: Win-x86@39, Branch:master, Time: 2014-11-12_01:10:08
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.4 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-12-20
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.1.6 or 5.2.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170103
Seems like bug 129024 could be a duplicate of this bug.
This bug started as one issue and in Comment 11 was hijacked as another, similar to bug 129024. I will close this one as WFM for the original issue. As for another issue, from Comment 17, that's NotABug per Help: https://help.libreoffice.org/6.5/en-US/text/scalc/01/03080000.html