Bug 121961 - Calc cell color not consistent
Summary: Calc cell color not consistent
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium trivial
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-12-07 14:25 UTC by Ivan Williams
Modified: 2018-12-10 08:25 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Jpeg screen shot (3.31 KB, image/jpeg)
2018-12-07 14:27 UTC, Ivan Williams
Details
.ODS Spreadsheet (15.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-12-07 14:50 UTC, Ivan Williams
Details
Conparison of the different yellows (39.56 KB, image/png)
2018-12-07 15:36 UTC, Mike Kaganski
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ivan Williams 2018-12-07 14:25:37 UTC
Description:
I use the standard palette to specify cell color. The color yellow is not consistent as it changes from lighter to darker every time i pick it.

Steps to Reproduce:
1.Highlight a cell,  
2.Choose yellow from std background color palette
3.Some cells dark, some cells light.

Actual Results:
Cell color not consistent. Although using the same palette and same color sample block, the color changes. 

Expected Results:
Color should be consistent.


Reproducible: Sometimes


User Profile Reset: Yes



Additional Info:
Comment 1 Ivan Williams 2018-12-07 14:27:51 UTC
Created attachment 147348 [details]
Jpeg screen shot
Comment 2 Mike Kaganski 2018-12-07 14:37:34 UTC
Can you provide a sample spreadsheet where the problem is reproducible?

(a hint: when producing screenshots, please use PNGs. They don't weight much, and don't distort colors and lines. E.g., here it's even impossible to get the real RGB color value from the image)
Comment 3 Ivan Williams 2018-12-07 14:50:55 UTC
Created attachment 147350 [details]
.ODS Spreadsheet
Comment 4 Mike Kaganski 2018-12-07 15:36:51 UTC
Created attachment 147354 [details]
Conparison of the different yellows

But your cells are filled with different colors!

On the attached screenshots, it's clear that cells C6:C10 are filled using color #FFF200 (and the highlighted color is to the right in the bottom "Recent" line), while for cells C11:C13, "yellow" is used, and the color in the palette is highlighted.

Closing NOTABUG. Feel free to put it back to UNCONFIRMED if you feel it's wrong. If so, please provide detailed steps how to reproduce this using the same applied color.
Comment 5 Ivan Williams 2018-12-08 06:19:22 UTC
Hi Mike
Point is I never pick the yellow color from recent line of colors at the bottom.
I always pick from the same yellow square at the top lh of the color palette.
Comment 6 Mike Kaganski 2018-12-08 07:06:15 UTC
(In reply to Ivan Williams from comment #5)

So we need something to reproduce wrong behavior. Specific steps ("1. do this; 2. click that; 3. select that... N. the color is wrong"). Without that, it's *impossible* to work on something.
Comment 7 Ivan Williams 2018-12-10 08:25:47 UTC
Mike, apologies.
I do not believe it is a bug as such.
After trying various methods to reliably duplicate the issue, I realized that when opening a new Calc spreadsheet, the default fill color is the "darker" yellow. (not on the Standard fill color palette) I used this colour thinking it was saved or remembered from a previous session.

To duplicate:
1.)Open a new calc spreadsheet (note the fill color, yellow in my case)
2.)Highlight any cell and use the default fill color without opening the palette drop down.
3.)Now highlight an adjacent cell and open the standard color palette.
4.)None of the yellows in the standard palette match the "default" yellow.

Workaround:
Never use the default yellow as present when opening a calc document, always open the color picker and pick the color needed.