https://bugs.documentfoundation.org/show_bug.cgi?id=95997
Bug ID: 95997
Summary: Condition formatting/color gradient is not calculated
correctly when text format is ""
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/46.0.2490.86 Safari/537.36
Build Identifier: LibreOffice 5.0.3.2
I've been attempting to apply a color gradient from pure white at a value of 0
to pure black at a value of 17. I've noticed that the gradient changes ever so
slightly and becomes incorrect when the text format for the values is "" (two
double quotes, which essentially hides the text). The gradient becomes correct
again when the values are set back to a number format.
An example of the error when text is hidden: value 1.7 is 97% white, value 15.3
is 84% black.
In this example, the values are an equal distance from the min and max (0 and
17 respectively) and should therefore have an equal white and black percentage.
Instead, we see the color gradient skewed toward white.
Reproducible: Always
Steps to Reproduce:
1.Create values 1-20
2.Format cells with code "" to hide values
3.Apply conditional formatting with Color Scale (2 Entries)
4.Set black and white
5.Black and white values at the ends should match, and can be checked with
Photoshop or similar.
Actual Results:
The gradient is skewed. The upper value doesn't seem to be dark enough.
Expected Results:
The gradient should be exactly grey in the middle and a correct black/white
ratio on the min and max values.
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Reset User Profile?No
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
