[Closed] Read Error. Format Error discovered in the file …

[CLD3]

Hi there.

I know this has been covered in many previous threads. I have tried the help tutorial myself, but I am struggling to get XML Copy Editor to open my file.
I have an Open Office Calc file previously made in Excel, but now only used in OO Calc. When I tried to open the file today I received an error:
Read Error: Format Error discovered in the file in sub-document context.xml at 2,223751 (row, col)

Is there anyone who could take a look at the file and see what is wrong?

[FJCC]

Can you upload the file to the forum?

[CLD3]

Here you go.

Thanks in advance for any help.

[FJCC]

I cannot extract the content.xml from the zip file. I tried on both a Windows and a Linux system. Maybe someone else will have more luck but that isn't a good sign.

[RoryOF]

I could not get content.xml on a linux (Xubuntu 20.04.1) system; it reported that file checksum was wrong.

[Villeroy]

I can unzip the file. But I can't fix it right now. The error is at position 253523

[John_Ha]

I can unzip the file. But I can't fix it right now. The error is at position 253523

I have never seen a file like this before. content.xml is very badly corrupted and, in my opinion, there are so many errors (hundreds) it is not recoverable not least because it is not obvious how the corruption should be corrected.

Some of the XML tags have been incorporated into the text strings so something really horrible has happened. Text stringss have been truncated.

This is a typical corruption:

Code: Select all

<text:p>0.00%</text:p>Sidewindefice:value="7.8">

I think Sidewind should be Sidewinder and fice:value="7.8"> should be a tag office:value="7.8">

[MrProgrammer]

Hi, and welcome to the forum.

I have an Open Office Calc file previously made in Excel, but now only used in OO Calc.

• First, the ZIP archive is damaged. The "bad CRC" message for a single file suggests to me that the damage occurred after the content was processed by the ZIP process but before the data was written to disk. Perhaps the ZIP dictionary has been overlaid with garbage.

 extracting: mimetype                
  inflating: Configurations2/accelerator/current.xml  
 extracting: Thumbnails/thumbnail.png  
  inflating: content.xml              bad CRC 0d092a28  (should be 144a2b72)
  inflating: settings.xml            
  inflating: styles.xml              
  inflating: manifest.rdf            
 extracting: meta.xml                
  inflating: META-INF/manifest.xml

• Next, I find content.xml to have errors.

</table:table-cell>
<table:table-cell office:value-type="string">
<text:p>
2:10 Wolverhampton Autumn Tonic="string">
<text:p>
Van Velde</text:p>
</table:table-cell>
<table:table-cell/>
<table:table-cell office:value-type="string">
<text:pble-cell office:value-type="string">
<text:p>
Lay</text:p>
</table:table-cell>
<table:table-cell/>
<table:table-cell office:value-type="string">
<text:p>
2.75</text:p>
</table:table-cell>
<table:tablece:value="25.28">
<text:p>
25.28</text:p>
</table:table-cell>
<table:table-cell table:number-columns-repeated="2" office:value-type="float" office:value="2.74">
<text:p>
2.74</text:p>
</table:table-cell>
<table:table-cell table:style-name="ce18" office:value-type="pT>
<table:table-cell office:value-type="string">
<text:p>
Lost</text:p>
</table:tEi"stpooltableout1008"/>
e="pT>
<table:table-cell office:value-type="string">

• These problems get worse later on. Your content cannot be recovered.

<ta11e:value-e-celbl eltvBarclayHu0ulable:017i3e-e-celbl table:s3.9value-e-cab.984/tall>
<tv:pBournemelel>
<ta11e:value-e-celbl 99r-0ulable:4e-csterFyue-:4e/tabll ta:tablx9<utatal<tel3.6lto Scorlp:.:p>
</tablce:A4xpetay.1abe-e-celbl t7rlpercentage</tablce:A4xpetat.ccel/table:t2.00%<ta11e:value-e-celbl t7sporble-cel/tab688 spo0.0016olil ell4/tall>
<tv:pBournemelel>
<lil ell tab 2  olil ell tab 2  olil ell tab 2  o0bbl t7sp7:3le-cel/table:tlrnbv:p>
<l ell tab 2  olil ell tab 2  olil ell tab 2  olil ell tab 2  o0bbl t7sSouthfi9ld RoyalevBarclayHu0ulablble:017i3e-e-tablev:p>
</t-ty-e:sty:p>
<" ofG884/tall>
<tv:pleournemelel>
<ta11e:value-e 96nbblr:tlrnbv:p>
<l ell tab 2  olil ell tab 2  olil ell tab 2  olil ell tab 2  o0bbl t7sSunbBarclayHu0Back<ta11e:e</ele592alue-e-celbl t7sporble-cel/table:tlrnbv:p>

[John_Ha]

For what it's worth - and it isn't worth much - this is the user content remaining in the file. As you can see it is badly corrupted with XML commands.

[CLD3]

Hi there,

Thanks to all for looking at this. I'm really not sure what happened to the file. I have been using it for many years. I'll admit defeat and start a new one!
I appreciate all the effort you have all gone to. Thank you.