Download it now!
Bug 122922 - FILESAVE XLSX The spreadsheet protection doesn’t work
Summary: FILESAVE XLSX The spreadsheet protection doesn’t work
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX Password-Protected
  Show dependency treegraph
 
Reported: 2019-01-24 09:30 UTC by NISZ LibreOffice Team
Modified: 2019-02-23 14:26 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
Example ODS file from Calc with spreadsheet protection. (8.78 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-01-24 09:31 UTC, NISZ LibreOffice Team
Details
Example XLSX file from Calc with spreadsheet protection. (14.66 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-01-24 09:32 UTC, NISZ LibreOffice Team
Details
Screenshot of the ODS and XLSX document in Calc. (158.23 KB, image/png)
2019-01-24 09:35 UTC, NISZ LibreOffice Team
Details
Example password-protected ODS file from Calc (password: p). (8.85 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-01-24 09:35 UTC, NISZ LibreOffice Team
Details
Example password-protected XLSX file from Calc. (14.66 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-01-24 09:37 UTC, NISZ LibreOffice Team
Details
Screenshot of the password-protected ODS and XLSX document side by side in Calc. (183.94 KB, image/png)
2019-01-24 09:39 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2019-01-24 09:30:17 UTC
Description:
The spreadsheet protection doesn’t work when the document is saved in XLSX format.

Steps to Reproduce:
    1. Create a new spreadsheet in LibreOffice Calc.
    2. Choose Tools → Protect Spreadsheet Structure.
    3. Press OK button.
    4. Save the file as XLSX.
    5. Reload the file.

Actual Results:
The spreadsheet protection doesn’t work.

Expected Results:
The spreadsheet protection should work.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2019-01-24 09:31:49 UTC
Created attachment 148587 [details]
Example ODS file from Calc with spreadsheet protection.
Comment 2 NISZ LibreOffice Team 2019-01-24 09:32:28 UTC
Created attachment 148588 [details]
Example XLSX file from Calc with spreadsheet protection.
Comment 3 NISZ LibreOffice Team 2019-01-24 09:35:00 UTC
Created attachment 148589 [details]
Screenshot of the ODS and XLSX document in Calc.
Comment 4 NISZ LibreOffice Team 2019-01-24 09:35:46 UTC
Created attachment 148590 [details]
Example password-protected ODS file from Calc (password: p).
Comment 5 NISZ LibreOffice Team 2019-01-24 09:37:09 UTC
Created attachment 148591 [details]
Example password-protected XLSX file from Calc.
Comment 6 NISZ LibreOffice Team 2019-01-24 09:39:36 UTC
Created attachment 148592 [details]
Screenshot of the password-protected ODS and XLSX document side by side in Calc.
Comment 7 Buovjaga 2019-01-24 16:56:21 UTC
Repro. With 3.3.0, 4.3.0 on Win 10.

Arch Linux 64-bit
Version: 6.3.0.0.alpha0+
Build ID: bb30e9e591d5f9f913b3cd8fbaa3c5e412b509bd
CPU threads: 8; OS: Linux 4.20; UI render: default; VCL: gtk3; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 23 January 2019
Comment 8 m.a.riosv 2019-01-25 00:30:42 UTC Comment hidden (obsolete)
Comment 9 Buovjaga 2019-01-25 09:54:37 UTC Comment hidden (obsolete)
Comment 10 Timur 2019-01-25 10:49:15 UTC
(In reply to m.a.riosv from comment #8)
> Aoo can't save in xlsx file format even in the last versions, so issue can't
> be inherited from OOo
Sorry for not following the bug, juest the comment: we don't test with AOO (version 4 or else) but with OO 3.3 to know if "inherited".
Comment 11 m.a.riosv 2019-01-25 12:43:25 UTC
No one version of AOo or OOo can save in xlsx format.
Comment 12 Buovjaga 2019-02-15 17:25:48 UTC
Explanation for why 3.3.0 can save as OOXML: https://en.wikipedia.org/wiki/Go-oo

"Go-oo had better support for the Microsoft Office OOXML file formats than OpenOffice.org, including write support, as well as other enhancements that had not been accepted upstream."

So Inherited means Go-oo inheritance as well.