Formula bar missing

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

  • 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.
  • Marked as Answer

    Replied 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
  • Replied 28 April 2019, 10:07 pm EST

    Thanks for the reply . It worked!
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels