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:
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": https://git.libreoffice.org/core/+/9c2c650c385bd77d7ea029c02102b39b709a381e%5E%21 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: https://wiki.documentfoundation.org/Testing_Daily_Builds 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? Thanks
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/86ac9eb59a6d058cc868ca2b05117375d6ea88f4 tdf#119178: sc: Add UItest It will be available in 7.4.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: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.