SpreadJS lock cell in table

SpreadJS lock cell in table

Posted by: andrad on 8 September 2017, 12:49 am EST

• 

  andrad

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 12:49 am EST

  Hi,

  Is there any way how I can lock a table cell? I used

  [js]activeSheet.getCell(1,1).locked(true);[/js]

  but it doesn’t work. Setting the sheet as protected and the unlocking cells works but I need to be able to edit the other cells in the spread sheet.

• 

  deepaksharma14

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 12:49 am EST

  Hello,

  This is right. The cells can only be locked by setting sheet.setIsProtected(true);

  You would have to make the editabled cells unlocked in order to keep locked cells on your sheet.

  Thanks,
  
  Deepak Sharma

• 

  jeff

  • Post Options:
  • Link
    Copy

  Posted 12 October 2019, 8:04 am EST

  Correction:
  
  sheet.setIsProtected(true);
  
  is now
  
  spread.getActiveSheet().options.isProtected = true
  
  sheet.options.isProtected = true