<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 - LO Calc: Conditional Format formula issue, when you "cut-paste" the conditionally formatted cell range."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133027">133027</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>LO Calc: Conditional Format formula issue, when you "cut-paste" the conditionally formatted cell range.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.3.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>kovacs.tibor64@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
When you "cut-paste" the conditionally formatted cell range, the reference of
the CF formula go wrong. Using relative references, the formula must populate
"paralell" with the distance of the "cut place" and the "paste place". But it
not work properly.
Steps to Reproduce:
See the attachment.
1. The red cell E8 was formatted by CF formula with relative reference in the
condition: D8=1. The name of the applied Cell Style is „Error”.
2. Then the yellow and the red cell have been copied down to D17.
3. Check the setting of the CF in the Manage Conditional Format feature: The CF
formula and range have been integrated into one condition – as it is expected.
4. Select, Cut and then Paste the colorized block (D8:E17) down by some rows.
(if you move the range less than 10 rows down you will prompt see the strange
behavior)
5. Check again the formula of the CF
6. You will see: the reference of the CF formula changed by double value
relative to the distance of the „paste location-original place”
Actual Results:
the CF formula changed by double value relative to the distance of the „paste
location-original place”
Expected Results:
the CF formula must be changed same value relative to the distance of the
„paste location-original place”
Reproducible: Always
User Profile Reset: No
Additional Info:
The attached file was created in the LO 6.4.3 winPenPack portable version, but
the issue is present in my permanently installed LO 6.2.8 and the LO 6.1.6 too.</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>