<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:libreoffice@nisz.hu" title="NISZ LibreOffice Team <libreoffice@nisz.hu>"> <span class="fn">NISZ LibreOffice Team</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - FILEOPEN: XLSX Databar color is different than in Word 2010"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=91477">bug 91477</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Blocks</td>
<td>108897
</td>
<td>113782
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>libreoffice@nisz.hu
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - FILEOPEN: XLSX Databar color is different than in Word 2010"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=91477#c9">Comment # 9</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - FILEOPEN: XLSX Databar color is different than in Word 2010"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=91477">bug 91477</a>
from <span class="vcard"><a class="email" href="mailto:libreoffice@nisz.hu" title="NISZ LibreOffice Team <libreoffice@nisz.hu>"> <span class="fn">NISZ LibreOffice Team</span></a>
</span></b>
<pre>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.</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] XLSX (OOXML) bug tracker"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108897">Bug 108897</a>] [META] XLSX (OOXML) bug tracker
</li>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] XLSX (OOXML) conditional formatting bug tracker"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113782">Bug 113782</a>] [META] XLSX (OOXML) conditional formatting bug tracker
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>