Spread 8.0 Documentation
CTSetValue Event
Support Options
ActiveX Reference > ActiveX Events > CTSetValue Event

Glossary Item Box

CTSetValue Event


See Also

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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.