Unlock cells on protected sheet #804

Closed
opened 2017-09-04 18:04:35 +00:00 by wakeupgit · 2 comments
wakeupgit commented 2017-09-04 18:04:35 +00:00 (Migrated from github.com)

Is it possible in that library to unlock some cells ?
When i create a file i need to unlock some cells(the second half of the columns) to be able to edit them when the sheet will be protected by the password so nobody can edit the rest of the cells(they all locked by default)
For now i can protect the whole sheet by the password but can't edit any of the cells
Can anybody tell me how to do it ?

Is it possible in that library to unlock some cells ? When i create a file i need to unlock some cells(the second half of the columns) to be able to edit them when the sheet will be protected by the password so nobody can edit the rest of the cells(they all locked by default) For now i can protect the whole sheet by the password but can't edit any of the cells Can anybody tell me how to do it ?
daggett206 commented 2018-02-14 12:27:56 +00:00 (Migrated from github.com)

any updates?

any updates?
SheetJSDev commented 2019-01-23 21:49:07 +00:00 (Migrated from github.com)

Unfortunately Excel stores the locked / hidden attributes as part of the cell styles. Cell-level protection along with other cell styles are part of our Pro offering

Unfortunately Excel stores the locked / hidden attributes as part of the cell styles. Cell-level protection along with other cell styles are part of our [Pro offering](https://sheetjs.com/pro)
Sign in to join this conversation.
No Milestone
No Assignees
1 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#804
No description provided.