Bug 146381

Summary: CONDITIONAL FORMATTING: Using "Colour Scale" based on data from another column
Product: LibreOffice Reporter: Vasyĺ V. Vercynśkyj <fuckel>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WONTFIX    
Severity: enhancement CC: libreoffice-ux-advise
Priority: medium Keywords: needsUXEval
Version: 7.2.3.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 116221    
Attachments: Screenshot

Description Vasyĺ V. Vercynśkyj 2021-12-23 07:19:39 UTC 
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:
-
Comment 1 Vasyĺ V. Vercynśkyj 2021-12-23 07:21:02 UTC 
Created attachment 177103 [details]
Screenshot
Comment 2 Roman Kuznetsov 2023-02-10 18:11:59 UTC 
It will have no interoperability with other office suits then

Added UX-team for discussion
Comment 3 Heiko Tietze 2023-02-13 12:07:49 UTC 
Color is not data, and since you cannot set a cell background via formula this will not work. You can search for solutions with Excel, since there are more Q&A, and if you find something it should work as well with Calc, as Roman pointed out in comment 2. Resolving as WF.