Bug 95997 - Condition formatting/color gradient is not calculated correctly when text format is ""
Summary: Condition formatting/color gradient is not calculated correctly when text for...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
Reported: 2015-11-23 00:06 UTC by unowfar
Modified: 2017-10-30 10:51 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description unowfar 2015-11-23 00:06:34 UTC
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

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
Comment 1 QA Administrators 2017-01-03 19:36:59 UTC Comment hidden (obsolete)
Comment 2 Aron Budea 2017-03-24 01:02:38 UTC
This bug hasn't been confirmed independently, please don't set your own bug reports to NEW.
Comment 3 Xisco Faulí 2017-03-28 07:49:45 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2017-09-29 08:58:08 UTC Comment hidden (obsolete)
Comment 5 Xisco Faulí 2017-10-30 10:51:47 UTC
Dear Bug Submitter,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team