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.
Cells B5 and G2 do not have green background anymore, where as B4 is now colored green !
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.
User Profile Reset: No
OpenGL enabled: Yes
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
Created attachment 151006 [details]
xlsx file created in Excel from scratch.
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.