You can use built-in formulas in cells. For a complete list of formulas, refer to the Formula Functions.
The following example uses the Formula property to add a built-in formula to a cell.
This example sets the Formula property.
| CS |
Copy Code |
|---|---|
| gcSpreadSheet1.Sheets[0].Cells[1, 1].Formula = "sum(A1:C1)"; | |
| VB |
Copy Code |
|---|---|
| gcSpreadSheet1.Sheets(0).Cells(1, 1).Formula = "sum(A1:C1)" | |