Link Search Menu Expand Document

SpreadColumn.Clicked Event

The event that occurs when you click a cell. If no rows are displayed, the Clicked event will not be fired.

The following child objects are attached to the Event object.

Type Name Description
Number ShiftKey 1 if the Shift key is pressed, 0 otherwise
Number CtrlKey 1 if the Ctrl key is pressed, 0 otherwise
Number AltKey 1 if the Alt key is pressed, 0 otherwise
Number xPos X coordinate of mouse pointer
Number yPos Y coordinate of mouse pointer
Number row Row position of the clicked cell
Number col Column position of clicked cell

Notes

In the handler of the event that occurred in the SpreadColumn class, do not use the Value and ColumnPosition properties of the parent object Spread class to refer to the current cursor position. (The cursor position may not be reflected.)

To refer to the clicked cell position, use the row and col passed as the argument of the event handler.