Example

The following example sums the range of cells A1 through A4 and places the total in cell B2.

C++

m_Spread.SetRow(2);
m_Spread.SetCol(2);
m_Spread.SetFormula("SUM(A1:A4)");

Visual Basic

fpSpread1.Row = 2
fpSpread1.Col = 2
fpSpread1.Formula = "SUM(A1:A4)"