Bug 124953 - FILESAVE, FORMATTING: xlsx file with conditional formatting created in Excel roundtripped by Calc does not look the same in Excel again
Summary: FILESAVE, FORMATTING: xlsx file with conditional formatting created in Excel ...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium normal
Assignee: Dennis Francis
Whiteboard: target:6.3.0
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Conditional-Formatting
  Show dependency treegraph
Reported: 2019-04-25 11:42 UTC by Dennis Francis
Modified: 2019-05-04 14:11 UTC (History)
0 users

See Also:
Crash report or crash signature:

xlsx file created in Excel from scratch. (9.48 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-04-25 11:43 UTC, Dennis Francis

Note You need to log in before you can comment on or make changes to this bug.
Description Dennis Francis 2019-04-25 11:42:32 UTC
The attached file is created from scratch in Excel. Opening this in Calc and saving it as another xlsx file and opening this new xlsx file in Excel shows misplaced conditional formatting colors.

Steps to Reproduce:
1. Open the attached xlsx file in Calc
2. Notice that B5 and G2 have green background via conditional formatting.
3. Save this as a new xlsx file.
4. Open this new file in Excel.
5. Observe the background color of cells B5 and G2. Also observe background color of B4.

Actual Results:
Cells B5 and G2 do not have green background anymore, where as B4 is now colored green !

Expected Results:
Cells B5 and G2 must have retained the green background and B4 should not have any background color for the round-tripped file when viewed in Excel.

Reproducible: Always

User Profile Reset: No

OpenGL enabled: Yes

Additional Info:
Build ID: 74a7b890524af4a52e711d8f0793ce844ded0948
CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.utf8); UI-Language: en-US
Calc: threaded
Comment 1 Dennis Francis 2019-04-25 11:43:42 UTC
Created attachment 151006 [details]
xlsx file created in Excel from scratch.
Comment 2 Commit Notification 2019-05-04 08:23:25 UTC
Dennis Francis committed a patch related to this issue.
It has been pushed to "master":


tdf#124953: Use rangelist's combined range top-left address...

It will be available in 6.3.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:

Affected users are encouraged to test the fix and report feedback.