Format Error Discovered Open Office
Contents |
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 +0200 LGC 1 ●1 libreoffice read error ●1 ●1 updated 2016-03-09 21:16:26 +0200 Alex Kemp 10154 ●13 ●35 ●34 http://etmg.altervista...
Openoffice Read Error
How can i open up the spreadsheet with this error: Read-Error. Format error discovered in the file in sub-document content.xml at libreoffice read error format error 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 was accepted by Alex Kemp close date
Openoffice Corrupted File Recovery
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 extension to zip and open the container. You will see repair ods file 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 )editThanks for this answer.PJK( 2014-10-16 18:58:34 +0200 )editCould someone explain that simpler and take me through step by step??jack.lovegrove( 2014-10-19 23:32:11
index The team • Delete all board http://ooo-forums.apache.org/en/forum/viewtopic.php?f=6&t=79142 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
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 file 'file.odt' is corrupt and therefore cannot be http://www.andybrain.com/archive/mb/open-office-data-recovery.htm opened. Should OpenOffice.org repair the file? The file 'file.odt' could not be repaired and https://udinra.com/blog/openoffice-libreoffice-read-error-content-xml 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, if one exists. 2) Do you have the latest version of OpenOffice.org installed? If read error 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.) 4) Find backups. If you've checked the "Always create backups" in the OpenOffice settings, OpenOffice.org keeps backups of all your files at libreoffice read error 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 directory. In Windows, browse to this folder: C:\Documents and Settings\USERNAME\Local Settings\Temp This will probably be a pretty messy place, and lots of the folders and files have meaningless names, but sort the results by the "Date Modified" column and look at the results.
in sub document content.xml solution OpenOffice is a must have software in my arsenal.It is free and easy to use.But recently I faced weird problem using this software.I was working on conversion of CSV file to Word file.During this process I was facing a strange problem while opening a file.OpenOffice failed to open the file.It was throwing below message while opening the file Read-Error format error discovered in the file in sub-document content.xml at 219,64 (row,column) Honestly I never faced such problem before.I was wondering whether my conversion program has some issues.But after spending some time I found the conversion program is working fine.The problem was with OpenOffice.So I installed LibreOffice.I tried opening the file in LibreOffice as well.LibreOffice was also throwing the same problem.After that I mailed the file to my friend with Microsoft Office.The file opened successfully in Microsoft Office.This confirmed my thought that the problem is with OpenOffice only.LibreOffice is based on OpenOffice only.After spending sometime with the file and analyzing the location reported by OpenOffice I was able to solve the problem. There is not much available on Internet as well about this problem.So I am reproducing all the steps here.Later in the tutorial I will share some observations which might save you lots of time.You can directly modify your file without following below steps.Extract the file using 7 Zip.I prefer 7 Zip.But other extraction programs may also work.It is better to extract the file inside a new folder.So that you are aware of all the files generated by extracting the file.You can see styles.xml,mimetype,meta.xml and content.xml files inside the extracted folder.Apart from these files there is also META-INF folder.Now open the content.xml file with any text editor.I would recommend using Notepad++.Notepad++ is an excellent multi purpose text editor software.I have written separate post on its search and replace capabilities.It can search and replace text in multiple files within a directory.In case you are interested then you can read the post here.The problem with Notepad and Wordpad are that they do not show line numbers.So it is tough to find out the problem reason.Notepad++ gives you line numbers.The error message have row and column.The row corresponds to line number.So Notepad++ makes it easier to locate the