Apache OpenOffice (AOO) Bugzilla – Issue 92645
Cannot open Password protected docx/xlsx Files (MS Office 2007 "Standard Encryption")
Last modified: 2024-03-12 02:48:27 UTC
If I open .docx-Files that are protected with Password, oo mentions, that this file is not a docx-file!!!! If I save the Docoment without Passwordprotection, the File can bie opend. Please change code, that oo informs the user, if the file can not being opend caused by Passwordprotection!
Created attachment 57442 [details] Excel 2007 with password = 123456
Created attachment 57443 [details] Excel 2007 without password
I can confirm that OpenOffice.org 3.0.0 cannot open any password protected Microsoft Office 2007 files. I'm ussing OOo 3.0.0 Build 9358 (final spanish) In the attachment you will find two Excel 2007 files, one without password and the other one password protected, the second one present and error when opening. I think is imperative to correct this because is a very common practice to create passwords to protect files.
Confirmed on OOo 3.0.0
set target
To be clear, it is imperative to be able to OPEN password protected files in office 2003/2007 formats, and not only to display a warning alerting of the passowrd presence. Is it the target?
Confirmed on Vista Home Premium (32) OpenOffice 3.0.0 and Mac OS X 10.4.11 OpenOffice 3.0.0.
Dear developers, are we on track for 3.1 with this issue?
Are we missing 3.1 with this one?
This is a missing feature. Password protected .*x files are stored as OLE2 storage, not as ZIP storage. Solving this needs completely different access methods. I suggest the effort to be in the weeks.
What about previous formats (previous to Office 2007), *.doc and *.xls, those also can't be open in OOorg 3.0, and I think it’s an important feature. Are those formats included in the correction of 3.2?
I can confirm that in version 3.1.0 OOorg can open password protected files in xls format, not xlsx (2007 format), so and improvement was done to this item.
*** Issue 101863 has been marked as a duplicate of this issue. ***
assignee doesn't look right here, to default oox owner
Created attachment 63222 [details] MS XML decryption implementation
cmc->dr/hbrinkm/kohei: Attached is an implementation of the MS XML decryption mechanism. I've only done the decryption work and hard-coded the password to the classic Excel default "VelvetSweatshop", which means that applied and out-of-the-box it's able to open "protected" documents like http://download.microsoft.com/download/7/E/7/7E7662CF-CBEA-470B-A97E-CE7CE0D98DC2/ISA_PNPID_List.xlsx but someone needs to extend it to query/accept used-entered passwords, and/or break it up, move it around, check for failures at the various intermediate steps return values openssl is in the "vanilla" build-tree, so I've implemented it using that, so it should be ok from that sense. FWIW, one quirk of their "bundle it into a OLE2 package and encrypt the whole zip as a stream in that package" mechanism is that it won't be possible to detect the file type until *after* its bee decrypted
querying passwords will be done later, I will integrate this patch to be able to open protected files without user-def password.
committed the patch with some changes
now the user will also be asked for the file encryption password... :-)
@dr: is this only for xlsx, or does this also take care of encrypted docx documents?
all filters (Word, Excel, Powerpoint), all file types (doc, template).
nice. :-)
see http://sc.openoffice.org/testdocs/filetype/index.html for a collection of test files. WordML, SpreadsheetML, PresentationML files labeled with "AES128 encrypted, "Password"" must be able to open using the password "Password" (capital P). For spreadsheet: the test files labeled with "Encrypted, built-in password" are encrypted too, but must open without password request (they are encrypted with the well-known default password "VelvetSweatshop").
verified in internal build cws_dr72
closing, integrated DEV300_m58
Hi, Perhaps I have missed something, but I cannot open the attached bugdoc with DEV300_m60. It asks me for the password and after asks for a filter and, when I choose "Microsoft Excel 2007 XML" I get error message : General Error. General input/output error". Same problem for test files as : http://sc.openoffice.org/testdocs/filetype/ms_excel_xml_encrypted_aes128.xlsx Regards JBF
Is it fixed or isn't it? Please check. Thx
m3 opens w_password.xlsx just fine, after user supplies the password. Earlier builds apparently had broken import filter for Excel2007 files. Resolving as fixed.
Verified.
hello please let me know how to encrypt password from docx file
Created attachment 77412 [details] hello hello
Created attachment 77413 [details] i would like to retrive password i would like to retriver password
*** Issue 94349 has been marked as a duplicate of this issue. ***
(In reply to shamshuddin from comment #32) > Created attachment 77413 [details] > i would like to retrive password > > i would like to retriver password Sorry. Those are strongly-encrypted files. If you don't know or have forgotten the password, you will have to look for password-cracking software that *might* be able to discover a password that works. This is not something that Apache OpenOffice provides, not even for files that are saved with Password by Apache OpenOffice. We do not have any recommendations for products that might work. Also, the difficulty of recovering passwords is a feature. Furthermore, encrypted .docx and .xslx files are not OOXML files. They are something else, but Microsoft Office recognizes them as files that decrypt to unencrypted .docx and .xslx.
. *** This issue has been marked as a duplicate of issue 118936 ***
This is NOT a duplicate. This bug was about MS Office 2007's "Standard Encryption". Bug 118936 is about MS Office 2010's "Agile Encryption". Resolving FIXED.