The table control cannot be easily tailored to operate exactly as Excel does, but it still gives you a series of events that can facilitate getting data the user enters in it.
The very first event you must check is EDIT_MODE_STATE_CHANGE which informs you of when the table is in edit mode. After that moment, the user can move from cell to cell with tab/shift-tab (horizontal move) and Enter/shift-enter (vertical move) and you receive the ACTIVE_CELL_CHANGE event in this case. When the user types in something you receive a series of VAL_CHANGED events together with a EVENT_COMMIT event when the cell changes. Despite receiving the commit event after the cell change event, the former one reports the cell being changed in eventData parameters.
With a bit of care in coding, you should be able to handle the situation without losing any data.
