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.