[Libreoffice-bugs] [Bug 91477] FILEOPEN: XLSX Databar color is different than in Word 2010

[bugzilla-daemon at bugs.documentfoundation.org]

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

NISZ LibreOffice Team <libreoffice at nisz.hu> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|108897                      |113782
                 CC|                            |libreoffice at nisz.hu

--- Comment #9 from NISZ LibreOffice Team <libreoffice at nisz.hu> ---
Still happens in

Version: 7.1.0.0.alpha0+ (x64)
Build ID: 59939d2490726336546c7ad05082d23031074e12
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL

What really happens is that there is several rules in Excel for the same cell
ranges in a random-ish order and because Calc groups the CF rules by cell
ranges, the original order of the rules is not retained.

We have three rules for B2:D7, one for B1:D7 and four for E2:E7 in this order:

(1) B2:D7
(2) E2:E7
(3) E2:E7
(4) E2:E7
(5) B1:D7
(6) B2:D7
(7) B2:D7
(8) E2:E7
(9) E2:E7
(10) E2:E7

Calc groups (1) (6) (7) since they are for the same range and then puts (5)
before the group. 
This way the Orange-Gold rule (5) gets precedence over the Green-Red-Blue (1)
and that's on the screenshots.

Also the grouping of E2:E7 rules is interesting. Two groups are created, the
first group consists only of the Green rule (4) and the second group is made
from (2) (3) (8) (9) (10) - so Green takes precedence over the "Blue marker
color 1" (2) and "Water blue marker color 5" (3) rules.

The rule (4) has the Excel setting "Border" set to "Continous" border (which
has also a Green color set) unlike the other five rules that have the "No
border" setting.

Unfortunately Calc does not have a Border setting to visualize that difference.


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108897
[Bug 108897] [META] XLSX (OOXML) bug tracker
https://bugs.documentfoundation.org/show_bug.cgi?id=113782
[Bug 113782] [META] XLSX (OOXML) conditional formatting bug tracker
-- 
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/20200608/5001fc6f/attachment.htm>