[Libreoffice-bugs] [Bug 133746] New: Conditional Colour Scale Formatting incorrectly rendered: MAX & MEAN colours are reversed

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133746

            Bug ID: 133746
           Summary: Conditional Colour Scale Formatting incorrectly
                    rendered: MAX & MEAN colours are reversed
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: that.man.colin at gmail.com

Created attachment 161707
  --> https://bugs.documentfoundation.org/attachment.cgi?id=161707&action=edit
Simple small anonymised demonstration sheet

A simple colour scale on cell values ranging from zero to one appears to
reverse the colours assigned to the 50th percentile and max. Therefore, where
MAX should colour to Green it colours to yellow.
I cannot tell whether the sheet structure has become damaged internally but I
can confirm that other almost identical sheets [currently] function correctly.
I have even "copied" a correctly functioning sheet and re-entered data for the
desired subject but it still goes wrong.
Enclosing a fully functional sheet where it can be seen that the conditional
colour specification for column L should colour all the cells valued 1.00 as
GREEN but they insist upon reproducing as YELLOW.
Try selecting a block of 5 or MORE rows across any permutation of columns D to
H and simply deleting the data. The colours then reproduce correctly.
How interesting is that?
I imagine you will have better facilities for tracing the impact of changes to
these cells than I.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200607/9ff7a465/attachment-0001.htm>