https://bugs.documentfoundation.org/show_bug.cgi?id=153768
Bug ID: 153768
Summary: Conditional formatting does not have "Stop if true"
option
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Blocks: 87351
Created attachment 185505
--> https://bugs.documentfoundation.org/attachment.cgi?id=185505&action=edit
The Regional Sales sheet in Excel and Calc
attachment 185496 from bug 153763 demonstrates the Excel Conditional formatting
feature "Stop if true" on the "Regional sales" sheet.
Calc does not have this feature, so it formats the cells differently.
1. Open attachment 185496
2. Go to the "Regional sales" sheet.
-> Observe the green traffic lights applied to the B4:B11 range in Calc.
In Excel the first rule has the "Stop if true" box checked so the second rule
is not evaluated for the B4, B6, B8:B10 cells, since the first rule matched and
this stops further CF rule evaluation.
Calc evaluates the second rule as well and puts the appropriate icon set icons
into the cells.
Calc should implement this feature for better interoperability. Also it's a
nice feature to have on its own :).
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=87351
[Bug 87351] [META] Conditional formatting bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
