Posted 4 August 2017, 2:50 pm ESTGuys,
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