Download it now!
Bug 91477 - FILEOPEN: XLSX Databar color is different than in Word 2010
Summary: FILEOPEN: XLSX Databar color is different than in Word 2010
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.0.0.beta1
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: XLSX-Conditional-Formatting
  Show dependency treegraph
 
Reported: 2015-05-22 12:54 UTC by darshan.gandhi
Modified: 2020-06-09 20:40 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot diff (225.08 KB, image/png)
2015-05-22 12:54 UTC, darshan.gandhi
Details
Original File (Before RT) (10.46 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-05-22 12:57 UTC, darshan.gandhi
Details
Roundtrip file (8.30 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-05-22 12:57 UTC, darshan.gandhi
Details
printscreen (84.62 KB, image/png)
2015-05-24 10:56 UTC, raal
Details
Comparison between Word 2010 (left) and Libreoffice 5.0.1.2 (right) (95.62 KB, image/jpeg)
2015-09-14 14:38 UTC, Xisco Faulí
Details

Note You need to log in before you can comment on or make changes to this bug.
Description darshan.gandhi 2015-05-22 12:54:31 UTC
Created attachment 115825 [details]
Screenshot diff

Steps:
Data bar color is not being preserved after RT.
Comment 1 darshan.gandhi 2015-05-22 12:57:03 UTC
Created attachment 115826 [details]
Original File (Before RT)
Comment 2 darshan.gandhi 2015-05-22 12:57:17 UTC
Created attachment 115827 [details]
Roundtrip file
Comment 3 raal 2015-05-24 10:56:44 UTC
Created attachment 115962 [details]
printscreen

I can not confirm with Version: 5.1.0.0.alpha1+
Build ID: e929194317a7debb1c5467282230cbbabe61a710
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-05-22_06:33:18

Please test with newer build, thank you
Comment 4 MM 2015-05-25 09:14:06 UTC
Unconfirmed with v5.0.0.0 b1 under mint 17.1 x64.
Comment 5 Xisco Faulí 2015-09-14 14:38:28 UTC
Created attachment 118704 [details]
Comparison between Word 2010 (left) and Libreoffice 5.0.1.2 (right)

This issue is still present in

Version: 5.0.1.2
Build ID: 81898c9f5c0d43f3473ba111d7b351050be20261
Locale: es-ES (es_ES)

on Windows 7 (64-bit)

The problem is that the issue's description is wrong. Databar color is already different in Writer and Word at importing time. I change the description accordently.
Comment 6 QA Administrators 2016-09-20 10:32:04 UTC Comment hidden (obsolete)
Comment 7 Ahmad Harthi 2018-06-12 09:06:53 UTC
This bug is still present in

Version: 6.1.0.0.beta1 (x64)
Build ID: 8c76dfe1284e211954c30f219b3a38dcdd82f8a0
Comment 8 QA Administrators 2019-06-13 03:01:10 UTC Comment hidden (obsolete)
Comment 9 NISZ LibreOffice Team 2020-06-08 16:17:18 UTC
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.
Comment 10 Bartosz 2020-06-09 20:40:29 UTC
More information about Excel changing colour by value:
https://www.ablebits.com/office-addins-blog/2013/10/18/change-background-color-excel-based-on-cell-value/

More information about Conditional Formatting in LibreOffice:
https://elearn.ellak.gr/mod/page/view.php?id=3010