<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 - Anchor To Cell position drifts as file opened and re-saved over time"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=139868">139868</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Anchor To Cell position drifts as file opened and re-saved over time
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.1.0.2 rc
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (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>jason@binarycoder.net
</td>
</tr></table>
<p>
<div>
<pre>Description:
As a worksheet is open and re-saved over time, controls that are anchored To
Cell drift in position.
The problem occurs even if the control position is locked after initially
setting the position.
The problem occurs even if the worksheet is protected after initially setting
the position.
This can be simulated by repeated Save and Reload instead of closing the entire
application repeatedly.
The problem is not limited to Push Button. For example, I reproduce with
Rectangle Shape anchored to cell and positioned at X=2.00", Y=2.00",
Width=2.00", Height=2.00". However, this requires many more repetitions of the
save and reload before the X=2.01" can be seen than in the Steps to Reproduce
for the Push Button.
NOTE: In case it matters, I am in en-US with Measurement Unit set to its
default of Inch.
Workaround: Avoid Anchor To Cell. Use Anchor To Page instead.
Steps to Reproduce:
1. Open Calc. NOTE: In case it matters, I am in en-US with Measurement Unit set
to its default of Inch.
2. View > Toolbars > Form Controls.
3. Add a Push Button to the sheet.
4. Right click the Push Button for Control Properties.
5. Set these properties:
Anchor: To Cell
Position X: 5 cm
Position Y: 5 cm
Width: 5 cm
Height: 5 cm
6. File > Save. Enter a filename.
7. File > Reload.
8. Repeat the Save and Reload of the file at least 4 times.
9. Choose Design Mode and view properties of the control. It has drifted to
Position X = 5.01 cm.
Actual Results:
X = 5.01 cm
Expected Results:
X = 5.00 cm
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.1.0.2 (x64) / LibreOffice Community
Build ID: 53d68d29d90fd16448721a60aad68c28ff0809f5
CPU threads: 12; OS: Windows 10.0 Build 19041; UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL</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>