Example

The following example shows how to use ClipValue:

C++

CString data;
//Copy the data
void CMergeSpanDlg::OnButton1()
{
m_spread.SetRow(1);
m_spread.SetCol(1);
m_spread.SetRow2(4);
m_spread.SetCol2(2);
data = m_spread.GetClipValue();
}
void CMergeSpanDlg::OnButton1()
{
//Clip the data back into the control
m_spread.SetRow(5);
m_spread.SetCol(1);
m_spread.SetRow2(8);
m_spread.SetCol2(2);
m_spread.SetClipValue(data);
}

Visual Basic

Dim data As String
'Copy the data
Private Sub Command1_Click
fpSpread1.Row = 1
fpSpread1.Col = 1
fpSpread1.Row2 = 4
fpSpread1.Col2 = 2
data = fpSpread1.ClipValue
End Sub
'Clip the data back into the control
Private Sub Command2_Click
fpSpread1.Row = 5
fpSpread1.Col = 1
fpSpread1.Row2 = 8
fpSpread1.Col2 = 2
fpSpread1.ClipValue = data
End Sub