Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have 2 old documents in ODT format that I either made a typo or forgot the actual password for them. I want to recover the password or simply remove it. What steps (If available) are there to remove such password (and remind me of not put passwords to documents).

share|improve this question
    
First, install xmlcopyeditor from the repositories. Open the content.xml file by right clicking the document from the file manager and choosing Archive Manager as the application. Open content.xml with xml copy editor and find protected=true. Change it to false and your document will no longer me protected. It's possible to edit the file with a text editor but it tends to choke and lock up your system for a while. – Christopher Jun 29 '14 at 14:52
    
@Christopher uhm... content.xml is encrypted. And what would be the point of the encryption if disabling it were as easy as changing protected to false? The file that actually contains information about the encryption used is found in META-INF/manifest.xml. – Nathan Osman Mar 12 at 9:51
    
It's to keep the typical user from changing protected areas. I've decrypted many documents by this method. I've passed on some protected spreadsheets to people; not expecting anything more than them not breaking the formulae. – Christopher Mar 13 at 12:38
up vote 4 down vote accepted

About LibreOffice encryption

I found 2 interesting links. From the links Libreoffice seems to use AES (http://en.wikipedia.org/wiki/AES_(cipher) ) as of LibreOffice 3.5. Before that it was blowfish.

   Max pwd   Accent OFFICE
    Length   Time Estimate (same conditions)
        5    27m03s
        6    1d19h
        7    173d3h
        8    45y197d

Conclusions:

  • AES has no known flaws.
  • The only way is to provide the correct password. and you should always save an unencrypted copy on an external media like an USB disc that is kept safe in your house.
share|improve this answer
    
Yes they were made with LibreOffice 3.5. I am pretty sure it was even older. Thanks for the answer. +1 – Luis Alvarado Mar 25 '13 at 15:55

First, install xmlcopyeditor from the repositories. Open the content.xml file by right clicking the document from the file manager and choosing Archive Manager as the application.

Open content.xml with xml copy editor, press F11 to properly display the full document and find protected=true. Change it to false and your document will no longer me protected.

It's possible to edit the file with a text editor but it tends to choke and lock up your system for a while.

share|improve this answer
    
thanks for the tip. I need to add comments to a protected xlsx file, I couldn't find the protected=true stuff but I do find the file xl/comments1.xml. Updating the content in that file and then compress the files into xlsx, I got the comments added. – green Apr 29 at 5:51

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.