Example
The following example changes the action key settings for the control. Users cannot clear values by pressing F2. Users can put the current date or time in a date or time cell by pressing Ctrl+D, and they can display the pop-up calendar for a date cell by pressing Ctrl+P.
C++
void CmyWnd::MyFunc()
{
// Declare variables for method return value
bool ClearX,CurrentX,PopUpX;
// Specify cell A1 as date cell
m_Spread1.SetCol(1);
m_Spread1.SetRow(1);
m_Spread1.SetCellType(CellTypeDate);
// Turn off the Clear action
ClearX = m_Spread1.SetActionKey(ActionKeyClear, False, False, 0);
// Display current date/time when the user presses Ctrl+D
CurrentX = m_Spread1.SetActionKey(ActionKeyCurrent, False, True, 68);
// Display pop-up calendar when the user presses Ctrl+P
PopUpX = m_Spread1.SetActionKey(ActionKeyPopup, False, True, 80);
}
Visual Basic
Sub Form_Load()
' Declare variables for method return value
Dim ClearX As Boolean
Dim CurrentX As Boolean, PopUpX As Boolean
' Specify cell A1 as date cell
fpSpread1.Col = 1
fpSpread1.Row = 1
fpSpread1.CellType = CellTypeDate
' Turn off the Clear action
ClearX = fpSpread1.SetActionKey(ActionKeyClear, False, False, 0)
' Display current date/time when the user presses Ctrl+D
CurrentX = fpSpread1.SetActionKey(ActionKeyCurrent, False, True, 68)
' Display pop-up calendar when the user presses Ctrl+P
PopUpX = fpSpread1.SetActionKey(ActionKeyPopup, False, True, 80)
End Sub