Description: FILESAVE to .xlsm files with password protection not working (Calc) SAVE WITH PASSWORD (XLSM files) not working. After closing the file, I am able to open it without using any passwords. SAVE AS WITH PASSWORD (XLSM files) not working. After closing the file, I am able to open it without using any passwords. SAVE OR SAVE AS WITH READ-ONLY PASSWORD AND EDIT PASSWORD OPTIONS SELECTED (XLSM files) not working. After closing the file, I am able to open it, edit, and save without using any passwords. Steps to Reproduce: 1. Create a spreadsheet 2. Save to .xlsm format (same thing happens if you do a Save As of a spreadsheet originally saved in a different format). 3. Select the option to password protect (same thing happens if you also add the option to make this read-only and add an additional password for editing). 4. Enter and confirm your password and save the file. 5. Close the file. 6. Open the file, and you will see no password is requested. File opens as if there were no password protection. 7. Even if you originally opted to save as read-only and added an additional password for editing permission, you are still able to edit and save changes on this file. You are never asked for a password for this either. Actual Results: I can save an XLSM spreadsheet as password protected, and even as read only with an addition password to allow editing, but when I go to open and edit these supposedly password-protected files, it's as though I had never set any password protection at all. Expected Results: In the case of a simple Save/Save As with password protection, I would expect to be asked to enter a password before being allowed to open the file. In the case of additionally selecting read-only status and adding a separate password to enable editing, I would expect to be asked to enter the read-only password upon attempting to open the file, and to be asked to enter the editing permission password upon attempting to edit the file. Reproducible: Always User Profile Reset: Yes Additional Info: I performed the steps to rest my UserProfile but the problem persisted. OpenGL is NOT enabled.
Created attachment 143738 [details] A supposedly password protected read only spreadsheet A simple spreadsheet saved as a read only, password-protected XLSM file with an additional editing password. Read-only password: open Editing password: edit
Verified with 5.4.7.2 thru 6.2Master (Ubuntu 18.04)
*** Bug 126534 has been marked as a duplicate of this bug. ***
In LO 7.1 and 7.3+ behavior is different with file open password, there's error saving: Write Error. Read-only password is working now, bug 118938.
Dear kam3don, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
(In reply to QA Administrators from comment #5) > Dear kam3don, > > To make sure we're focusing on the bugs that affect our users today, > LibreOffice QA is asking bug reporters and confirmers to retest open, > confirmed bugs which have not been touched for over a year. > Yes, the bug is still here, Feb 2nd, 2024, LO version 7.6.4.1, Win 11, As commented here by @Timur 2021-09-08 11:06:49 UTC Trying to save a xlsm file with password protection - gives an error (and does NOT save the file).
(sorry, i accidentally changed the version from 5.4.7.2 to 7.6.4.1. Resetting it back to when it was discovered)