Read only mode in SpreadJS?

Read only mode in SpreadJS?

Posted by: guy.g on 30 December 2018, 3:40 am EST

• 

  guy.g

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 December 2018, 3:40 am EST

  Is there a read only mode setting in SpreadJS like in Wijmo FlexSheet?
  
  (flexSheet.isReadOnly = true)

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 30 December 2018, 5:38 pm EST

  Hello,

  There isn’t any direct property by the name of “isReadOnly” in Spread.Sheets.

  However, we can make Spread.Sheets readonly by setting e.PreventDfault() in EditStarting event as given below:-

  var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"), { sheetCount: 2 });
              var sheet = spread.getActiveSheet();
              sheet.bind(GC.Spread.Sheets.Events.EditStarting, function (sender, args, e) {
                                e.preventDefault();
   });
  

  Or, you can set sheet.option.isProtected= true and cell.locked(true) to make Spread.Sheets readonly as given in documentation link below:-

  https://help.grapecity.com/spread/SpreadSheets12/webframe.html#celllock.html
  
  https://help.grapecity.com/spread/SpreadSheets12/webframe.html#sccelllock.html

  Hope it helps.

  Thanks,
  
  Reeva

• 

  guy.g

  • Post Options:
  • Link
    Copy

  Posted 30 December 2018, 10:46 pm EST

  Thank you very much for the answer.
  
  isProtected is just what I was looking for.

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 1 January 2019, 2:39 pm EST

  Hello,

  We are glad to know that your issue has been resolved.

  Thanks,
  
  Reeva