[Libreoffice-bugs] [Bug 133746] 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

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
                 CC|                            |oliver.brinzing at gmx.de
     Ever confirmed|0                           |1

--- Comment #2 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
(In reply to Colin from comment #0)
> 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 can confirm the described behaviour with:

Version: 4.4.7.2
Build-ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Gebietsschema: de_DE

Version: 5.4.7.2 (x64)
Build-ID: c838ef25c16710f8838b1faec480ebba495259d0
CPU-Threads: 4; BS: Windows 6.19; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc: single

Version: 6.0.7.3 (x64)
Build-ID: dc89aa7a9eabfd848af146d5086077aeed2ae4a5
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc: 

Version: 6.4.4.2 (x64)
Build-ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU-Threads: 4; BS: Windows 10.0 Build 18363; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: 

Only values greater 1 in column L will colored green

Saving attached file as *.xlsx and opening with excel 2016 will display green
for values 1.

-- 
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/4c7ea46c/attachment.htm>