If I save a Calc spreadsheet in Microsoft Excel format, and give it a password, it saves correctly.
When I try to open it (with LO), it asks for a password but does not always recognise it. For example,
The saved p/w "Thedeerhunter-22" produces a "wrong password" error message.
The saved password "horses" allows a file to be re-opened.
The same problem occurs when opening the LO file in Microsoft Office.
Is this a problem of password length or invalid - character?
Steps to Reproduce:
1.Create a new Calc spreadsheet,
2.Save it with a password, then quit LO.
3.Right-click on the file to open in LO and enter the password.
File opens if saved using short password above.
File does not open if saved with long password above, with the error message "The password is incorrect. The file cannot be opened."
The "save as" dialogue should prevent the use of invalid password formats.
The "open" dialogue should respect the saved password.
User Profile Reset: No
Build ID: 4d224e95b98b138af42a64d84056446d09082932
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: GL; VCL: osx;
Locale: en-GB (en_GB.UTF-8); UI-Language: en-US
I can't reproduce this bug. can you write down "the long password"?
Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
CPU threads: 8; OS: Mac OS X 10.15.3; UI render: GL; VCL: osx;
Locale: en-ID (en_ID.UTF-8); UI-Language: en-US
(In reply to Ahmad Haris from comment #1)
> I can't reproduce this bug. can you write down "the long password"?
> Version: 18.104.22.168
> Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
> CPU threads: 8; OS: Mac OS X 10.15.3; UI render: GL; VCL: osx;
> Locale: en-ID (en_ID.UTF-8); UI-Language: en-US
> Calc: threaded
As I said in my original bug submission (I quote)
"The saved p/w "Thedeerhunter-22" produces a "wrong password" error message.
The saved password "horses" allows a file to be re-opened.”
The long p/w is Thedeerhunter-22
1. Create new Calc spreadsheet
2. Save with password "Thedeerhunter-22" in .xlsx file format
3. quit LO
4. open file with LO
LO asks for password, enter "Thedeerhunter-22", file opens fine.
@Keith: Can you please test 22.214.171.124 and see if the problem persist for you. If yes, please reset the bug to UNCONFIRMED if no please close as WORKSFORME.
I just downloaded and installed 126.96.36.199 and tested with password Thedeerhunter-22. The problem still exists, I still get the message "The password is incorrect. The file cannot be opened.”
One question: I am saving in Excel 97-2003 (*.xls) format. Did you test that?
MSO Excel only supports 15 character passwords up to version 2003: https://docs.microsoft.com/en-us/openspecs/office_file_formats/ms-xls/a3ad4e36-ab66-426c-ba91-b84433312068
If I paste your password into the password field when saving in LO I get a pop-up saying it was truncated for being too long. If I try to type it, I'm also restricted in typing longer than 15 characters
Your suggested password was 16 characters, so just remove the last character and the file opens
So this is not a bug
Build ID: 4db9852e73d9e9d662fc8a2783bace79addf1805
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Thanks for the explanation.
I just find it odd that LO allows me to enter a password that is too long, while truncating it without telling me.
(In reply to keith from comment #6)
> I just find it odd that LO allows me to enter a password that is too long,
> while truncating it without telling me.
Fixed in LO 7.0 thanks to bug 43452.
*** This bug has been marked as a duplicate of bug 65492 ***