How to observe data loss in LibreOffice Calc 5.1.5.2: ( 1) Start LibreOffice Calc. ( 2) Insert the number 1 into cell A1, and drag the cell handle to A10 such that a list of numbers 1 to 10 is generated in cells A1 to A10. ( 3) Select cells A1 to A10 and go to: Format -> Conditional Formatting -> Color Scale and press OK. ( 4) Now, as expected, cell A1 will be red, cell A5 will be orange, and cell A10 will be green. ( 5) Save the file to "test.ods". ( 6) Close and re-open the saved file in LibreOffice Calc. ( 7) The conditional formatting appears to be gone. ( 8) Go to Format -> Conditional Formatting -> Manage. ( 9) The list shown by the "Manage Conditional Formatting" window is empty, even though one should expect to see the conditional formatting from step 3 to be shown in the list. Saving to .xls does not appear to help either. So it may not have anything to do with the .ods format either.
Created attachment 127545 [details] Sample file to test. Hi Jelle, thanks for reporting. Not reproducible. Win10x64 Build ID: 7a864d8825610a8c07cfc3bc01dd4fce6a9447e5 CPU Threads: 1; OS Version: Windows 6.19; UI Render: default; Locale: es-ES (es_ES); Calc: CL Version: 5.2.2.1 (x64) Build ID: 3c2231d4aa4c68281f28ad35a100c092cff84f5d CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Locale: es-ES (es_ES); Calc: group Please try resetting the user profile, sometimes solves strange issues. https://wiki.documentfoundation.org/UserProfile Usually it's enough renaming/deleting the file "user/registrymodifications.xcu", it affects all the options in Menu/Tools/Options, and the files "user/basic/dialog.xlc" and "scrip.xlc" are overwritten, additionally custom colors in "user/config/standard.soc" are lost.
At work, the bug is reproducible for me (with Calc 5.1.5.2). At home, I cannot reproduce the bug (with Calc 5.1.5.2). Next week, at work, I will try your suggestions. I will also test the sample file you attached. I'll report back.
At work (where I first observed the problem), opening the sample file "test.ods" works as it should, it shows the Color Scale conditional formatting on cells A1:A10. At work, in the LibreOffice settings, the "ODF format version" was set to "1.0/1.1". With the ODF version set to "1.2", the problem IS reproducible. With the ODF version set to "1.2 Extended (compatibility mode)", the problem IS NOT reproducible. With the ODF version set to "1.2 Extended (recommended)", the problem IS NOT reproducible. With a new user profile, the above still holds true (both at home and at work). So, I'm not sure whether this is a bug at all. Hopefully the information I provided is helpful, so you can determine whether this is a bug or not.
(In reply to Jelle Geerts from comment #3) > > At work (where I first observed the problem), opening the sample file > "test.ods" works as it should, it shows the Color Scale conditional > formatting on cells A1:A10. > > At work, in the LibreOffice settings, the "ODF format version" was set to > "1.0/1.1". > > With the ODF version set to "1.2", the problem IS reproducible. > With the ODF version set to "1.2 Extended (compatibility mode)", the problem > IS NOT reproducible. > With the ODF version set to "1.2 Extended (recommended)", the problem IS NOT > reproducible. > With a new user profile, the above still holds true (both at home and at > work). > > So, I'm not sure whether this is a bug at all. > > Hopefully the information I provided is helpful, so you can determine > whether this is a bug or not. This is not a bug. All the new conditional formats are not representable in ODF 1.2 therefore we need to write some extensions. Extensions are only allowed in 1.2 extended. Hopefully we get the extensions for the conditional format into 1.3. IN general we only recommend 1.2 extended as you can otherwise loose features.