Created attachment 122493 [details]
Copy an image to the middle of a Calc sheet. Right-click on the picture and choose "Anchoring to cell". Right-click on the picture and choose "Position and Size". Here you can find values for the x- and y-position, which do not reflect the position to the cell but the position to the sheet. Please try the following: Change the value for the y-position to zero and click OK. The picture will move to the top of the sheet and not to the top of the cell.
I have deposited an example, in which the error is shown in a different way.
I can confirm with Version: 220.127.116.11.alpha0+
Build ID: f4e703aa39e9c294441b6dd86189d8aff32db8bf
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default;
and Version: 18.104.22.168
still exists in 22.214.171.124
shouldn't the summary be : "pictures anchored to a cell show position data relative to page" ?
Dear Bug Submitter,
This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INSUFFICIENTDATA
due to lack of needed information.
For more information about our NEEDINFO policy please read the
wiki located here:
If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
Thank you for helping us make LibreOffice even better for everyone!
This ticket was confirmed in comment 1 and comment 2 and was incorrectly set to NEEDINFO later on. Setting it back to NEW
*** Bug 113586 has been marked as a duplicate of this bug. ***
Bug 113586 is an enhancement request to add an object for position relative to cell.
The same issue occurs to form controls you anchor in the the cell (likely same origin).
Actual results: X and Y still displays same value as if they were anchored in "page".
Expected results: X and Y values from top left corner of the cell. If the cell moves position (a line or colum inserted before it), the X and Y coordinates should not change, because it is relative to the cell.
Consequences: It becomes harder to precisely anchor the control to the top left corner of the cell, which should be done by entering 0,0 in the X and Y positions respectively.
Besides, the Control Properties dialog should also indicate the cell reference of the anchor. For example if I want the control anchored in cel D4, I should be able to input D4 in the property dialog.
Image attached shows issue
Created attachment 141184 [details]
The text box control is anchored to the cell but the X and Y coordinates indicates absolute position from top of page. Should be top of cell.
Now after 2 Years I find a partial solution of the problem. Within the LO 5.4.1 the anchoring of a picture to a cell works! Therefore my example from the top is obsolete. But the errors in the positioning parameters remain as described. Thanks to Olivier Hallot who found the same problems at calc form-controls.
Comment on attachment 122493 [details]
works within LO 5.4.1
Internally the information is maStartOffset in the first ScDrawObjData item in the "UserData" list. In API the properties are HoriOrientPosition and VertOrientPosition.
It would be really useful to be able to see and to set it in the Position&Size dialog.