Example
The following example sets the control to display scroll tips. In the BeforeScrollTip event, the application displays the row or column index of the current row or column.
C++
BOOL CAboutDlg::OnInitDialog()
{
CDialog::OnInitDialog();
// Move the rows or columns with the scroll box
m_Spread.SetScrollBarTrack(3);
// Show the scroll tips
m_Spread.SetShowScrollTips(3);
}
void CAboutDlg::OnBeforeScrollTipSpread1(long IsVertical, long Index, BSTR FAR* Text, VARIANT FAR* Width)
{
char buffero[40];
_ltoa(Index, buffero, 10);
// Show the row or column index number
m_Text.SetText(buffero);
}
Visual Basic
Private Sub Form_Load()
' Move the rows or columns with the scroll box
fpSpread1.ScrollBarTrack = ScrollBarTrackBoth
' Show the scroll tips
fpSpread1.ShowScrollTips = ShowScrollTipsBoth
End Sub
Private Sub fpSpread1_BeforeScrollTip(ByVal IsVertical As Long, ByVal Index As Long, Text As String, Width As Variant)
' Show the row or column index number
Debug.Print Index
End Sub