Bug 76434 - FILESAVE: calc-spreadsheet gets destroyed randomly during save
Summary: FILESAVE: calc-spreadsheet gets destroyed randomly during save
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.5.3 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
: 76437 (view as bug list)
Depends on:
Blocks:
 
Reported: 2014-03-21 10:03 UTC by pfund_salz
Modified: 2015-05-07 07:32 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
The calc-file in which the explained problem occurs (48.97 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-03-21 10:03 UTC, pfund_salz
Details
The table before the error (34.11 KB, image/png)
2015-05-06 15:22 UTC, pfund_salz
Details
The table after the error (34.80 KB, image/png)
2015-05-06 15:23 UTC, pfund_salz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description pfund_salz 2014-03-21 10:03:43 UTC
Created attachment 96146 [details]
The calc-file in which the explained problem occurs

Problem description: 

A specific calc-file (see attached file) gets destroyed randomly during save process

Steps to reproduce:
1. Open the attached file
2. Change the cell 1_stack1:L29 to 840 - or any other content the vlan-column
3. Save the file
4. Close calc
4. Re-open the file in calc and check the leftmost tables. In approximately 7 of 10 cases the data and the layout in some of the leftmost tabs is mixed up and the data and layout is lost.

Current behavior:
The data in one or more of the leftmost tables is mixed up randomly.

Expected behavior:
The data should keep the same unless it is changed by the user.
              
Operating System: openSUSE
Version: 4.1.5.3 release
Comment 1 sophie 2014-04-03 09:49:10 UTC
*** Bug 76437 has been marked as a duplicate of this bug. ***
Comment 2 Buovjaga 2014-10-29 13:01:11 UTC
I tried editing a different value, saving and reopening 11 times, but didn't get any data mix up or lost layout.

I observed that when I changed a value, the corresponding cell in "Cisco 3750" table immediately lost its bg color and the font size changed from 8 to 10. But this was not the issue of the original report.

Please test with latest stable version or master. If you still observe it, I will set back to UNCONFIRMED and ask for other testers.
Please also attach a screenshot where it shows "mixed up data and lost layout".

Tested on Win 7 64-bit Version: 4.4.0.0.alpha1+
Build ID: 4586a3f564600f1a0ce15a5cb98868b43bb9351e
TinderBox: Win-x86@42, Branch:master, Time: 2014-10-29_07:28:16
Comment 3 QA Administrators 2015-05-06 14:15:07 UTC
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INVALID
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
 
Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team
Comment 4 pfund_salz 2015-05-06 15:22:49 UTC
Created attachment 115387 [details]
The table before the error

The table in the correct version, before editing and saving something.
Comment 5 pfund_salz 2015-05-06 15:23:29 UTC
Created attachment 115388 [details]
The table after the error

The table in the corrupted version, after editing and saving something.
Comment 6 pfund_salz 2015-05-06 15:30:43 UTC
Sorry for the late answer.
I tried to reproduce the mentioned behaviour, and sadly I had success. The error occured both using Linux (Libreoffice 4.1.4.2) and Windows (Libreoffice 4.1.3.2). Please see the attached image files.
I will install the latest Libreoffice-Release tomorrow and check once more.

Many thanks for your help!
Comment 7 Buovjaga 2015-05-06 15:34:44 UTC
(In reply to pfund_salz from comment #6)
> Sorry for the late answer.
> I tried to reproduce the mentioned behaviour, and sadly I had success. The
> error occured both using Linux (Libreoffice 4.1.4.2) and Windows
> (Libreoffice 4.1.3.2). Please see the attached image files.
> I will install the latest Libreoffice-Release tomorrow and check once more.
> 
> Many thanks for your help!

Yep, I bet you can then set to WORKSFORME :) because I still can't reproduce.

Ubuntu 15.04 64-bit 
Version: 4.4.2.2
Build ID: 40m0(Build:2)
Locale: en_US

Win 7 Pro 64-bit Version: 5.0.0.0.alpha1+ (x64)
Build ID: 98436c4b53639d86f261ac630c46d32e3c7b8e28
TinderBox: Win-x86_64@42, Branch:master, Time: 2015-05-04_00:07:10
Locale: fi-FI (fi_FI)
Comment 8 pfund_salz 2015-05-07 06:37:52 UTC
I tried again, this time using Libreoffice 4.4.2.2 (Linux, Build-ID: c4c7d32d0d49397cad38d62472b0bc8acff48dd6 Language environment; de_DE) and it seems that the problem does not ccour any more.

Many thanks for your support, I'll keep supporting your project by another donation. :)
Comment 9 Buovjaga 2015-05-07 07:32:15 UTC
Ok, let's set to WORKSFORME as we don't know the commit that fixed it.