I created a template in MS Excel which relies heavily in conditional formats. The order of them is important, as they may overlap and are rendered in the order defined in Excel.
If one user does open this file in LibreOffice and saves it, the conditional format is broken.
Attached please find an example before and after opening it in LO.
Steps to Reproduce:
1. View the original file (attached) in Excel
2. Open it in LO and see the difference here.
3. Save the file in LO
4. Open it in Excel again and see that the original format is broken now.
The conditional formatting is wrong after editing the file in LO
The format should be untouched or at least the order of conditional formats should not be changed.
User Profile Reset: Yes
Version: 184.108.40.206 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
> Is OpenGL enabled?
I was not able to check this in 7.0.
Created attachment 167716 [details]
Created attachment 167717 [details]
file which was opened and saved in LO and is broken now
Created attachment 167719 [details]
The example file in Excel 13 and LO7.2 nightly
Version: 220.127.116.11.alpha0+ (x64)
Build ID: 4e63ec27b69fa01ff610c894c9fbf05c377a6179
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: en-US (hu_HU); UI: en-US
Already bad by opening time. Saving also changes the order in Excel.