https://bugs.documentfoundation.org/show_bug.cgi?id=159167
Bug ID: 159167
Summary: Conditional formatting of cells based on rules for
checking values greater than or less than
Product: LibreOffice
Version: 7.6.4.1 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I want to format cell values in green (lower) or red (higher) compared to cells
containing values for comparison.
Attached is a calc document containing two rows of values where the first row
has a conditional formatting rule applied.
It is expected the cells in the first row are colored red and green based on
the result of the formatting rule - the rule covers the whole cell range with
values in this row:
On a lower value compared to the cell from the second row the cell background
is set to green and on a higher value set to red.
The coloring ends after the first cell.
After reading the documentation page to this funtionality I'm not sure if the
created rule is the correct way to do this, but in my understanding of the
documentation it should be.
Best Alex
Steps to Reproduce:
1. Create the formatting templates from two cells where the first cells
background is colored green and the second cell background for the second
formatting rule is colored red. Name each formatting template depending on the
color: for red give the name "Higher" and for green the name "Lower".
2. Create two rows with about 5 columns of data.
3. Create a conditional formatting rule of the range of cells containing values
in the first row.
4. Select Cell value and for the comparison rule lower than and select the cell
range for comparison in the range of cell in the second row containing values.
5. Add another subrule set and select as comparison rule higher than and select
the same range in the second row.
Actual Results:
First cell in the first row will be formatted.
Expected Results:
All cells in the first row will formatted.
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: de
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
--
You are receiving this mail because:
You are the assignee for the bug.
