https://bugs.documentfoundation.org/show_bug.cgi?id=172964
Bug ID: 172964
Summary: FORMATTING: Color Scale conditional formatting
formulas are not adjusted when copied horizontally
Product: LibreOffice
Version: 25.8.7.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 207954
--> https://bugs.documentfoundation.org/attachment.cgi?id=207954&action=edit
This is a short test file to reproduce the behaviour.
In LibreOffice Calc, a 3-color Color Scale conditional formatting rule with
formula-based thresholds does not adjust relative column references when copied
horizontally.
Steps to reproduce:
-------------------
1. Enter values in CA4:CA1003.
2. Enter threshold values:
CA1 = midpoint value
CA1006 = minimum value
CA1007 = maximum value
3. Apply Conditional Formatting -> Color Scale (3 entries) to:
CA4:CA1003
Use formula thresholds:
Minimum: =CA1006
Midpoint: =CA1
Maximum: =CA1007
4. Copy the formatting horizontally to:
CB4:CB1003
Expected result:
----------------
The formulas should adjust relative references:
Minimum: =CB1006
Midpoint: =CB1
Maximum: =CB1007
Actual result:
--------------
The copied conditional formatting still references column CA.
Vertical copying appears to adjust references correctly, but horizontal copying
does not.
Additional information
----------------------
This affects statistical visualization use cases where each column represents
an independent data set with its own reference values (for example Monte Carlo
simulations with separate quantiles per column).
See also :
-----------
Bug 105531
--
You are receiving this mail because:
You are the assignee for the bug.
