| Summary: | Password protected XLSX | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | andy1g9p53 |
| Component: | Calc | Assignee: | Tomaz Vajngerl <quikee> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | quikee, serval2412 |
| Priority: | medium | ||
| Version: | 4.2.2.1 release | ||
| Hardware: | Other | ||
| OS: | macOS (All) | ||
| Whiteboard: | target:4.3.0 target:4.2.4 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Excel 2007 XLSX
console logs |
||
|
Description
andy1g9p53
2014-03-16 03:05:52 UTC
Could you attach the file so we can try to reproduce? (keep in mind that attachments are public so remove any confidential/private part before attaching it). Created attachment 95959 [details]
Excel 2007 XLSX
The attached file I created just now because the original file contains sensitive data. The test file opens fine with version 4.1.5 after a password challenge. With version 4.2.2 the file opens showing garbled characters and doesn't ask for a password. Test file created on Windows 7 - Office excel 2007 Password = password Created attachment 95967 [details]
console logs
On pc Debian x86-64 with master sources updated yesterday, I could reproduce the problem.
Normally xlsx is a zip file with a specific structure. I renamed the extension of your file into zip but I failed to open it. zip -T test.zip zip warning: missing end signature--probably not a zip file (did you zip warning: remember to use binary mode when you transferred it?) zip warning: (if you are trying to read a damaged archive try -F) zip error: Zip file structure invalid (test.zip) Trying to fix it (with -F or -FF option) gives an empty zip. Perhaps the encryption changes this. Julien: encrypted ooxml files are not zip files. They are OLE storage (the stuff used in MS binary format) which contains a encrypted document (which is a zip file). This looks like the file was not detected as an (encrpyted) document so it was opened as a text document. I'm taking this bug.. Tomaž Vajngerl committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=15b3e29808da85b1c304c571f52f12cc2e67884d fdo#76222 oox: add support for MSO 2007 SP2 encrypted documents The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Solved... Added change to master, pending for LO 4.2. Have fun. Tomaž Vajngerl committed a patch related to this issue. It has been pushed to "libreoffice-4-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=19f74aed27868105bc67c642dff0c3e1cb7594c2&h=libreoffice-4-2 fdo#76222 oox: add support for MSO 2007 SP2 encrypted documents It will be available in LibreOffice 4.2.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. I installed the latest daily build and all my password protected XLSX files are handled correctly. Thanks for your prompt responses and fix. |