Bug 160537 - Support sheet protection option: Edit objects
Summary: Support sheet protection option: Edit objects
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: 122921
  Show dependency tree / graph
 
Reported: 2024-04-05 12:35 UTC by Gabor Kelemen (allotropia)
Modified: 2024-04-06 19:41 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Example file from Excel 2016 with sheet protection and editable objects (72.15 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-04-05 12:35 UTC, Gabor Kelemen (allotropia) 		Details
The Edit objects option in the Excel dialog (10.08 KB, image/png)
2024-04-05 12:37 UTC, Gabor Kelemen (allotropia) 		Details
Editable objects in Excel and the same as not editable in Calc (145.35 KB, image/png)
2024-04-05 12:43 UTC, Gabor Kelemen (allotropia) 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.