search

SheetJS / sheetjs

📗 SheetJS Spreadsheet Data Toolkit -- New home https://git.sheetjs.com/SheetJS/sheetjs
https://sheetjs.com/
Apache License 2.0
35.11k stars 8k forks source link

how can i lock (make it read only) a specific column ? #1126

Closed ebra100 closed 3 years ago

tanakorn-mint commented 6 years ago

Any update on this?

ankurgupta325 commented 5 years ago

I am stuck at this too. Is it possible to lock whole column ? and how ?

SheetJSDev commented 3 years ago

Like most styling features, we offer this in our Pro builds

For XLSX, the default is all cells locked. To unlock a column, you would have to set a column style as well as styles for each cell in the column. The last step is to protect the worksheet (which you can actually do here by setting the !protect key)

SYLK has the option to default to unprotected but the same principle applies