https://bugs.documentfoundation.org/show_bug.cgi?id=162559
Bug ID: 162559
Summary: conditional formatting does not work with cell
reference
Product: LibreOffice
Version: 24.2.4.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 195952
--> https://bugs.documentfoundation.org/attachment.cgi?id=195952&action=edit
Screeshot Cell Referenz Bug
I use a table with random numbers, as in the instructions
https://help.libreoffice.org/latest/de/text/scalc/guide/cellstyle_conditional.html?DbPAR=CALC
I have used the complete instructions. If I then use the conditional
formatting, which refers to a fixed cell that is defined with the condition
cell value is greater than “cell” and with the second condition cell value is
less than “cell”, then almost all cells are selected as a result, except for
the first cell A1, although half of the cells are smaller than the desired
value.
It doesn't matter whether I use a cell with a formula or with a fixed number.
I1 is with formula I2 is with a number, for both the conditional formatting
does not work.
If I enter the same value as a number in conditional formatting instead of the
cell, the conditional formatting works.
--
You are receiving this mail because:
You are the assignee for the bug.
