Example

The following example sets the control to not update formulas and inserts a row above row 3.

C++

// Set the control to not update formulas
m_Spread1.SetFormulaSync(FALSE);
// Insert a row above row 3
m_Spread1.InsertRows(3, 1);

Visual Basic

' Set the control to not update formulas
fpSpread1.FormulaSync = False
' Insert a row above row 3
fpSpread1.InsertRows 3, 1