[Libreoffice-bugs] [Bug 139868] New: Anchor To Cell position drifts as file opened and re-saved over time

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139868
           Summary: Anchor To Cell position drifts as file opened and
                    re-saved over time
           Product: LibreOffice
           Version: 7.1.0.2 rc
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jason at binarycoder.net

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

-- 
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/20210123/92333787/attachment.htm>