Block certain cells in sheetJS Excel #2518

New Issue

bekverdyan · 2022-02-09T12:04:01Z

gauravr7 commented

2022-02-09 12:04:01 +00:00

(Migrated from github.com)

How can we lock certain cells in excel by using SheetJs ws['!protect']

There is a Worksheet Protection Details section which has some keys but there usage is not clear from the documentation.

https://github.com/SheetJS/sheetjs/blob/master/README.md

If somebody has used it or have any idea please help me.

How can we lock certain cells in excel by using SheetJs ws['!protect'] There is a Worksheet Protection Details section which has some keys but there usage is not clear from the documentation. https://github.com/SheetJS/sheetjs/blob/master/README.md If somebody has used it or have any idea please help me.

SheetJSDev commented

2022-02-10 04:07:42 +00:00

(Migrated from github.com)

Those settings are the worksheet-level protection settings. Cell-level protection is unfortunately tied to cell styling.

We don't know when that will be added to the Community Edition but it will be after a "1.0.0" release. In the interim, we do offer it in our Pro compendium

Those settings are the worksheet-level protection settings. Cell-level protection is unfortunately tied to cell styling. We don't know when that will be added to the Community Edition but it will be after a "1.0.0" release. In the interim, we do offer it in our [Pro compendium](https://sheetjs.com/pro)

bekverdyan referenced this issue

2022-11-13 21:40:26 +00:00

Create XLSX with controls from developer mode #2826

Sign in to join this conversation.