Bug 153768 - Conditional formatting does not have "Stop if true" option
Summary: Conditional formatting does not have "Stop if true" option
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Conditional-Formatting
  Show dependency tree / graph
 
Reported: 2023-02-20 21:41 UTC by Gabor Kelemen (allotropia)
Modified: 2023-02-21 01:15 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
The Regional Sales sheet in Excel and Calc (302.72 KB, image/png)
2023-02-20 21:41 UTC, Gabor Kelemen (allotropia) 		Details
Modified sample file. (594.96 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2023-02-21 00:29 UTC, m_a_riosv 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2023-02-20 21:41:08 UTC 
Created attachment 185505 [details]
The Regional Sales sheet in Excel and Calc

attachment 185496 [details] 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 [details] 
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 :).
Comment 1 m_a_riosv 2023-02-21 00:29:21 UTC 
Created attachment 185507 [details]
Modified sample file.

Looks like a bug, seems to me, mixing the icon set with other condition.
Works fine with a different type of condition (sample file).
And splitting the icon set condition to a different CF also works as expected (sample file).

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 16a35542aa07ed69c6c699d1c17f076d87708958
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Jumbo