Created attachment 53148 [details] State of document at the time of saving Problem description: LibO Calc 3.4.2 (openSuSE 11.4) and 3.4.3 (WinXP Prof. SP3) fail to properly restore positions of drawing objects in a spreadsheet. I have created an example document (Attachment "mini.ods", actually an excerpt from a larger document which shows the same problem) containing drawing objects, in the example file an arrow-type line with special ends and a text object which is aligned with the line (see screenshot "01-saved.png"). After saving and re-loading the document, the line is no longer properly aligned with the text object (see screenshot "02-opened.png"). The line is also slightly shorter than it was at the time of saving. Thius can also be seen from the size and position values displayed in the properties dialog (screenshots "01a-saved.png" vs. "02a-opened.png"). Steps to reproduce: 1. Open document "mini.ods". 2. Align arrow line and text object as given in screenshot "01-saved.png". 3. Save and close. 4. Open document "mini.ods". Current behavior: Arrow line and text object should appear mis-aligned similar to screenshot "02-opened.png". Behavior is identical on LibO 3.4.2 (openSuSE 11.4) and 3.4.3 (WinXP Professional SP3). Expected behavior: Arrow and text object should appear the way they were when the file was saved (as shown in screenshot "01-saved.png"). Platform (if different from the browser): LibO 3.4.2 (openSuSE 11.4) and 3.4.3 (WinXP Professional SP3) Browser: Mozilla/5.0 (Windows NT 5.1; rv:7.0.1) Gecko/20100101 Firefox/7.0.1
Created attachment 53149 [details] Geometry of arrow object at time of saving
Created attachment 53150 [details] State of document after re-opening
Created attachment 53151 [details] Geometry of arrow object after re-opening
I have the same problem in calc with documents of older libreoffice versions. Open a document in libreoffice 3.4.4 which was created in libreoffice 3.3.x, save and open it again in 3.4.4 damage the complete drawings in calc and I lost informations! :-( LibreOffice LibreOffice 3.4.4 OOO340m1 (Build:402) Ubuntu 10.04 LTS
Created attachment 54490 [details] before in libreoffice 3.3.4 (now redraw)
Created attachment 54491 [details] after save in libreoffice 3.4.4
I tried again today with LibO 3.4.4 on WinXP, same result. One thing to add: If I correct the position of drawing elements in 3.4.4 and save, when opening the file in 3.4.4, positions will be wrong _again_. However, if I open the 3.4-saved file (with corrected positions) in 3.3.4, positions remain correct. When saving in 3.4.4 without correcting positions, opening in 3.3.4 will show the elements in the wrong locations as well. So it's not just a display problem. Seems that LibO 3.4 does some weird things when calculating the positions of drawing elements on opening an ods file.
> If I correct the position of drawing elements in 3.4.4 and save, when opening > the file in 3.4.4, positions will be wrong _again_. I can confirm. But what I find out, create a drawing in a new calc document in libreoffice 3.4.4, save it and open it again. The drawing is still ok! Can you confirm that?
I took the pains to recreate part of the 3.3 .ods file from scratch in 3.4.4 (Linux), saved and re-opened it. No problem this time, all drawing elements were still in place in 3.4.4. I opened the 3.4.4 file in 3.3.4, and again: no problem. In 3.3.4, I moved some of the drawings around and saved the .ods file, then opened it in 3.4.4. Again, everything properly placed. Finally, using LibO 3.3.4 I added new drawing elements to the 3.4.4 .ods, saved and opened the file in 3.4.4. NOW the drawings added in 3.3.4 were out of place again (but ONLY those added in 3.3.4!). So I can confirm that those problems seem to occur with .ods files created in 3.3 and opened in 3.4, but not with files created in 3.4. Furthermore, adding new drawings in 3.3 to a file that was created in 3.4 causes (only!) those drawings to show up at the wrong location when the file is opened in 3.4.
Please test this with 3.5.0. I think Eike fixed several of the drawing object problems there.
NOT reproducible with "LibreOffice 3.5.0 German UI/Locale [Build-ID: 7e68ba2-a744ebf-1f241b7-c506db1-7d53735] on German WIN7 Home Premium (64bit) and a document from3.3.0 Portable. At least similar effects as reported visible with "LibreOffice 3.4.5 German UI [Build ID: OOO340m1 (Build:502)]" parallel Server installation on German WIN7 Home Premium (64bit) Might be fixed for 3.5? @matthias_luebberstedt@yahoo.de / all: Please (always!) attach your source document from LibO 3.3
Work now with LibreOffice 3.5.0 RC3 on Ubuntu 10.04 amd64.
Might be related to "Bug 37083 - Position and Size change for picture anchored to cell" or something else? For now DUP. @samuel_wolf@web.de <https://bugs.freedesktop.org/page.cgi?id=fields.html#status> we should used FIXED only if a known fix has solved the problem; if the problem only disappeared without known reason, please use WORKSFORME. *** This bug has been marked as a duplicate of bug 37083 ***
@ Rainer, sorry change it to "WORKFORME". @ Matthias, it works for you too?
@samuel_wolf@web.de: Please do not touch status picker! *** This bug has been marked as a duplicate of bug 37083 ***