Bug 146595

Summary:	Cannot open file ods
Product:	LibreOffice	Reporter:	bindajp <bindajp>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	miguelangelrv, serval2412
Priority:	medium
Version:	7.2.4.1 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Spreadsheet with 5-6 sheets

Description bindajp@videotron.ca 2022-01-05 17:53:28 UTC

Description:
getting the following message when trying to open an ods file 
Erreur de lecture.
Erreur de format dans le fichier du sous-document content.xml à la position 2,4927088(row,col).

Steps to Reproduce:
1.Click on file to open
2.
3.

Actual Results:
getting blank page with error message (as above)

Erreur de lecture.
Erreur de format dans le fichier du sous-document content.xml à la position 2,4927088(row,col).

Expected Results:
normal sheet


Reproducible: Always


User Profile Reset: No



Additional Info:
file can be supplied if necessary

Comment 1 Julien Nabet 2022-01-05 18:28:34 UTC

How the file has been generated? I mean is it an old file and from 7.2.4 you got this error for example?

Do you have any backup file without this error that you could try on 7.2.4?

Comment 2 bindajp@videotron.ca 2022-01-05 18:39:29 UTC

(In reply to Julien Nabet from comment #1)
> How the file has been generated? I mean is it an old file and from 7.2.4 you
> got this error for example?
> 
> Do you have any backup file without this error that you could try on 7.2.4?

This is an old file that has gone correctly through many versions of calc.
bug does not seem to come from 7.2.4...
no back up (I know... ).

Comment 3 Julien Nabet 2022-01-05 20:30:13 UTC

If the file doesn't contain anything private/confidential, you may attach it here so we can try to debug it.

If not, you can make a backup of your file first then:
- rename it into zip and unzip it.
- use a tool like notepad++ to go to second line and find the character 4927088 to see if you can detect and fix the pb.
- rezip the whole directory and rename it to ods
This solution is not for a beginner but can work.

Comment 4 Julien Nabet 2022-01-05 21:42:18 UTC

To attach a file means anybody can access it.
Usually we advise to sanitize it (see https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission) but since you can't even open it, you won't be able to sanitize it.

Comment 5 m_a_riosv 2022-01-05 21:54:40 UTC

I think you can find in the forum, what happens.

https://ask.libreoffice.org/t/i-can-not-open-my-spreadsheet-it-comes-up-with-this-error-read-error-format-error-discovered-in-the-file-in-sub-document-content-xml-at-2-72157-row-col/8576

Comment 6 bindajp@videotron.ca 2022-01-07 18:22:52 UTC

Created attachment 177383 [details]
Spreadsheet with 5-6 sheets

I'm not technically good.  Can someone fix the bug on this spreadsheet and send it back to me?  Would be really appreciated.

Comment 7 m_a_riosv 2022-01-08 11:40:03 UTC

Sorry, this is not the place, please do your request in the forum.