Bug 168439 - FORMATTING: multiple conditional formatting change after save, reopen file
Summary: FORMATTING: multiple conditional formatting change after save, reopen file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.8.1.1 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, implementationError
Depends on:
Blocks: Conditional-Formatting-Editing
  Show dependency treegraph
 
Reported: 2025-09-17 08:11 UTC by imre.fekete
Modified: 2025-09-27 15:12 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Test file (12.72 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-09-17 08:13 UTC, imre.fekete
Details

Note You need to log in before you can comment on or make changes to this bug.
Description imre.fekete 2025-09-17 08:11:59 UTC
Description:
I set up conditional formatting for one cell. I copy the format to the other cells. Everything is fine. I save the file. I close it. I reopen it and the conditional formatting has changed.

Steps to Reproduce:
- Open the attachment teszt.ods
- Select cell A1.
- Open conditional formatting/icon set menu item 
- In the red downward arrow row: select "<" from the first drop-down list; =ma()-14 should appear in the text field; select "formula" from the second drop-down list.
- In the yellow right arrow row: select "=" from the first drop-down list; =ma()-14 should appear in the text field; select "formula" from the second drop-down list.
In the green up arrow row: select ">" from the first drop-down list; =ma()-14 should appear in the text field; select "formula" from the second drop-down list.
- Copy the format to the other cells
- Save file
- Close file
- Open file
- Open conditional formatting/icon set menu item 

Actual Results:
You can see that the value of the first drop-down list has changed to this in all rows: ">"

Expected Results:
Don't change the value of the list


Reproducible: Always


User Profile Reset: No

Additional Info:
The language of Calc is Hungarian. The function ma() specified in the description is today() in English. But today() does not work for me.
Comment 1 imre.fekete 2025-09-17 08:13:06 UTC
Created attachment 202852 [details]
Test file
Comment 2 raal 2025-09-27 15:12:57 UTC
Confirm with Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 8ea8e254a3151f5390f3a10ff156fcaf8e7c5d5c
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded

This seems to have begun at the below commit in bibisect repository/OS linux-64-25.8.
Adding Cc: to Ahmed Hamed ; Could you possibly take a look at this one?
Thanks
 b5ddc2fba128c10af6396e0949a3a289ea033b2a is the first bad commit
commit b5ddc2fba128c10af6396e0949a3a289ea033b2a
Author: Jenkins Build User <tdf@maggie.tdf>
Date:   Wed Mar 19 08:02:53 2025 +0100

    source 08c170b2fa0ceaae388da4ddbed0330bd57a663a

182760: tdf#61313: Allow customization of conditional formatting operators in icon sets | https://gerrit.libreoffice.org/c/core/+/182760