Example

The following example sets the following general settings:

• The control does not support the Clipboard keys
• Pressing the arrow keys causes the cell to exit edit mode and move the active cell in the appropriate direction
• The control does not give warning beeps
• The sheet does not display a border along the bottom and right sides
• The sheet continues to scroll until the last row is at the top or the last column is at the left side of the control, displaying the control's gray area
• The user can select only columns and rows

C++

m_Spread.SetAutoClipboard(FALSE);
m_Spread.ArrowsExitEditMode(TRUE);
m_Spread.SetNoBeep(TRUE);
m_Spread.SetNoBorder(TRUE);
m_Spread.SetScrollBarMaxAlign(FALSE);
m_Spread.SetSelectBlockOptions(3);

Visual Basic

fpSpread1.AutoClipboard = False
fpSpread1.ArrowsExitEditMode = True
fpSpread1.NoBeep = True
fpSpread1.NoBorder = True
fpSpread1.ScrollBarMaxAlign = False
fpSpread1.SelectBlockOptions = 3