https://bugs.documentfoundation.org/show_bug.cgi?id=146381
Bug ID: 146381
Summary: CONDITIONAL FORMATTING: Using "Colour Scale" based on
data from another column
Product: LibreOffice
Version: 7.2.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Conditional formatting is the great tool and "Color Scale" is the most
convenient option of it. But regular tables typically begin with columns that
contain non comparable data (such as "Sequence number" or "Name". So logically
(and mostly for display purposes) the cells of this columns have to take the
same colors as corresponding cells from the column where the "Color Scale"
conditional formatting is used.
So it would be nice to apply the "Color Scale" conditional formatting bases on
data from other column, or at least to have an ability to link cell’s format to
cell with condition formatting.
Please find the attached screenshot for clarity.
Steps to Reproduce:
Format / Conditional / Color Scale
Actual Results:
We have only "Cell Range"
Expected Results:
"Formatting Cell Range"
"Conditional Cell Range"
Reproducible: Always
User Profile Reset: No
Additional Info:
-
--
You are receiving this mail because:
You are the assignee for the bug.
