https://bugs.documentfoundation.org/show_bug.cgi?id=119178
Bug ID: 119178
Summary: calc: conditional formatting formula refers wrong cell
Product: LibreOffice
Version: 6.2.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Conditional formatting formula uses relative references to cursor and not to
the cell applied.
Steps to Reproduce:
1. Open attached spreadsheet
2. Ensure that cursor is located NOT in B15 cell
3. Open Menu->Format->Conditional->Manage...
4. Click "Add.."
5. Select type "Formula is" with formula $A15 = "test"
6. (optional) Apply style "Error"
7. Select cell range $B$15
8. Press "OK"
Actual Results:
In conditional formatting list element is displayed with condition $A26 =
"test"
(can be different from $A26) and once conditional formatting dialog is closed,
B15 cell is not highlighted as expected.
Expected Results:
Formula should be same as inserted ($A15 = "test"), one dialog is closed cell
B15 is highlighted with red.
After edit this formula with same value it is used correctly.
Reproducible: Always
User Profile Reset: No
Additional Info:
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
