CTSetValue Event
Applies To
fpSpread control
Description
Occurs when a value is needed in the editor or renderer for a custom cell.
Syntax
C++
afx_msg void OnCTSetValuefpSpread(LPCTSTRName, const VARIANT FAR& Ctrl,short Sheet, long Col, long Row,const VARIANT FAR& Value, BOOL FAR*Handled);
Visual Basic
Sub fpSpread_CTSetValue(ByVal Name As String, ByVal Ctrl As Variant, ByVal Sheet As Integer,ByVal Col As Long, ByVal Row As Long, ByVal Value AsVariant, Handled As Boolean)
Parameters
The following parameters are available:
| Parameter | Description |
|---|---|
| Name | Name of the custom cell type |
| Ctrl | Name of the editor or renderer control |
| Sheet | Sheet number of the custom cell |
| Col | Column number of the custom cell |
| Row | Row number of the custom cell |
| Value | Value to put in the cell |
| Handled | True to cancel the default processing |
Remarks
This event allows you to customize how the value goes into the editor or renderer control (before edit mode starts). If Handled is False, then Spread will send a WM_SETTEXT message to the editor.
See Also
SheetSendingEvent property
SS_CT_SETVALUE_ARGS structure
CTCancelEditing events