[Libreoffice-bugs] [Bug 119715] New: FORMATTING - Conditional formatting based on formula doesn't affect current but differnt row

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119715

            Bug ID: 119715
           Summary: FORMATTING - Conditional formatting based on formula
                    doesn't affect current  but differnt row
           Product: LibreOffice
           Version: 5.1.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: bz_lo at florian-schmitt.net

Description:
When defining a conditional formatting rule, a formula containing a relative
cell reference will be changed automatically, breaking the formatting rule. The
behaviour depends if the cell range is selected before calling the Conditional
Formatting dialogue, or when the cell range is set manually in the rule
definition dialogue

Steps to Reproduce:
1. Create a new calc sheet
2. Select Menu Format -> Conditional formatting -> Manage
3. Click Add
4. Under Condition 1, select "Formula is"; as formula, enter '$G3="L"'; select
a style sheet to apply if formula is true;
5. In the "Cell Range" field, enter "A3:F25"
6. Click OK in both dialogues.

Actual Results:
The Value of the cell in the G column doesn't affect the current row but
(current row - 2). When checking the conditional formatting rules, it appears
that the formula applied is now '$G5="H"'.

Expected Results:
The value of the G column should affect the current row. The formula shouldn't
change without user interaction...


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Modification:
After Step 1 above, select the range A3:F25. Then proceed with Steps 2-4, omit
step 5, continue with step 6.

Result: Actual result == expected result. So it matters if the range is
"pre-selected" before calling the conditional formatting dialogues.

tested with:

Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial4
CPU Threads: 4; OS Version: Linux 4.15; UI Render: default; 
Locale: de-DE (de_DE.UTF-8); Calc: single

Another Modification: With Version: 6.0.5.2 (x64)
Build-ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16
CPU-Threads: 3; BS: Windows 10.0; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc: group
the behaviour is different again. Steps to reproduce will lead to an immediate
modification of the formula in step 6 after first "OK" - formula is now
'$G2="L"' and will affect (row +1) instead of current row. But here again, it
works if the range is selected before step 2.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180905/3302f097/attachment-0001.html>