Bug 154288 - Copying/Moving second sheet in Calc with form controls changes position of the controls in the new sheet
Summary: Copying/Moving second sheet in Calc with form controls changes position of th...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks: Form-Controls
  Show dependency treegraph
 
Reported: 2023-03-20 13:03 UTC by Gabor Kelemen (allotropia)
Modified: 2023-04-06 15:02 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Calc (9.22 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-03-20 13:03 UTC, Gabor Kelemen (allotropia)
Details
Screenshot of the issue in the example file and in the copy of the Sheet1 sheet (108.40 KB, image/png)
2023-03-20 13:04 UTC, Gabor Kelemen (allotropia)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2023-03-20 13:03:53 UTC
Created attachment 186088 [details]
Example file from Calc

Attached example file contains two form controls on the second sheet.
When the sheet is copied into a new file, the form controls appear mispositioned.

1. Open attached file
2. Right click on Sheet1, select Move or Copy Sheet
3. In the To Document choose: - new document -
4. Observe that the Push Button and the dropdown list appear in the new document somewhat to the bottom right compared to their original position. 
As if their X and Y coordinate values have been doubled, but the Control Properties dialog shows the same X: 4.98 cm and Y: 3.61 cm as originally.
Also when selected the highlight boxes appear in the correct position.

Important circumstances: the sheet has to be NOT the first in the document, if it's first then the positioning is fine.
The form controls have to be anchored as "To Cell", the default case of "To Page" works fine. 

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: b5c3a7502f7ff6ccf0f829c1f3a2ba50b8584c41
CPU threads: 14; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: threaded

Started to behave like this in 4.0.

Was good in:
Version 3.6.0.4 (Build ID: 932b512)
Comment 1 Gabor Kelemen (allotropia) 2023-03-20 13:04:39 UTC
Created attachment 186089 [details]
Screenshot of the issue in the example file and in the copy of the Sheet1 sheet
Comment 2 Rainer Bielefeld Retired 2023-03-20 20:22:42 UTC
Still REPRODUCIBLE with reporter's sample document and Server Installation of Version: 7.6.0.0.alpha0+ (X86_64) 
Build ID: 0484a9a3f5e2ecb678f6fb41bbb251529e89c00d
CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL threaded – Special new User Profile for testing

Already REPRODUCIBLE (not exactly the sanme, but very similar) with Server Installation of Version:  4.0.0.3 WIN10
Build-ID  7545bee9c2a0782548772a21bc84a9dcc583b89;  Special devUserProfile

Currently I do not have the time for more investigation (DUPs ...)
Comment 3 claudiuv 2023-03-25 13:35:48 UTC

Version: 7.5.1.2 (X86_64) / LibreOffice Community
Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: ro-RO (ro_RO); UI: en-GB
Calc: CL threaded

reproducible