Created attachment 59459 [details]
spreadsheet with form and drawing elements
Attached file was created in OpenOffice 2.0, Openoffice 3.3 still opens this file same way as previous version.
In LibreOffice 3.4 and 3.5 placement and sizes of form and drawing elements are different making this document unusable.
[Reproducible] with "LibreOffice 184.108.40.206 German UI/Locale [Build-ID: 281b639-6baa1d3-ef66a77-d866f25-f36d45f] on German WIN7 Home Premium (64bit)
[Reproducible] with "LibreOffice 3.4.1RC1 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:101)]"
Looks ok with "LibreOffice Portable 3.3.0 - WIN7 Home Premium (64bit) German UI [OOO330m19 (Build:6) tag libreoffice-220.127.116.11]" (no obvious differences to view in Oo 3.3)
Might be related to a row hight calculation problem or similar. Picture in E16 has hight 5,9mm in 3.5.2 and is located as x/y 43,25mm/78,28mm
With Portable 3.3.0
hight 5.39mmmm and is located as x/y 43.43mm/78.46mm
Some further research will be required
[Reproducible] with "LibreOffice 18.104.22.168 German UI/Locale [Build-ID: 165a79a-7059095-e13bb37-fef39a4-9503d18] on German WIN7 Home Premium (64bit)
[Reproducible] with server-installation of Master "LOdev 3.6.0alpha1+ – WIN7 Home Premium (64bit) ENGLISH UI [Build ID: bfa9061]" (tinderbox: Win-x86@6-fast, pull time 2012-06-02 23:56:11)
It's not only "wrong height".
And I can't tell wether the problem is caused by a bug in OOo + old LibO.
See attached secreenshot comparison for details.
Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug
Created attachment 62485 [details]
reproduced also in 3.3.4 on Fedora 64 bit
Changing version to 3.3.4 as most early reproduced
I have installed version 22.214.171.124, still same problem.
It looks like for all drawings and form( I have only one grouped form object in sample file) object that are anchored to cell program is correctly reading position of lower right corner, but is taking upper left corner of cell as upper left corner of each object anchored to that cell, so is stretching it in different scale depends on original position in cell.
Changing anchor to page will produce correct result, but this is only workaround not solution.
Created attachment 65263 [details]
Even Worse with 3.7.0
Things become worse in Master, see attached pdf
I created a more simple sample with LibO 3.3.0 and some PDF exports to show different view in various versions. Due to results I created 2 new Bug reports
"Bug 53230 - FILEOPEN particular .ods from LibO 3.0.0 shows all form fields at wrong horizontal position"
"Bug 53229 - FILEOPEN particular .ods from LibO 3.0.0 shows grouped form fields at wrong horizontal position"
Can you please try to extract problems from your sample, to create separate bugs and to add these Bugs to the meta Bug? That might speed up fixing process.
In reply to comment 5: may be Bug 46868 has useful information
Created attachment 65264 [details]
simplified test case
I have copy-pasted part of content.xml of first attachment to fods file. It attached. First cell contains two lines. It is green lines of cell V11 of first attachment.
Here we see that these lines take all cell instead of small part of cell. fodt file contains this line:
<draw:g table:end-cell-address="Sheet1.A1" table:end-x="0.8606in" table:end-y="0.5878in" draw:z-index="39">
Here we see X and Y dimensions. IMHO it is dimensions of correct green figure (see second attachment). But Calc ignores these dimensions. When I change values in this line in FODS file and reload, nothing changes.
I believe the fix for bug 53229 solves this ( at least to my eye the document looks the same when compared with AOo3.4