Description: Removing conditional format in the "Manage Conditional Formatting" dialog box and closing the manager. They reappear upon reopening. Also, unable to determine which spreadsheet they are associated with in a workbook with multiple tabs. Steps to Reproduce: 1.Open Conditional Format Manager 2.Select a conditional formatting 3.Click the Remove button 4.Close the manager 5.Reopen the manager Actual Results: Open the Conditional Format Manager after creating one or more conditional formats. Remove one or more of the formats by selecting the format and clicking on the Remove button. Close the Manager. Reopen the manager and you will notice that the formats continue to be displayed. Expected Results: After removing the formats, they should not reappear in the manager. Reproducible: Always User Profile Reset: Yes Additional Info: The manager should not have redisplayed the removed formats. Also, there should be a way of determining which spreadsheet each formed is associated with.
I can't reproduce Version: 24.8.4.1 (X86_64) / LibreOffice Community Build ID: 1be9007f5d86a3741c366527d13e2970cbeef057 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded 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.
Created attachment 198126 [details] Screen shots of the bug
Very visual, but without a sample file. And please paste here the information on Menu/Help/About LibreOffice (There is an icon to copy)
Created attachment 198140 [details] Sample file The version info was included at the bottom of the previously attached PDF. I will include here as well. I tested it again this morning and it behaves differently. In one test it behaved normally. In another, after removing the formats and closing the manager, it appeared to remove the formatting. Upon reopening the manager, the previously removed formats showed up again and the formatting was reapplied to the cells. I can't identify the specific conditions that cause each behavior which will make this difficult to track down. Version: 24.8.3.2 (X86_64) / LibreOffice Community Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92 CPU threads: 4; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
I cannot reproduce with Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: cac9c7db6257b27724d90d4a355e52e456ef7e08 CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded
I haven't been able to consistently reproduce it enough to produce a demonstration file, but I can confirm that I've seen the described behavior as well, in 24.8.4.2. Somewhere in the switch to 24.x, Conditional Formatting seems to have lost consistent separation between multiple sheets in a single ODS file. I've seen transient bugs involving deleted conditions "springing back up", and with conditions randomly applying to sheets other than the ones in which they were created. Testing the above two issues is difficult, though, because the Manage window now shows rules for ALL SHEETS in the workbook in a single list, with no sheet names displayed. See Bug 164792 for more information on the latter, which seems to me like it might need to be fixed first to enable more reliable testing of the bugs described here. https://bugs.documentfoundation.org/show_bug.cgi?id=164792
In my opinion bug 164792 has been already fixed, please try in latest build. Can you confirm this? Rules for conditional formatting should be separated for each tab. In the last days some bugs concerning conditional formatting were fixed, thereby maybe also this one?