Bug 62348

Summary:	FILEOPEN: Read error. An unknown error has occurred.
Product:	LibreOffice	Reporter:	devMgr
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	kobzeci, LibreOffice
Priority:	medium
Version:	3.6.5.2 release
Hardware:	Other
OS:	Windows (All)
Whiteboard:	BSA
Crash report or crash signature:		Regression By:
Attachments:	Unreadable in LO v3.6 and v4.0

Description devMgr 2013-03-14 18:49:40 UTC

An ods file is being used in "multi-writer" mode. (Its "Share this spreadsheet with other users" attribute is set True.)

All (7) workstations sharing the file are currently on LO v3.6.5.2. Over the lifetime of the problem some have been on earlier versions (e.g. 3.4 etc).

From time to time (not every time) over the past few months, on opening, the above error message (see Subject) is displayed. No additional information is available. 

The remedy has been to restore a working copy from a snapshot or backup. This has usually resulted in loss of data.

As a variation, I recently tried presenting the same file to MS Excel (2007 SP3 build 12.0.6665.5003). There it is handled differently. The first message is "Excel found unreadable content in 'xxxx.ods'. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."

On clicking Yes, the broken file is opened and the contents displayed. The message is "Excel was able to open the file by repairing or removing the unreadable content". Another pop-up links to an xml file that purports to offer further detail regarding the repair, but no real info is contained.

A sample (broken) ods file is available if that is likely to be of help - subject to owner's agreement.

Operating System: Windows XP
Version: 3.6.5.2 release

Comment 1 Rainer Bielefeld Retired 2013-03-19 05:32:22 UTC

@devMgr@realcom.co.uk:
We need a test kit and a simple, brief, precise description how to reproduce your problem using that test kit

Comment 2 devMgr 2013-03-21 14:42:07 UTC

Created attachment 76866 [details]
Unreadable in LO v3.6 and v4.0

Comment 3 devMgr 2013-03-21 14:46:14 UTC

No 'guaranteed path to failure' available ... occurrence of problem unpredictable.

A sample 'broken' file (capable of being read by MS Excel, but not by LO) is attached.

Comment 4 QA Administrators 2013-09-24 01:44:08 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/FDO/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 5 Zeki Bildirici 2013-10-02 13:32:39 UTC

I can confirm it with LibreOffice 4.1.1.2. I've tried to open the file with Gnumeric and the file opens normally, no error messages, no format erros, no performance problems. 

If you resave the file with Gnumeric in ods format, LO can open the file without any problems.

As far as i know Microsoft's ODF version causes this warning, but i dont know is it possible to corrupt the file in saving process.

Best regards,
Zeki

Comment 6 Teo91 2014-02-14 13:31:24 UTC

This bug is no more in LO 4.2.0.4: the file is opened smooth without errors.

Setting to WORKSFORME.