Bug 38080 - Save and re-open spreadsheet and all data is lost (Windows 7 dual monitor)
Summary: Save and re-open spreadsheet and all data is lost (Windows 7 dual monitor)
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.1.1.2 release
Hardware: x86 (IA32) Windows (All)
: high critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-06-08 09:16 UTC by theWebalyst
Modified: 2013-10-18 16:33 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
part of content.xml, position 264433 to 264783 (695 bytes, text/plain)
2011-11-07 13:55 UTC, Erwin
Details

Note You need to log in before you can comment on or make changes to this bug.
Description theWebalyst 2011-06-08 09:16:21 UTC
Windows 7 SP1 with dual monitor.

Opening an existing spreadsheet (saved under 3.3) - OK
Make a change and save - OK (file size remains correct)
Re-open that spreadsheet - all data lost, speed and result is like it did File/New, though the spreadsheet file stays as big as it was.

This bug has similarities with bug 37855 (Linux, dual monitor, Calc crashes)
Comment 1 Don't use this account, use tml@iki.fi 2011-06-09 01:14:15 UTC
Please attach a sample spreadsheet document for which this happens.
Comment 2 Rainer Bielefeld Retired 2011-06-10 02:57:32 UTC
RC2 is bit by bit identical with release version, so separate items in the version picker are useless. Changes have been discussed with Michael Meeks.
Comment 3 theWebalyst 2011-07-03 09:59:49 UTC
(In reply to comment #1)
> Please attach a sample spreadsheet document for which this happens.

I can't supply the spreadsheet because the two I tested contain confidential and I am no longer using 3.4, so cannot easily create other tests for you (3.4 is unusable on my system due to this bug).

However, I don't think this will stop you re-creating this bug because it seems unlikely to be dependent on my files. See next.

I can make some observations:

1) It is quite likely the bug is independent of the spreadsheet, because I encountered it on the first two of my spreadsheets that I edited after installing 3.4

2) In case it IS related to the spreadsheet I can tell you that both the spreadsheets had several worksheets. One is a large and complex spreadsheet (with about 30 worksheets some quite large), but the other is quite small (about 5 worksheets, each very simple: only very basic formula on each worksheet and only about 200 cells of data/formulae per worksheet).

Mark
Comment 4 theWebalyst 2011-08-02 04:56:34 UTC
I've updated this to "blocker" as it makes the software release unusable for those affected, and "high" because a smallish, increasing, and significant number of people will encounter it (being dual monitor specific).

Mark
Comment 5 Markus Mohrhard 2011-08-02 18:58:09 UTC
this is not a blocker, please read our definitions for blocker at: http://wiki.documentfoundation.org/Release_Criteria
Comment 6 theWebalyst 2011-08-03 01:53:54 UTC
(In reply to comment #5)
> this is not a blocker, please read our definitions for blocker at:
> http://wiki.documentfoundation.org/Release_Criteria

I had not read the definition of blocker but having done so I see that it DOES fulfill the conditions:
1) data loss
2) reproducable
3) regressive
4) no workaround

By all means reset it again, but please explain why.

Mark
Comment 7 Markus Mohrhard 2011-08-03 11:29:24 UTC
problem must affect most users or there must not be a reasonable workaround; it is bad to block the release and all users because of a corner case when a reasonable workaround exists 

It is not a general problem as for example I'm able to use Libreoffice with two monitors, so this seems to be a single case and no general behavior

this might be related to your graphic card driver not working correctly together with libreoffice but it is no blocker!
Comment 8 theWebalyst 2011-08-04 07:14:29 UTC
(In reply to comment #7)
Thanks for explaining your reasons for not being blocker. So why not critical: "crashes, loss of data, severe memory leak"

> It is not a general problem as for example I'm able to use Libreoffice with two
> monitors, so this seems to be a single case and no general behavior
Are you using Windows 7 64 bit? If not what? (As I recall, I didn't hit this on Windows XP 32 bit, so there may be some clues in this and the similar Linux bug (see ref in my original bug report above).
Comment 9 Markus Mohrhard 2011-08-05 19:23:43 UTC
I'm using a 3-4 build with win 7x64 and master and 3-4 builds with linux and don't have any problems with it. I don't think that this is a general problem as we would have much more bug reports about this already.

So I think that it might be the combination of our gui framework with your graphic driver.
Comment 10 Alyssa 2011-09-07 12:34:49 UTC
I am having this happen with Libre 3.4.1 with two different cases. One where the file size is reverted to the original for the blank doc (16KiB) and several where the file size remains the same, but there is no content left. Tried bringing over the backup of the same doc, it did exactly the same thing. 

Has anybody found a workaround for this? Since the file (with or without a name change) is automatically rendered empty when we try to bring over the file again.
Comment 11 Jackson Sul 2011-09-23 19:16:05 UTC
I also have this problem. I am not using two monitors (just my laptop), and am running the 32-bit Linux version (3.4.3). Like one of the cases Alyssa mentioned above, the file size remained as it did with the data in it, yet all the content disappears. It seems quite serious to me, especially because there is no error message when you save the file. I only discovered it after saving a spreadsheet then realizing a month or two later that all my data was destroyed!! 

I filed a separate bug before I saw this one, see:
https://bugs.freedesktop.org/show_bug.cgi?id=41056
Comment 12 Erwin 2011-11-06 15:16:07 UTC
I have a slightly different situation here, but the result is the same: unable to recover the file. This happend to me twice during the last seven days.
Actually it is a spreadsheet started back in 2007, and I used it since then with several versions of openoffice and now libreoffice (always under Suse/Opensuse, actual version: LibreOffice 3.4.2 OOO340m1 (Build:1206)).
Libreoffice signaled me a reading error in content.xml at position 2,264557 in one file.
Extracting content.xml and looking at it with firefox gave the following information: XML-Verarbeitungsfehler: Doppeltes Attribut
Adresse: file:///home/evo/Dokumente/finanzen/libreoffice/bugzilla/content.xml
Zeile Nr. 2, Spalte 264558:
I was unable to see what happend at this position. joe, vi and kwrite were unable such long lines in an effective way.

HW: AMD Athlon 64 X2, Nvidia GeForce 6150 LE
SW: Linux 2.6.37.6-0.7-desktop x86_64, openSUSE 11.4 (x86_64), 
  KDE:  4.6.00 (4.6.0) "release 6"

It might be interesting that the first report mentioned also x86-64 (AMD64).

The information contained in the spreadsheet is not intended to go public. Maybe somebody can instruct me about tools and how to find the informations at the position 2,264557.
Comment 13 Erwin 2011-11-07 13:55:58 UTC
Created attachment 53272 [details]
part of content.xml, position 264433 to 264783
Comment 14 Erwin 2011-11-07 13:59:46 UTC
I was finally able to open content.xml and to copy the position of the file, where the fault should lie. See "part of content.xml, position 264433 to 264783".
Comment 15 Björn Michaelsen 2011-12-23 12:25:53 UTC
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 16 Florian Reisinger 2012-08-14 14:01:28 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 17 Florian Reisinger 2012-08-14 14:02:33 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 18 Florian Reisinger 2012-08-14 14:07:09 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 19 Florian Reisinger 2012-08-14 14:09:14 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 20 Leo 2013-10-18 16:32:05 UTC
This happened to me in 4.1.1.2 and I lost a large data file.  Not going to mess with this anymore.  Can't stand programs that corrupt or lose data.  <:(  LKA