Set the edit box Value

Set the edit box Value

Posted by: jeff on 20 August 2019, 11:21 pm EST

• 

  jeff

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 August 2019, 11:21 pm EST

  Is there a way to start cell editing and set the content of the edit box with the API.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 22 August 2019, 2:56 am EST

  Hi,

  You could use the startEdit() method of the worksheet to start editing a cell using the API. Please refer to the following code snippet:

  var sheet = spread.getActiveSheet();
  sheet.setActiveCell(3, 2);
  sheet.startEdit(true, "Test" + count++);
  

  API reference:
  
  • startEdit() method: http://help.grapecity.com/spread/SpreadSheets12/webframe.html#SpreadJS~GC.Spread.Sheets.Worksheet~startEdit.html

  Regards
  
  Sharad