https://bugs.documentfoundation.org/show_bug.cgi?id=171055
Bug ID: 171055
Summary: when using an "icon set" with conditional formatting,
conditionals are not saved when document is re-opened
Product: LibreOffice
Version: 26.2.1.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When using conditional formatting, if an icon set is used with 3 icons (the
default) and you set the 3 conditions to be <, =, and > of some value, saving
and opening the document again changes all three conditions to >. I will attach
some images to show this behavior more clearly. This happens when using the
.ods file type.
Steps to Reproduce:
1. make new calc document
2. make a column counting from 1 to 10
3. select that column, click conditional formatting, select "icon set..."
4. change all 3 boxes from "percent" to "value"
5. write 5 in all 3 boxes
6. change the first condition to <
7. change the second condition to =
8. change the third condition to >
9. press "ok", observe how the entire column is formatted as expected with
icons
10. save document, close out of calc
11. open document, observe how only numbers 6-10 are formatted with an icon
12. re-open the conditional formatting that you set before and all 3 boxes are
now set to >
Actual Results:
conditional formatting is not preserved when saving document
Expected Results:
file is saved properly
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 26.2.1.2 (X86_64)
Build ID: 620(Build:2)
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Vulkan;
VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
