Cannot open Password protected docx/xlsx Files

Bug #404647 reported by han
16
This bug affects 3 people
Affects Status Importance Assigned to Milestone
OpenOffice
Fix Released
Low
libreoffice (Ubuntu)
Undecided
Björn Michaelsen
openoffice.org (Ubuntu)
Low
Unassigned

Bug Description

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

Revision history for this message
In , Rjmoos (rjmoos) wrote :

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!

Revision history for this message
In , Rogimenez (rogimenez) wrote :

Created attachment 57442
Excel 2007 with password = 123456

Revision history for this message
In , Rogimenez (rogimenez) wrote :

Created attachment 57443
Excel 2007 without password

Revision history for this message
In , Rogimenez (rogimenez) wrote :

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.

Revision history for this message
In , Aziem (aziem) wrote :

Confirmed on OOo 3.0.0

Revision history for this message
In , Hbrinkm (hbrinkm) wrote :

set target

Revision history for this message
In , Rogimenez (rogimenez) wrote :

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?

Revision history for this message
In , Sliverbaer (sliverbaer) wrote :

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

Revision history for this message
In , Kpalagin-w (kpalagin-w) wrote :

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

Revision history for this message
In , Kpalagin-w (kpalagin-w) wrote :

Are we missing 3.1 with this one?

Revision history for this message
In , Hbrinkm (hbrinkm) wrote :

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.

Revision history for this message
In , Rogimenez (rogimenez) wrote :

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?

Revision history for this message
In , Rogimenez (rogimenez) wrote :

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.

Revision history for this message
In , Cmc-w (cmc-w) wrote :

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

Revision history for this message
In , Cmc-w (cmc-w) wrote :

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

Revision history for this message
In , Cmc-w (cmc-w) wrote :

Created attachment 63222
MS XML decryption implementation

Revision history for this message
In , Cmc-w (cmc-w) wrote :

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

Revision history for this message
han (jbronsveld) wrote :
Revision history for this message
Chris Cheney (ccheney) wrote :

If you remove the password does it work?

Changed in openoffice.org (Ubuntu):
status: New → Incomplete
Revision history for this message
han (jbronsveld) wrote :

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?

Chris Cheney (ccheney)
summary: - Documents with the extension docx
+ [upstream] Cannot open Password protected docx/xlsx Files
Changed in openoffice.org (Ubuntu):
importance: Undecided → Low
status: Incomplete → Triaged
Changed in openoffice:
status: Unknown → Confirmed
Revision history for this message
In , M-tr-s (m-tr-s) wrote :

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

Changed in openoffice:
status: Confirmed → In Progress
Revision history for this message
In , M-tr-s (m-tr-s) wrote :

committed the patch with some changes

Revision history for this message
In , M-tr-s (m-tr-s) wrote :

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

Revision history for this message
In , Kohei (kohei) wrote :

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

Revision history for this message
In , M-tr-s (m-tr-s) wrote :

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

Revision history for this message
In , Kohei (kohei) wrote :

nice. :-)

Changed in openoffice:
status: In Progress → Fix Released
Revision history for this message
In , M-tr-s (m-tr-s) wrote :

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

Revision history for this message
In , Oc-n (oc-n) wrote :

verified in internal build cws_dr72

Revision history for this message
In , Cmc-w (cmc-w) wrote :

closing, integrated DEV300_m58

Chris Cheney (ccheney)
summary: - [upstream] Cannot open Password protected docx/xlsx Files
+ [upstream] [3.2] Cannot open Password protected docx/xlsx Files
Revision history for this message
In , Jbfaure (jbfaure) wrote :

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

Changed in openoffice:
status: Fix Released → Confirmed
Revision history for this message
In , Thorstenziehm (thorstenziehm) wrote :

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

Revision history for this message
In , Kpalagin-w (kpalagin-w) wrote :

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.

Revision history for this message
In , Kpalagin-w (kpalagin-w) wrote :

Verified.

Changed in openoffice:
status: Confirmed → Fix Released
Revision history for this message
han (jbronsveld) wrote : Re: [upstream] [3.2] Cannot open Password protected docx/xlsx Files

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.

Chris Cheney (ccheney)
tags: added: jaunty
Revision history for this message
Christopher M. Peñalver (penalvch) wrote :
  • w_password.xlsx Edit (12.5 KiB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)

Attachment from upstream bug. password = 123456

Revision history for this message
Christopher M. Peñalver (penalvch) wrote :

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

Changed in libreoffice (Ubuntu):
status: New → Incomplete
Changed in openoffice.org (Ubuntu):
status: Triaged → Won't Fix
Revision history for this message
Björn Michaelsen (bjoern-michaelsen) wrote : migrating packaging from OpenOffice.org to Libreoffice

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

summary: - [upstream] [3.2] Cannot open Password protected docx/xlsx Files
+ Cannot open Password protected docx/xlsx Files
Revision history for this message
In , Shamsu1 (shamsu1) wrote :

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

Revision history for this message
In , Shamsu1 (shamsu1) wrote :

Created attachment 77412
hello

hello

Revision history for this message
In , Shamsu1 (shamsu1) wrote :

Created attachment 77413
i would like to retrive password

i would like to retriver password

Changed in openoffice:
importance: Unknown → Low
Revision history for this message
Björn Michaelsen (bjoern-michaelsen) wrote :

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

Changed in libreoffice (Ubuntu):
status: Incomplete → Fix Released
assignee: nobody → Björn Michaelsen (bjoern-michaelsen)
milestone: none → ubuntu-12.04
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.