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