Formula bar missing

Formula bar missing

Posted by: datta on 9 April 2019, 12:20 am EST

• 

  datta

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 9 April 2019, 12:20 am EST

  Hi Does spreadjs supports formula bar? If it supports how to enable it? I could not find any help in documentation.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 9 April 2019, 4:59 pm EST

  Hi,

  Yes, spreadJs supports formula bar. We could enable formula bar by creating an instance of the FormulaTextBox class and then calling workbook() method of the formulaTextBox to bind it to our spread instance. Please refer to the following code snippet:

  var spread = new GC.Spread.Sheets.Workbook(document.getElementById("ss"), {sheetCount: 2});
  var fbx = new GC.Spread.Sheets.FormulaTextBox.FormulaTextBox(document.getElementById('formulaBar'));
      fbx.workbook(spread);
  

  Please note that the ‘formulaBar’ div should have its ‘contenteditable’ attribute set to true.
  
  You may also refer to the following sample demonstrating the same: https://www.grapecity.com/en/demos/spread/JS/TutorialSample/#/demos/basicFormulaTextBox

  Regards

• 

  datta

  • Post Options:
  • Link
    Copy

  Posted 28 April 2019, 10:07 pm EST

  Thanks for the reply . It worked!