Bug 143333 - FILEOPEN XLSX Workbook structure protection password not imported
Summary: FILEOPEN XLSX Workbook structure protection password not imported
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: https://support.microsoft.com/en-us/o...
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Doc-Protection
  Show dependency treegraph
 
Reported: 2021-07-13 13:01 UTC by NISZ LibreOffice Team
Modified: 2021-11-18 02:32 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Excel (8.51 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-07-13 13:01 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc (114.14 KB, image/png)
2021-07-13 13:01 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 2021-07-13 13:01:07 UTC
Created attachment 173528 [details]
Example file from Excel

Attached file was made with Excel 2019 and it’s password protected against changing the spreadsheet structure.
Calc does not import this password protection, inserting / deleting / renaming / moving / hiding sheets is possible.

Steps to reproduce:
    1. Open attached file in Calc
    2. Check Tools – Protect Spreadsheet Structure

Actual results:
The Protect Spreadsheet Structure item is not checked in the menu, meaning the password was not imported. A new sheet can be inserted under the Sheet menu.

Expected results:
The Protect Spreadsheet Structure item should be checked in the menu. Inserting a new sheet should be impossible under the Sheet menu.

LibreOffice details:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 0fc020fb73c86a20608e8dff12af607e60327379
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL
Comment 1 NISZ LibreOffice Team 2021-07-13 13:01:38 UTC
Created attachment 173529 [details]
Screenshot of the original document side by side in Excel and Calc
Comment 2 Buovjaga 2021-07-19 11:01:57 UTC
Confirmed

NixOS
Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: b1df9c67349cf4cc5be4128d797aefb87f50e38f
CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: x11
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: threaded