Bug 125206 - Edit mode password required in Excel is bypassed in Calc
Summary: Edit mode password required in Excel is bypassed in Calc
Status: RESOLVED DUPLICATE of bug 89383
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-05-10 15:51 UTC by David
Modified: 2021-09-08 10:38 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Excel file named "Password issue" (14.00 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-05-10 22:22 UTC, David
Details

Note You need to log in before you can comment on or make changes to this bug.
Description David 2019-05-10 15:51:07 UTC
Description:
I created a file in Excel that requires a password to open the file and another password to leave read-only mode and edit the file.  When I use this same file in Libre Calc, I am required to enter the password to open the file, but am allowed to enter Edit mode without entering a second password to leave read-only mode and edit the file.  Is this a bug or does Calc only require one password to open as well as edit a file?

Actual Results:
Open a file with the two passwords listed above

Expected Results:
One password opens and allows edit.  This should not happen.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 raal 2019-05-10 21:30:27 UTC
Hello,

Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
Thank you
Comment 2 David 2019-05-10 22:22:13 UTC
Created attachment 151298 [details]
Excel file named "Password issue"


Hello,
Attached is a file I just created in Excel. It requires the password 123456 to open the file, and requires the password 654321 to leave Read Only mode to edit the file.  This works correctly in Excel.  When I try to open the file in LibreOffice Calc, the password 123456 is asked for to open the file, but if I choose Edit Mode from the Edit menu, I can double click in a cell like B1 and enter information without being asked to enter the password 654321 to exit Read Only mode and enter Edit Mode to edit the document. Thanks for looking into this. Great suite of programs.
Best,
David
Comment 3 Usama 2019-05-11 12:49:26 UTC
I've tested on the daily build. The file is editable without using the Edit password. However I'm not sure if setting a password for edit mode is supported by LO.

Version: 6.3.0.0.alpha0+
Build ID: 98630a0bd49bd80652145a21e4e0d0ded792b36b
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; 
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-05-04_04:44:35
Locale: tr-TR (tr_TR.UTF-8); UI-Language: en-US
Calc: threaded
Comment 4 NISZ LibreOffice Team 2019-11-07 14:15:56 UTC

*** This bug has been marked as a duplicate of bug 89383 ***