Bug 95997

Summary: Condition formatting/color gradient is not calculated correctly when text format is ""
Product: LibreOffice Reporter: unowfar
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INSUFFICIENTDATA    
Severity: normal CC: aron.budea, xiscofauli
Priority: medium    
Version: unspecified   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 87351    

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 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
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

MassPing-NeedInfo-20171030