https://bugs.documentfoundation.org/show_bug.cgi?id=167375
Bug ID: 167375
Summary: Calc conditional formatting - object of the condition
formula cannot be an indirect (pointer) reference such
as G56 or $b22
Product: LibreOffice
Version: 24.2.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Editing a conditional format such as "Cell value", "is greater than", [number],
the [number] must be explicitly entered. I.e. the program will not honor an
indirect reference to a cell that has the desired value. You can enter B76 for
a cell row and column. The system does not protest or give an error or warning
message. The system appears to make an incorrect attempt to interpret an
indirect reference as a number resulting in an incorrect conditional formatting
of the target cells.
Actual Results:
Conditional formatting of the selected cells is done correctly if a 'hard
coded' number is entered in the Condition formula as: 'Cell value', 'is greater
than', 25600. If $D45 is entered in the condition formula 'Cell value', 'is
greater than', D45 and the value in cell D45 is 25600 the conditional
formatting works incorrectly.
Expected Results:
If the system would honor both a direct number entry as well as an indirect
reference to a valid number, the conditional formatting would be done
correctly.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 8; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.4
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
