https://bugs.documentfoundation.org/show_bug.cgi?id=162942
Bug ID: 162942
Summary: FORMATTING - Conditional formatting Icon set 3 symbols
resets <= to =
Product: LibreOffice
Version: 24.8.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 196420
--> https://bugs.documentfoundation.org/attachment.cgi?id=196420&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
