Apache OpenOffice Community Forum

When I open libre office calc file then it show error message "Format error discovered in the file in sub-document content.xml at 2,44475(row,col)"

Try this repaired file where some of the styles will appear differently.

There were multiple instances of corrupted style definitions (IIRC T5, T31 and T32) where they were reported as having duplicate attributes. As I don't know XML well enough to identify which duplicates were causing the problem I copied T1 and pasted it for T5, T31 and T32.

This is a well known bug in AOO - you are strongly recommended to move to LO which does not have this bug.

@ John_Ha
Thank you so much

Again I am stuck..
When I open libre office calc file then it show error message "Format error discovered in the file in sub-document content.xml at 2,44475(row,col)"

please help me once again.

Opened without error for me - I have resaved it, and attach that file; perhaps it will open for you.

The file gave no error in content.xml, although the Saved file is now considerably smaller.

# RoryOF....... thank you so much

kindly elaborate the complete process of recover of this type of error.

Kindly Plz help me again
Format error discovered in content.xml at 2,44475(row,col)
plz plz

spandeyji wrote: ↑Tue Aug 02, 2022 7:57 am ...
kindly elaborate the complete process of recover of this type of error.

https://forum.openoffice.org/en/forum/v ... p?t=108191

Open a copy of the .ods file with an archiver (typically winzip or 7-zip). Extract content.xml (or the file in which Open- or Libre-Office identifies the problem). With an XML editor verify the code contained in the extracted .xml file, and make any adjustments necessary to get the code to pass inspection. Then reinsert the repaired .xml file, close up the archive, and pray that it will work.

If you are repeatedly getting errors in this one Calc file, as seems to be the case, I think you need to revise the formatting you are applying. I cannot identify precisely what is causing the problem: do you need all this formatting?

There is probably something wrong with the file.

1. File > New > Calc spreadsheet.
2. Copy the contents of the old file and paste them into the new, empty file.

Does that fix it?

John_Ha wrote: ↑Tue Aug 02, 2022 10:43 am There is probably something wrong with the file.

1. File > New > Calc spreadsheet.
2. Copy the contents of the old file and paste them into the new, empty file.

Does that fix it?

No .....it can not fix.

spandeyji wrote: ↑Tue Aug 02, 2022 12:02 pm

John_Ha wrote: ↑Tue Aug 02, 2022 10:43 am There is probably something wrong with the file.

1. File > New > Calc spreadsheet.
2. Copy the contents of the old file and paste them into the new, empty file.

Does that fix it?

No .....it can not fix.

What I meant is you should create the new file and use it for a few days. The new file should not give the Format errors which the old file gives.

John_Ha wrote: ↑Tue Aug 02, 2022 2:26 pm

spandeyji wrote: ↑Tue Aug 02, 2022 12:02 pm

John_Ha wrote: ↑Tue Aug 02, 2022 10:43 am There is probably something wrong with the file.

1. File > New > Calc spreadsheet.
2. Copy the contents of the old file and paste them into the new, empty file.

Does that fix it?

No .....it can not fix.

What I meant is you should create the new file and use it for a few days. The new file should not give the Format errors which the old file gives.

ok.... I will definitely do this for next time. Now last time recover this attached file. Plz

See how this looks; and I strongly suggest, in addition to what John_Ha suggests, that you adopt some form of incremental backup process. You might consider installing the Timestamped backup extension, which will allow you to make multiple, timestamped backups of your document. Note that this must be invoked separately from your normal Save.