Bug 169203 - FORMATTING - Calc - Conditional formatting resets styles
Summary: FORMATTING - Calc - Conditional formatting resets styles
Status: RESOLVED DUPLICATE of bug 148489
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-11-02 01:52 UTC by Paul
Modified: 2025-11-03 11:20 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
cond form style test.ods (8.37 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-11-02 14:02 UTC, Paul
Details
cond form style test.xlsx (5.69 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2025-11-02 14:03 UTC, Paul
Details
Screenshot with both files view (37.17 KB, image/png)
2025-11-02 21:59 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Paul 2025-11-02 01:52:53 UTC
Conditional formatting seems to forget\reset their style after each sheet reopening.

If you created and selected some styles, Calc automatically creates and selects various "ConditionalStyle_NN".

It's a minor issue, but it messes with your Styles and make managing them pointless.
Comment 1 m_a_riosv 2025-11-02 13:55:34 UTC
What file format do you use to save?

Please attach a sample file, reduce the size as much as possible without private information,
and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
Comment 2 Paul 2025-11-02 14:02:30 UTC
Created attachment 203681 [details]
cond form style test.ods

ods format works
Comment 3 Paul 2025-11-02 14:03:00 UTC
Created attachment 203682 [details]
cond form style test.xlsx

xlsx doesn't work
Comment 4 Paul 2025-11-02 14:04:55 UTC
I'm using .xlsx for compatibility.

But I made the tests and noticed that .odt works, while .xlsx doesn't.
I attached them
Comment 5 Paul 2025-11-02 14:05:43 UTC
Version: 25.8.2.2 (X86_64)
Build ID: d401f2107ccab8f924a8e2df40f573aab7605b6f
CPU threads: 16; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: it-IT (C); UI: en-US
Calc: CL threaded
Comment 6 m_a_riosv 2025-11-02 21:59:08 UTC
Created attachment 203692 [details]
Screenshot with both files view

I can't see any difference between both files.
Comment 7 m_a_riosv 2025-11-02 21:59:35 UTC
Please test in safe mode, Menu/Help/Restart in Safe Mode
Comment 8 Paul 2025-11-03 00:07:12 UTC
The difference is only visible if you open the Conditional Formatting panel and check the Style
Comment 9 m_a_riosv 2025-11-03 11:20:38 UTC
Please review tdf#148489

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