Bug 160537

Summary:	Support sheet protection option: Edit objects
Product:	LibreOffice	Reporter:	Gabor Kelemen (allotropia) <kelemeng>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	raal
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	122921
Attachments:	Example file from Excel 2016 with sheet protection and editable objects The Edit objects option in the Excel dialog Editable objects in Excel and the same as not editable in Calc

Description Gabor Kelemen (allotropia) 2024-04-05 12:35:52 UTC

Created attachment 193512 [details]
Example file from Excel 2016 with sheet protection and editable objects

Excel offers the sheet protection feature "Edit Objects" meaning even on protected sheets the properties of objects are editable. Such objects seem to be images, shapes, SmartArts, OLEs, Charts, Equations, Form Controls, SparkLines, Signature Lines.

1. Open attached document in Excel an Calc
-> In Excel, on the first sheet the objects properties are editable ("Edit Objects" is enabled in the Protect Sheet dialog), but on the second sheet it is not.
-> In Calc, the Protect Sheet dialog does not have this option, so the objects are editable on both sheets.

Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: c9d4f99b2bb54ac7735b3e0d0cadbafbd0279518
CPU threads: 15; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: default

Comment 1 Gabor Kelemen (allotropia) 2024-04-05 12:37:05 UTC

Created attachment 193513 [details]
The Edit objects option in the Excel dialog

Comment 2 Gabor Kelemen (allotropia) 2024-04-05 12:43:46 UTC

Created attachment 193514 [details]
Editable objects in Excel and the same as not editable in Calc

Comment 3 raal 2024-04-06 19:41:05 UTC

Setting to NEW.