Download it now!
Bug 97704 - Pictures anchored to a cell in Calc show position data relative to page, no information on position in cell available
Summary: Pictures anchored to a cell in Calc show position data relative to page, no i...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 113586 (view as bug list)
Depends on:
Blocks: Calc-Images
  Show dependency treegraph
Reported: 2016-02-10 09:34 UTC by jens116
Modified: 2020-11-09 23:13 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Example (24.38 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-02-10 09:34 UTC, jens116
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. (26.96 KB, image/png)
2018-04-07 13:46 UTC, Olivier Hallot

Note You need to log in before you can comment on or make changes to this bug.
Description jens116 2016-02-10 09:34:40 UTC
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.
Comment 1 raal 2016-02-10 11:04:55 UTC
I can confirm with Version:
Build ID: f4e703aa39e9c294441b6dd86189d8aff32db8bf
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
and Version:
Comment 2 Guntis Ratkevičs 2016-03-11 13:31:47 UTC
still exists in
Comment 3 raal 2016-03-11 14:25:02 UTC
(earliest affected)
Comment 4 Cor Nouws 2016-05-03 15:01:28 UTC
shouldn't the summary be : "pictures anchored to a cell show position data relative to page" ?
Comment 5 QA Administrators 2016-11-08 12:28:44 UTC Comment hidden (obsolete)
Comment 6 Xisco Faulí 2016-11-08 16:07:32 UTC
This ticket was confirmed in comment 1 and comment 2 and was incorrectly set to NEEDINFO later on. Setting it back to NEW
Comment 7 Regina Henschel 2017-12-19 17:31:20 UTC
*** Bug 113586 has been marked as a duplicate of this bug. ***
Comment 8 Regina Henschel 2017-12-19 17:32:42 UTC
Bug 113586 is an enhancement request to add an object for position relative to cell.
Comment 9 Olivier Hallot 2018-04-07 13:45:48 UTC
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
Comment 10 Olivier Hallot 2018-04-07 13:46:37 UTC
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.
Comment 11 jens116 2018-04-08 18:35:16 UTC
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 12 jens116 2018-04-08 18:41:54 UTC
Comment on attachment 122493 [details]

works within LO 5.4.1
Comment 13 Regina Henschel 2020-11-09 23:13:18 UTC
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.