Creating Formulas and Hyperlinks in SpreadBuilder Export To Excel

Posted by: jroxas on 4 August 2017, 2:50 pm EST

  • Posted 4 August 2017, 2:50 pm EST


    I  have been browsing through the archives for notes on a certain issue of mine.

    1) How can I create formulas in cells, manipulated by the SpreadBuilder API.
        After generating the excel worksheet, and opening the generated Excel file, the formulas appear as plain TEXT.
       ( e.x. =Sum(b4:h4)) The user needs to edit the actual cell first in excel (F2) and press enter before it is recognized as a FORMULA by.
       The SpreadBuilder API has only 4 types of Cells: (SBBlank, SBLabel, SBNumber, SBBoolean)

    2)  How can i create a hyperlink to a specific worksheet in another excel file using the SpreadBuilder API.
       Cell.Hyperlink = "c:\export\Book1.xls" WORKS FINE but Cell.Hyperlink = "[c:\export\Book1.xls]Sheet2!A1" causes a File Not Found Error

  • Replied 4 August 2017, 2:50 pm EST

    1) Currently there is not a way to use spreadbuilder to export formuals other then to export as a text field.
    2) This is not possable at this time.

    I will enter these as CR requests, and edit my post with thier numbers.
Need extra support?

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

Learn More

Forum Channels