Cannot open Password protected docx/xlsx Files

[han]

Binary package hint: openoffice.org

I thought that OO 3.0 could read Word documents with the extension docx but I get the message 'file is not a WinWord6 document.' The docx file has no other 'specials' than it requires a password to open it. I use Ubuntu 9.04.

ProblemType: Bug
Architecture: i386
DistroRelease: Ubuntu 9.04
NonfreeKernelModules: nvidia
Package: openoffice.org-core 1:3.0.1-9ubuntu3
ProcEnviron:
 PATH=(custom, no user)
 LANG=nl_NL.UTF-8
 SHELL=/bin/bash
SourcePackage: openoffice.org
Uname: Linux 2.6.28-13-generic i686

[Rjmoos (rjmoos)]

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!

[Rogimenez (rogimenez)]

Created attachment 57442
Excel 2007 with password = 123456

[Rogimenez (rogimenez)]

Created attachment 57443
Excel 2007 without password

[Rogimenez (rogimenez)]

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.

[Aziem (aziem)]

Confirmed on OOo 3.0.0

[Hbrinkm (hbrinkm)]

set target

[Rogimenez (rogimenez)]

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?

[Sliverbaer (sliverbaer)]

Confirmed on Vista Home Premium (32) OpenOffice 3.0.0 and Mac OS X 10.4.11
OpenOffice 3.0.0.

[Kpalagin-w (kpalagin-w)]

Dear developers,
are we on track for 3.1 with this issue?

[Kpalagin-w (kpalagin-w)]

Are we missing 3.1 with this one?

[Hbrinkm (hbrinkm)]

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.

[Rogimenez (rogimenez)]

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?

[Rogimenez (rogimenez)]

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.

[Cmc-w (cmc-w)]

*** Issue 101863 has been marked as a duplicate of this issue. ***

[Cmc-w (cmc-w)]

assignee doesn't look right here, to default oox owner

[Cmc-w (cmc-w)]

Created attachment 63222
MS XML decryption implementation

[Cmc-w (cmc-w)]

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

[Chris Cheney (ccheney)]

If you remove the password does it work?

[han (jbronsveld)]

That is 'the solution' but that means that I can't open docx-files with a password. Received files first opening in Word to remove the password and than opening in OO is not really a solution. Is there some other way to open it in OO?

[M-tr-s (m-tr-s)]

querying passwords will be done later, I will integrate this patch to be able to
open protected files without user-def password.

[M-tr-s (m-tr-s)]

committed the patch with some changes

[M-tr-s (m-tr-s)]

now the user will also be asked for the file encryption password... :-)

[Kohei (kohei)]

@dr: is this only for xlsx, or does this also take care of encrypted docx documents?

[M-tr-s (m-tr-s)]

all filters (Word, Excel, Powerpoint), all file types (doc, template).

[Kohei (kohei)]

nice. :-)

[M-tr-s (m-tr-s)]

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").

[Oc-n (oc-n)]

verified in internal build cws_dr72

[Cmc-w (cmc-w)]

closing, integrated DEV300_m58

[Jbfaure (jbfaure)]

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

[Thorstenziehm (thorstenziehm)]

Is it fixed or isn't it? Please check. Thx

[Kpalagin-w (kpalagin-w)]

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.

[Kpalagin-w (kpalagin-w)]

Verified.

[han (jbronsveld)]

Fix Released? I just tried again to open the same docx file as mentioned above and I got still the same message. I used OO 3.1 on a laptop with Ubuntu 9.10.

[penalvch (penalvch)]

Attachment from upstream bug. password = 123456

[penalvch (penalvch)]

han, this issue is unreproducible in LibreOffice Calc. Does this work for you?

lsb_release -rd
Description: Ubuntu 11.04
Release: 11.04

apt-cache policy libreoffice-calc
libreoffice-calc:
  Installed: 1:3.3.2-1ubuntu5
  Candidate: 1:3.3.2-1ubuntu5
  Version table:
 *** 1:3.3.2-1ubuntu5 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages
        100 /var/lib/dpkg/status
     1:3.3.2-1ubuntu4 0
        500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

[Shamsu1 (shamsu1)]

hello please let me know how to encrypt password from docx file

[Shamsu1 (shamsu1)]

Created attachment 77412
hello

hello

[Shamsu1 (shamsu1)]

Created attachment 77413
i would like to retrive password

i would like to retriver password

[Björn Michaelsen (bjoern-michaelsen)]

https://issues.apache.org/ooo/attachment.cgi?id=57442 opens fine with password 123456 in LibreOffice 3.5.2.

[Elish (elish)]

*** Issue 94349 has been marked as a duplicate of this issue. ***

[Orcmid (orcmid)]

(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.

[OOoForum (oooforum)]

.

*** This issue has been marked as a duplicate of issue 118936 ***

[Damjan-5 (damjan-5)]

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.