You can use built-in formulas in cells. Use the formula method or setFormula method to add formulas. You can also specify the reference style with the referenceStyle property.
This example sets the referenceStyle property in the Workbook method.
JavaScript |
Copy Code
|
---|---|
spread.options.referenceStyle = GC.Spread.Sheets.ReferenceStyle.R1C1; //spread.options.referenceStyle = GC.Spread.Sheets.ReferenceStyle.A1; |
This example uses the formula method.
JavaScript |
Copy Code
|
---|---|
activeSheet.setValue(0,0,1); activeSheet.setValue(0,1,2); activeSheet.setValue(0,2,10); activeSheet.getCell(1,1).formula("=SUM(A1:C1)"); |