Recover Data di OpenOffice

Recovering data from corrupted files in OpenOffice documents

So you've been using OpenOffice.org and you have a corrupted file in programs like Base, Calc, 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 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, 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.) 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 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. Look for files and folders that were last modified on the date and time you last had a working file. For each file (look in sub-folders too), perform the steps in option 4, above: Rename the file with a ZIP extension and try to open the resulting "content.xml". 7) Text string search: Run a search on your entire computer. Search all files, and search for a unique phrase or word you are sure is contained in your document text. Source: http://www.andybrain.com/archive/mb/open-office-data-recovery.htm