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

Glossary Item Box

TopLeftChange Event


See Also

Applies To

fpSpread control

Description

Occurs when the displayed left column or top row changes.

Syntax

C++

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

Visual Basic

Sub fpSpread_TopLeftChange(ByVal OldLeft As Long, ByVal OldTop As Long, ByVal NewLeft As Long, ByVal NewTop As Long)

Parameters

The following parameters are available:

Parameter Description
OldLeft Column number of previous left column
OldTop Row number of previous top row
NewLeft Column number of new left column
(If the value of OldLeft equals the value of NewLeft, the sheet did not scroll horizontally.)
NewTop Row number of new top row
(If the value of OldTop equals the value of NewTop, the sheet did not scroll vertically.)

Remarks

The TopLeftChange event occurs when you change the displayed leftmost column or topmost row using the LeftCol or TopRow properties or when the user scrolls through the sheet using the keyboard or the scroll bars.

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

See Also

LeftCol, SheetSendingEvent, TopRow properties

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