Bug 43148 - insert/move/copy sheet may lead to document corruption
Summary: insert/move/copy sheet may lead to document corruption
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.4 RC1
Hardware: All All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-11-21 13:31 UTC by Francis Gueuning
Modified: 2012-01-04 23:08 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
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. (487.43 KB, application/x-gzip)
2011-11-21 13:31 UTC, Francis Gueuning
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Francis Gueuning 2011-11-21 13:31:29 UTC
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.
Comment 1 Francis Gueuning 2012-01-01 04:18:59 UTC
This problem seems to be solved in the LOdev3.5 beta 2 (refer to bug 40087), but not in the LO3.4-501.
Comment 2 Francis Gueuning 2012-01-04 01:57:57 UTC
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.
Comment 3 Francis Gueuning 2012-01-04 04:13:03 UTC
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
Comment 4 Francis Gueuning 2012-01-04 13:51:13 UTC
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.
Comment 5 Rainer Bielefeld Retired 2012-01-04 23:08:55 UTC
No fix known
 <https://bugs.freedesktop.org/page.cgi?id=fields.html#status>