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"
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.
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.
User Profile Reset: No
Created attachment 144064 [details]
Conditional formatting testcase
I was under impression that this is as designed. If not, then what cell in the range to use as reference, if you define not a single-cell range? top left?
Mike, in mot cases (when you add conditional formatting to the cell under cursor) everything is ok. But if current cell and cell for conditional formatting are different, things are strange. In this situation (as described in test scenario) cell under cursor should have no influence on formula.
And yes, use top-left cell for range looks logical in my mind.
Maybe this https://bugs.documentfoundation.org/show_bug.cgi?id=54774#c3 could bring some light.
*** Bug 119715 has been marked as a duplicate of this bug. ***
WIP patch is here: https://gerrit.libreoffice.org/58800
Vasily Melenchuk committed a patch related to this issue.
It has been pushed to "master":
tdf#119178: use current range as a range for conditional format
It will be available in 6.2.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
A polite ping to Vasily Melenchuk:
Is this bug fixed? if so, could you please close it as RESOLVED FIXED ? Otherwise, Could you please explain what's missing?