sheet.bindColumns (what is the property name/value to define checkboxes?)

sheet.bindColumns (what is the property name/value to define checkboxes?)

Posted by: jeremyfrench on 16 November 2018, 11:27 pm EST

• 

  jeremyfrench

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 16 November 2018, 11:27 pm EST

  spreadJS shows that we can define worksheet columns by passing an object defining the columns.

  An example at
  
  https://www.grapecity.com/en/demos/spread/JS/TutorialSample/#/demos/sheetLevelBinding
  
  shows:

  // or use bindColumns to bind all custom columns
  var colInfos = [
     { name: 'position', displayName: 'Position', size: 50, visible: false },
     { name: 'name', displayName: 'Display Name', size: 70 },
     { name: 'birthday', displayName: 'Birthday', formatter: 'd/M/yy', size: 120 },
     { name: 'age', displayName: 'Age', size: 40, resizable: false },
  ];
  sheet.autoGenerateColumns = false;
  sheet.setDataSource(datasource);
  sheet.bindColumns(colInfos);
  

  Question:

  Where do we find the property name and its value for defining a checkbox?

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 20 November 2018, 12:11 am EST

  Hello,

  In order to have a checkbox in Spread.Sheets , you can use Checkbox celltype after binding data as given below:-

  http://help.grapecity.com/spread/SpreadSheets12/webframe.html#cellcheckbox.html
  
  http://help.grapecity.com/spread/SpreadSheets12/webframe.html#designertemplate.html

  Hope it helps.

  Thanks,
  
  Reeva