How delete row with protectSheet ?

I set protectSheet and allowDelete 

this.spreadsheetObj.protectSheet(0, { selectCells: true });
this.spreadsheetObj.lockCells(`B2:AL${this.accounts.length + 1}`, false);
this.spreadsheetObj.allowDelete = true;

but delete row inactive

Screenshot 2023-06-15 at 07.03.22.png

Did I do something wrong?



1 Reply 1 reply marked as answer

SP Sangeetha Priya Murugan Syncfusion Team June 15, 2023 10:55 AM UTC

Hi Roman,

Currently we don’t have complete customization support protected sheets, we have provided limited extensions for protected sheets.


A screenshot of a cell phone

Description automatically generated with low confidence


Meanwhile, we have considered this as an improvement and the fix will be available in any of our upcoming releases. We appreciate your patience until then. You can track the status of this improvement using the link below from our feedback portal. 


Feedback Portal Link:

https://www.syncfusion.com/feedback/40357/to-provide-support-for-protect-sheet-limitation-settings-as-like-excel


Could you please check the above link and get back to us if you need any further assistance on this.




Marked as answer
Loader.
Up arrow icon