Error Reading File Openoffice
Contents |
index The team • Delete all board
Openoffice Read Error Format Error Discovered
cookies • All times are UTC + 1 hour [ DST ] Forum powered by phpBB © phpBB Group By any use of this Website, you agree to be bound by these Policies and Terms of Use Get OpenOffice
my spreadsheet it comes up with this error: Read-Error. Format error discovered in the file in sub-document content.xml at 2,72157(row,col). [closed] edit spreadsheet error calc asked 2014-05-22 18:43:56 openoffice read error picture +0200 LGC 1 ●1 ●1 ●1 updated 2016-03-09 21:16:26 +0200 Alex Kemp 10154
How To Read Open Office Excel File In C#
●13 ●35 ●34 http://etmg.altervista... How can i open up the spreadsheet with this error: Read-Error. Format error discovered in the how to read open office excel file in java file in sub-document content.xml at 2,72157(row,col). the calc spreadsheet is where my file is. edit retag flag offensive reopen merge delete Closed for the following reason the question is answered, right answer https://forum.openoffice.org/en/forum/viewtopic.php?f=7&t=27164 was accepted by Alex Kemp close date 2016-03-06 13:08:02.179436 CommentsFor some reason, I have a gold badge, but no karma, so I can't upvote. Great question!Ackbeet( 2014-09-27 18:46:49 +0200 )editadd a comment 5 answers Sort by ยป oldest newest most voted 2 answered 2014-05-22 23:20:03 +0200 Regina 6200 ●21 ●49 The file is corrupt. Make a copy and work on the copy. Change the file name http://ask.libreoffice.org/en/question/34411/i-can-not-open-my-spreadsheet-it-comes-up-with-this-error-read-error-format-error-discovered-in-the-file-in-sub-document-contentxml-at-272157rowcol/ extension to zip and open the container. You will see the file content.xml. Open the file in an editor and go to the place mentioned in the error message. If you are lucky you will detect the error, for example a duplicate attribute. Repair it and save the corrected content.xml to the old place. Leave the container and change the file name extension back to ods. If you do not detect the error, you can try to open the file content.xml in another application, for example in a browser and perhaps get a more detailed error message. If you are still without success, I fear, repairing is not possible. Do you have enabled to generate a backup? Then goto your LO user directory and look at the backup folder. Hopefully you find a version not too old. You might be able to extract the cell contents from the file content.xml. It is not a binary file, but human readable. But that is very tedious. edit flag offensive delete link more CommentsFantastic answer! Detailed, and it worked for fixing my problem, which had the same error message as LGC. Thanks much!Ackbeet( 2014-09-27 18:47:25 +0200 )
Draw, Impress, Math or Writer. You might see scary error messages like these: Read-Error. Format Error discovered in the file in sub-document styles.xml at 2,2568(row,col) The http://www.andybrain.com/archive/mb/open-office-data-recovery.htm file 'file.odt' is corrupt and therefore cannot be opened. Should OpenOffice.org repair the file? The file 'file.odt' could not be repaired and therefore cannot be opened. General Error. General input/output error. A little intimidating, and not good to see. Try the following to recover OpenOffice data (and make sure you have a backup of the original problem file, just in case): 1) Restore from backup, how to if one exists. 2) Do you have the latest version of OpenOffice.org installed? If not, download it, install it, and try to open the file again. 3) Insert the file. Open a blank file in OpenOffice. Go to the "Insert -> File" menu and insert your corrupted file. (For spreadsheet, Calc or ODS documents, instead use the "Insert -> Sheet from File" menu option.) openoffice read error 4) Find backups. If you've checked the "Always create backups" in the OpenOffice settings, OpenOffice.org keeps backups of all your files at this location: C:\Documents and Settings\USERNAME\Application Data\OpenOffice.org\user\backup Browse to that location and see if your file is there. It will have the same filename as your original, only with a .BAK extension. Copy it somewhere else and open it with OpenOffice. 5) Rename as a ZIP file. Change the extension of your OpenOffice.org document from whatever it is (like ODT, ODS, ODP, ODG, ODB, ODF) to a ZIP extension. Then open the file using Microsoft Windows or WinZip. If you're lucky, you'll see a bunch of files contained in this newly-created Zip file. One of them is called "content.xml". Open this file with any text editor, and you may find your document text. It will have a bunch of formatting statements you'll have to delete, but the actual text should be there too. Alternatively, you can try deleting the "styles.xml" document, rename the file back to an OpenOffice.org extension, and try opening the file as normal. Sometimes removing the styles.xml from the document does the trick. 6) Look in your Temp