<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FORMATTING - Conditional formatting based on formula doesn't affect current but differnt row"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119715">119715</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FORMATTING - Conditional formatting based on formula doesn't affect current but differnt row
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.1.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>bz_lo@florian-schmitt.net
</td>
</tr></table>
<p>
<div>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>