CellChanged Event 164

Applies To: Grid

Description

If enabled, this event is reported after the user has changed the contents of a cell in a Grid object and then moved to another cell or to another control outside the Grid. The purpose of this event is to give the application the opportunity to perform calculations, and perhaps to update other cells in the Grid as a result of the change.

Note that this event is reported after the change has taken place, and after the Values property has been updated. Furthermore, neither setting the event action code to ¯1 nor returning 0 from a callback function has any effect. If you wish to validate the new data you should use the CellChange (150) event instead.

The event message reported as the result of ⎕DQ, or supplied as the right argument to your callback function, is an 5-element vector as follows:

[1]	Object	ref or character vector
[2]	Event	'CellChanged' or 164
[3]	Cell row	integer
[4]	Cell column	integer
[5]	New data	number or character array

The 5th element of the event message contains the data value that has been used to update the Values property. This will be numeric if the FieldType of the associated Edit object is Numeric, LongNumeric, Date, LongDate or Time. Otherwise, it will be a character array.

If you want to update an individual cell under program control, you may call CellChange, but not CellChanged, as a method.