void=setCellFormula(col:integer, row:integer, formuleStr: string)
The function saves the calculation formula in xls document.

Parameters
Col and row are coordinates of the cell, whose contents we want to read. Col is a column coordinate and row is a row coordinate. The values range from firstCol and lastCol, or firstRow and lastRow. FormuleStr is of the string type and we insert here our own calculation formula that we want to be saved in a cell of the xls document.

Example - Director

global xls
xls.setActiveSheet(1) 
xls.setCellFormula(2, 10,, "SUM(C1:C4)")

Example - Authorware

CallObject(xls; "setActiveSheet" ; 1) 
CallObject(xls; "setCellFormula"; 2; 10; , "SUM(C1:C4)")