Having worked through and resolved a similar problem today, allow me to make a comment.
The XML file is corrupted. Upgrading OOo to 2.0.1 is good suggestion but it will probably still not be able to read the XML file. Cyrille Moureaux was kind enough to give this advice earlier... >The one thing you can do is manually forcing an extraction of the >contents of the ods or sxc file (considering it as a zip file, which is >what it is) into a directory, then editing the file content.xml that >will be there to have a look at what's on the 4425th character of the >2nd line (unfortunately, by default there are only two lines in any XML >output by OOo, so you're probably better off doing this with an >understanding editor that lets you access a given character offset in >the file). You can also try and open this file with an XML editor which >could tell you what the problem is. If (like me) you're on XP, double clicking on the xml file will get MS to parse/display it and the error message is a bit more helpful than OOo Calc. Dave On 1/6/06, Alex Gettinby <[EMAIL PROTECTED]> wrote: > > Hi. > > I tried using version 2 (Using Open Office.org Calc - Is that the right > one for Ods file?), > But now it comes up with this slightly different message when I try to > open existing spreadsheet: > > Read-Error. > Format error discovered in the file in sub-document content.xml at > 2,8459(row,col). > > Any other suggestions please? > > ---------- > > Paul sent you one way to retrieve your data. > I have a second suggestion. You are using a Beta version of > OpenOffice.org (OOo), and they usually contain some bugs. You may well > have > found one. (I know that I had problems with the database in your version.) > My > suggestion to you is that you get the 2.0.1 version of OOo. This should > correct the problem. If it does not, please reply back to this list: > [EMAIL PROTECTED] > > Dan > ----------- > > > Hi. > > > > I am using open office spreadsheet. But on too many occasions in the > last 6 > > months, when I have saved my work, the file has become corrupt next time > > ive tried to open it. And I have lost lost a hell of a lot of work. I > make > > back-up copies of the ODS. file but they become corrupt at the same > time, > > then I have have to re-input all of the data again. > > > > Re-starting the PC doesnt help. I uninstalled the software and > reinstalled > > it again V.1.9.79 This hasnt helped either. It doesnt happen everytime i > > use it. In the last few days it was competant enough to save and then > > re-open the following day. Last time a problem happened, All of the data > > must have been wiped off the file because usually it is around 1,900kb > but > > then it suddenly diminished down to 2kb! and so did the copy I made the > day > > before. > > > > This time though, It still says 1,900 kb of data is still there, but > when i > > try to open the file in open office, the following error message > appears: > > > > Read-Error > > > > Format error discovered in the file in sub-document $(ARG1) AT > > $(ARG2)(row,col). > > > > I have tried opening it up on another PC on the network, and it comes up > > with the same message. > > > > Please can you help, as I have a lot of work on it, and am not willing > to > > re-input it again for the 4th time in 6 months, So fear that I may have > to > > stop using Open Office. > > > > Please can you email me back at this address to suggest what can be > done. I > > have just subscribed in the mailing list. > > > > many thanks. > > > > Alex > > > > > > > > > > > -- > ___________________________________________________ > Play 100s of games for FREE! http://games.mail.com/ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com
