Libracalc can't open my file -help

[xfred2000]

i spent 2 weeks working on an electronic chip database system in libracalc, one of the sheets called test (last sheet), was my template, i had all my calculations and was building the main structure. i went and saved it yesterday, and today i can’t open the file. i had just days before installed libraoffice 6.1 everything was working, and then this.

Read Error.
Format error discovered in the file in sub-document content.xml at 2,295962(row,col).

the file is called “my parts & prices.ods”

i checked and the data is all their. just can’t do anything with it. thank you.

My Parts & prices.ods

[mikekaganski]

Here is the recovered file. The original has contained a couple of unpaired table-row-group elements which I have removed. You need to check the file carefully for data correctness.

Using 6.1 (which is currently in Fresh channel) assumes that you realize that this version might contain more bugs than Still version, and so you need to take proper care of your backups and other measures to keep data safe.

[erAck]

It’s exactly one stray </table:table-row-group><table:table-row-group>, isn’t it? So something assuming a group ended where there was none, and starting a new group (probably a consequent error). Likely code in sc/source/filter/xml/xmlexprt.cxx ScXMLExport::CloseRow() call to pGroupRows->IsGroupEnd(nRow) does erroneous things, code in caller and callee are quite old though.

[mikekaganski]

It’s exactly one stray </table:table-row-group>table:table-row-group, isn’t it?

Exactly! Thanks for analysis. If there appears a reproducible case with its bug#, we could definitely use this.

[xfred2000]

MIKE!
THANK YOU!!!
that is AWESOME… i just started in libra calc two weeks ago, have not used spreadsheet apps before. i’m a collector of electronic parts and have wanted for a long time to make a catalog of everything i have, major undertaking.

thanks guys for the help!