https://bugs.documentfoundation.org/show_bug.cgi?id=148856
Bug ID: 148856
Summary: conditional formatting cannot reference cells from
other sheets
Product: LibreOffice
Version: 7.3.1.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Hey.
When setting up conditional formatting, e.g. trying to look for duplicate
values, referencing cell-ranges from other sheets doesn't seem to work.
I can e.g. enter "A1:A10,sheet1.B1:B10" in the respective field and it does
seem to recognise whether sheet1 is actually a sheet or not, but after I
clicked ok, the "sheet1." part is simply dropped and it uses "A1:A10,B1:B10"
instead.
Thanks,
Chris.
PS: This is actually on 7.3.3~rc2
Steps to Reproduce:
see above
Actual Results:
uses the wrong cell range
Expected Results:
use the cell range from the referenced sheet
Reproducible: Always
User Profile Reset: No
Additional Info:
.
--
You are receiving this mail because:
You are the assignee for the bug.