Bug 162942 - FORMATTING - Conditional formatting Icon set 3 symbols resets >= to =
Summary: FORMATTING - Conditional formatting Icon set 3 symbols resets >= to =
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: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-09-13 08:23 UTC by trendafilka
Modified: 2024-09-13 09:40 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example spreadsheet which reproduces the bug (10.78 KB, application/vnd.oasis.opendocument.spreadsheet)
2024-09-13 08:23 UTC, trendafilka
Details

Note You need to log in before you can comment on or make changes to this bug.
Description trendafilka 2024-09-13 08:23:53 UTC
Created attachment 196420 [details]
Example spreadsheet which reproduces the bug

Since upgrading to 24.8.0.3, the latest version on Manjaro --the package is libreoffice-fresh-24.8.0-1-x86_64.pkg.tar.zst, but Calc itself says that it is 24.8.0.3 --, the conditional formatting is broken in my spreadsheet. I use one of the iconsets.  In the example spreadsheet,I have it set to

Red >= 0
Yellow >= 3
Green >= 10

But when I loaded the spreadsheet, it has set >= to =, so the cells are unformatted due to not being exactly equal.

When I edited all of the conditional formatting to be back how it should, it looked correctly, but after saving and reopening the document, this formatting was lost, and everything is set back to = again.

To reproduce:

- navigate to Formatting ->  Conditional -> Manage. 
- Pick the range to edit, A1:A7
- Change the red, yellow, and green = to >=.
- Select ok twice. Observe that there are two red, three yellow, and 2 green arrows, which is correct.
- Save the spreadsheet and close it.
- Reopen the spreadsheet. Observe that only the exactly equal ones are still marked.
- navigate back to manage formatting, edit the same range.
- Observe that the >= are now = again.

I did not have this problem with the previously installed version of LibreOffice: libreoffice-fresh-24.2.5-2-x86_64.pkg.tar.zst

The spreadsheet where I initially observed the problem is saved in .xlsx format, but the test spreadsheet I created is in ods format and has the same bug.
Comment 1 Xisco Faulí 2024-09-13 08:54:36 UTC
Thanks for reporting this issue.
it looks like a duplicate of bug 162938

*** This bug has been marked as a duplicate of bug 162938 ***
Comment 2 trendafilka 2024-09-13 09:40:19 UTC
Thanks for your help and getting back to me so quickly. I'm glad to see you've found a fix already.