Example

The following example copies the formula in cell (2,2) to cell (5,5).

C++

CString buf;
m_Spread.SetRow(2);
m_Spread.SetCol(2);
buf = m_Spread.GetFormula( );
m_Spread.SetRow(5);
m_Spread.SetCol(5);
m_Spread.SetText(buf);

Visual Basic

Dim buf As String
fpSpread1.Row = 2
fpSpread1.Col = 2
buf = fpSpread1.Formula
fpSpread1.Row = 5
fpSpread1.Col = 5
fpSpread1.Text = buf