Ask Your Question

libracalc can't open my file -help

asked 2018-09-05 19:59:43 +0100

xfred2000 gravatar image

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.

C:\fakepath\My Parts & prices.ods

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-09-05 20:21:57 +0100

updated 2018-09-05 20:25:28 +0100

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.

edit flag offensive delete link more


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.

erAck gravatar imageerAck ( 2018-09-05 20:49:35 +0100 )edit

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.

Mike Kaganski gravatar imageMike Kaganski ( 2018-09-05 21:17:17 +0100 )edit

answered 2018-09-05 21:13:39 +0100

xfred2000 gravatar image

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!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-09-05 19:59:43 +0100

Seen: 107 times

Last updated: Sep 05 '18