Bug 84924 - FILESAVE Unexpected error cause software crash when saving as .xlsx with Edit Changes on
Summary: FILESAVE Unexpected error cause software crash when saving as .xlsx with Edit...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2.6.3 release
Hardware: x86 (IA32) Windows (All)
: medium critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-10-11 23:36 UTC by Alan Jenkin
Modified: 2014-10-23 14:09 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Last successful save before the unexpected error. (145.42 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-10-11 23:36 UTC, Alan Jenkin
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Alan Jenkin 2014-10-11 23:36:51 UTC
Created attachment 107727 [details]
Last successful save before the unexpected error.

Revising a .xlsx spreadsheet with changes recorded - when I attempt to save, Libre Office reports an unexpected error.  Libre Office cannot restore because it says file is locked.  I can only open in read only mode or as a copy.  Trying either of these and saving again causes same error.

This is critical because I am working on a collaborative document with a deadline.
Comment 1 m_a_riosv 2014-10-12 00:30:11 UTC
Hello  Alan Jenkin,
Thank you for reporting the bug.

I can't reproduce the issue:
Win7x64
Version: 4.2.6.3 Build ID: 3fd416d4c6db7d3204c17ce57a1d70f6e531ee21

Please, to be certain the reported issue is not related to corruption in the user profile, could you rename this LibreOffice user directory ( see https://wiki.documentfoundation.org/UserProfile#Default_location or http://ask.libreoffice.org/en/question/903/where-are-the-libreoffice-data-profile-files/ ) and re-test?
Comment 2 Alan Jenkin 2014-10-12 15:08:08 UTC
It would not let me rename, since the file was locked.  I closed the file (unable to save changes) and renamed the user profile.  Now I have lost my changes.  Will test again with more frequent saves to see if it works.

I can't send you the actual file that was causing the problem, since I can't save it!
Comment 3 Alan Jenkin 2014-10-12 15:27:10 UTC
The first save crashed Libre Office, but the file could be restored successfully.  The second crashed it and locked it out again, with the message: 

Document file '20141006%20Loss-management-benchmarking%20Rev%201%20(2).xlsx' is locked for editing by:

Unknown User

Open document read-only or open a copy of the document for editing.

PLEASE LET ME KNOW HOW I CAN FIX THIS.
Comment 4 m_a_riosv 2014-10-12 20:55:46 UTC
Please don't change the status to ASSIGNED, this must be done for the developer taking the bug to solve it. Revert to UNCONFIRMED, the best way to get attention, if not was set up as NEW for someone.

Are you saving in a network driver?
Please when opening the file, try first with a single click on the file without open, and wait a bit (about three second) before double click for open.
Comment 5 Alan Jenkin 2014-10-12 21:28:43 UTC
OK - I changed the status to Unconfirmed.

I'm saving to a drive on my own computer.  BTW, I've been using the same process on Libre Office documents (not spreadsheets) and am having no problems.  When I've finished my updates I email them to the team.  I suspect the others are all using Microsoft Office, but don't know for sure.

I opened the file again by clicking on its name in the Libre Office Recent Files, and after the first update Libre Office crashed when I saved the file.  I attempted to recover and got the message:

"The file '$(ARG1)' is corrupt and therefore cannot be opened. LibreOffice can try to repair the file.

"The corruption could be the result of document manipulation or of structural document damage due to data transmission.

"We recommend that you do not trust the content of the repaired document.
Execution of macros is disabled for this document.

"Should LibreOffice repair the file?"

Any other suggestions?
Comment 6 Alan Jenkin 2014-10-12 21:31:38 UTC
OK - that message was misleading - it refers to another spreadsheet I had open.  Is it possible that my Libre Office installation is corrupted?  I can reinstall, if so.

The recovery worked OK for the file I'm updating.
Comment 7 Joel Madero 2014-10-23 01:50:36 UTC
So I would suggest a fresh profile, complete uninstall of LibreOffice, and an install of 4.3 http://libreoffice.org/download

See if you can reproduce with a clean profile with 4.3
Comment 8 Alan Jenkin 2014-10-23 13:45:09 UTC
Using 4.3 seems to have solved the problem.  Thanks.
Comment 9 Joel Madero 2014-10-23 14:09:58 UTC
Awesome! Setting as WORKSFORME as 4.2 is EOL (or quickly approaching it).