Example

The following example places text in a cell and then concatenates additional text.

You can also see the GetCellBorder method example on page 591 and the TypeEditMultiLine property example on page 355.

C++

CString buf[100];
// Select a cell
m_Spread.SetRow(3);
m_Spread.SetCol(2);
// Enter data into the cell
m_Spread.SetText("Hello");
// Concatenate the word "Hello" to the contents of the cell
buf = m_Spread.GetText( );
buf+="Hello";
m_Spread.SetText(buf);

Visual Basic

' Select a cell
fpSpread1.Row = 3
fpSpread1.Col = 2
' Enter data into the cell
fpSpread1.Text = "Hello"
' Concatenate the word "Hello" to the contents of the cell
fpSpread1.Text = fpSpread1.Text + "Hello"