Using Built-In Formulas

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.

Using Code

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)"

 

 


Copyright © GrapeCity, inc. All rights reserved.