Example

The following example sets the ReDraw property to False, places text in three cells, and then sets the ReDraw property back to True to refresh the control.

C++

m_Spread.SetReDraw(FALSE);
m_Spread.SetRow(0);
m_Spread.SetCol(1);
m_Spread.SetText("Home");
m_Spread.SetCol(2);
m_Spread.SetText("Auto");
m_Spread.SetCol(3);
m_Spread.SetText("Phone");
m_Spread.SetReDraw(TRUE);

Visual Basic

fpSpread1.ReDraw = False
fpSpread1.Row = 0
fpSpread1.Col = 1
fpSpread1.Text = "Home"
fpSpread1.Col = 2
fpSpread1.Text = "Auto"
fpSpread1.Col = 3
fpSpread1.Text = "Phone"
fpSpread1.ReDraw = True