Spread 8.0 Documentation
LeaveRow, ScriptLeaveRow Events
Support Options
ActiveX Reference > ActiveX Events > LeaveRow, ScriptLeaveRow Events

Glossary Item Box

LeaveRow, ScriptLeaveRow Events


See Also

Applies To

fpSpread control

Description

Occurs when the operation mode is set to row mode and the focus moves to a new row.

Syntax

C++

afx_msg void OnLeaveRowfpSpread(UINT, int, CWnd*, LPVOID);

Visual Basic

Sub fpSpread_LeaveRow(ByVal Row As Long, ByVal RowWasLast As Boolean, ByVal RowChanged As Boolean, ByVal AllCellsHaveData As Boolean, ByVal NewRow As Long, ByVal NewRowIsLast As Long, Cancel As Boolean)

Note: The ScriptLeaveRow event uses the same syntax except event parameters that are not passed "ByVal" are declared as variants. For more information on Script events, see Scripting Environment Usage.

Parameters

The following parameters are available:

Parameter Description
Row Row number of row losing the focus
RowWasLast Value is nonzero if row losing the focus is beyond the last row containing data
(Treat this row as the new row.)
RowChanged Value is nonzero if data within row losing the focus has changed
AllCellsHaveData Value is nonzero if all cells within row losing the focus contain data
NewRow Row number of row receiving the focus
NewRowIsLast Value is nonzero if row receiving the focus is beyond the last row containing data
Cancel Set this value to True to prevent the focus from moving to the new row

Remarks

Use the SheetSendingEvent property if you want to return the sheet for which this event occured.

Note: This event will occur if you use the fpSpread control in a scripting environment (for example, Microsoft's Visual InterDev or Internet Explorer) or a non-scripting environment. However, if you want to use the fpSpread control in a scripting environment and you want to change any parameter that is not passed "ByVal", you must set the ScriptEnhanced property to True and use the ScriptLeaveRow event. ScriptLeaveRow event parameters that are not passed "ByVal" are declared as variants.

See Also

OperationMode, ScriptEnhanced, SheetSendingEvent properties

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