[Dropped] Spreadsheet format error; won't load

[geraldgu]

Support help details.odt

This file explains my concern.

(19.37 KiB) Downloaded 183 times

When I attempt to open a certain file, I get this message. Is the file recoverable? I have an editor, and attempted to look at row 2, column 215018; but according to the editor, it doesn't exist. The last column on that line is 2.
What should be my next step, or is it hopeless?

read-error.png (6.06 KiB) Viewed 2340 times

[Hagar Delest]

Hi and welcome to the forum!

I've edited your post to actually add the message and the screenshot. Please read the Survival Guide for the forum.

There are plenty of topics about how to fix this issue. See: [Tutorial] Format error discovered in sub-document.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the *EDIT button if your issue has been fixed.

[RoryOF]

The speediest solution will be to upload the damaged file (a copy not over-Saved by any later attempts to fix) and someone will examine it and attempt to fix it. One needs to examine the innards of such a file using an XML editor and remove one or more erroneous internal tags.

Edit: Text (Writer) documents are often more easily recovered than spreadsheet documents, but someone will try if a file is available.