Created attachment 53755 [details] The procedure used for testing is indicated in the current sheet of each file. Macros have been removed, there is no need to activate them. This bug report is probably directly linked to bugs 39085 and 40087. I use successfully calc for teaching since two years (thank you very much for your work !) and the used documents contain pictures and form controls. I have tried LibO 3.4 but with such documents, insert/copy/move sheet, elsewhere than in the final position, lead almost always to the document corruption. Due to this problem, LibO 3.4 (up to 3.4.4) is prohibited in my case. Many forms are no longer visible, some pictures go on another sheet, if it is yet possible to save the document, it is often impossible to open it. In other cases, LibreOffice crash. The 2 files joined made with LibO 3.3.4 (macros and part of data removed) have been tested under Kubuntu 11.04 64-bit, Windows XP 32-bit and Windows 7 64-bit. The problem occurs in the 3 cases with LibreOffice 3.4.4 (downloaded from fr.libreoffice.org) and, according to some previous tests, also with 3.4.2 and 3.4.3 (3.4.1 not tested). Such problem is not detected with LibreOffice 3.3 (any version) nor with OpenOffice 3.1 up to 3.4 Beta 1. The procedure used for testing is indicated in the current sheet of each joined file. Macros have been removed, there is no need to activate them.
This problem seems to be solved in the LOdev3.5 beta 2 (refer to bug 40087), but not in the LO3.4-501.
I rejoiced too soon. Further testing (performed on other files made with LO 3.3.4 or previous versions) have shown that despite improvements, the problem is still present in the LOdev3.5 beta 2.
More precisely, the tests exactly mentioned in the files above give now correct results in LOdev 3.5.0 beta 2 (tested on Kubuntu 11.04 and Windows XP), but the DELETE SHEET gives yet bad results. For instance : - Open the file File2WatchingBugInLO344.ods given above (Disable macros because not used and in fact empty) - Format> Sheet> Show... OK (for Tut_Diode) It is interesting to see this sheet because it contains a graphic. - Observe the graphics and figures on the different sheets - Delete the 3 first sheets - Observe the graphics and figures on the remaining sheets : Several graphics have change of sheets
Because it seems that the problem precisely described here about insert/move/copy sheet is solved in LOdev 3.5.0 beta 2, I select status RESOLVED here. And I open a new bug about Delete sheet explaining my previous post.
No fix known <https://bugs.freedesktop.org/page.cgi?id=fields.html#status>