rsonggg's avatar
rsonggg
Copper Contributor
Sep 30, 2022
Status:
New

Equivalent of UserInterfaceOnly worksheet protection option for ungrouping/grouping columns and rows

It is a common use case for our Excel add-in to protect worksheets but permit users to group/ungroup rows or columns.

 

In the C# API, a UserInterfaceOnly property could be passed as an option to allow the user to do this without impacting anything else. This property is not available in the https://learn.microsoft.com/en-us/javascript/api/excel/excel.worksheetprotectionoptions?view=excel-js-preview, only allowFormatRows and allowFormatColumns are available, but these also allow users to change height/width of cells and hide/show columns or rows.

 

Can the JS API be updated to include a similar property?

No CommentsBe the first to comment