Issue 120153 - Save xls format WITHOUT password creates a password protected file
Summary: Save xls format WITHOUT password creates a password protected file
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: 4.0.1
Hardware: All Windows, all
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2012-07-02 22:08 UTC by russell
Modified: 2014-03-26 02:03 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description russell 2012-07-02 22:08:43 UTC
I have the following scenario:

1) Open a password protected .xlsx file produced using Excel 2007
2) Calc opens it just fine after entering the password created in Excel
3) 'Save As' in Calc and select Excel 97/2000/XP format
4) Deselect the box 'Save with password'

Saves OK but when you try to reopen it (with Calc or Excel) it asks for a password (despite deselecting the option when saving) and crucially it is NOT the password that the Excel file had originally. Few more notes:

1) If I do select the box 'Save with password' it works as expected - ie it asks for and sets a password which then works
2) This is repeatable - ie it happens every time (having discovered it I have tried the same procedure on several xlsx files and it does it every time).

Obviously now I know about it I won't do it BUT I have several files that I have spent the last few hours processing that I would really like not to have to start again. I am trying a brute force password cracker now but don't hold out much hope as I have no idea what length password may have ended up being created (the original was 7 characters).

Anyone come across this, any ideas how I can open the files?


OpenOffice 3.4 on XP Pro (SP3)
Comment 1 Du Jing 2012-07-18 05:35:46 UTC
I can't reproduce the defect in the AOO-r1359641, using MS2003 and MS2010 excel.
can you have a try on the latest build?
Comment 2 Edwin Sharp 2013-11-15 12:41:20 UTC
Filter Selection dialog window when trying to open password protected XLSX created with Excel 2010.

AOO410m1(Build:9750)  -  Rev. 1537113
Win 7
Comment 3 Clarence GUO 2014-03-25 06:06:07 UTC
Use AOO4.1 beta(revision 1573601) to open a password protected XLSX created with Excel 2010, save behavior with Edwin.
AOO4.0.1(revision 1524958) same behavior.
AOO3.4.1(revision 1372282): A password protected XLSX created with Excel 2010 cannot be opened. Open such XLSX, nothing happen.
Comment 4 zhaoshzh 2014-03-26 02:03:46 UTC
AOO4.0.1(revision 1524958) same behavior by the comment of Clarence Guo,change the version to 4.0.1