Bug 163162 - Conditional formatting in Calc vanish after saving in LibreOffice 24.8.x (tested in Linux and Windows)
Summary: Conditional formatting in Calc vanish after saving in LibreOffice 24.8.x (tes...
Status: RESOLVED DUPLICATE of bug 162938
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.0.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-09-26 10:53 UTC by Miroslav Jovanovic
Modified: 2024-09-26 14:07 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Miroslav Jovanovic 2024-09-26 10:53:18 UTC
Description:
If you have a conditional formatting in Calc (in my case conditional formatting->Icon Set->3 arrows) when saving in LibreOffice 24.8.x and then open it will be gone. This didn't happen in any of LibreOffice 24.4.x, conditional formatting was preserved after saving and opening.

Interestingly enough, open the file saved with LibreOffice 24.8.1 and then open it in LibreOffice 24.4.6, the conditional formatting shows as should be. 

Steps to Reproduce:
1. Make conditional formatting (example conditional formatting->Icon Set->3 arrows) 
2. Save file
3. Open the file in Calc 24.8.x, conditional formatting won't show
4. open the file in Calc 24.4.x, conditional formatting will show as expected

Actual Results:
Conditional formatting won't show

Expected Results:
Conditional formatting should show as applied


Reproducible: Always


User Profile Reset: No

Additional Info:
I have tested on Linux and Windows, it show the same issue. Opening a file with conditional formatting in Calc 24.4.x which was previously saved  in Calc 24.8.x  shows the conditional formatting as expected.

This imply that the loading files with conditional formatting in Calc 24.8.x are not processed correctly in Calc 24.8.x.

In my case when conditional formatting->Icon Set->3 arrows is applied, after opening the file in Calc 24.8.x. sets conditions to = instead of <, = and >. If you correct it, it will show as it should, but after saving and opening again, it is is not shown.
Comment 1 ady 2024-09-26 14:07:47 UTC
I am setting this as dupe of bug 162938.

If a new daily (or LO 24.8.2) does not solve the problem for you, please re-set this report to UNCONFIRMED.

*** This bug has been marked as a duplicate of bug 162938 ***