I am trying to use the pivot grid as an editing grid. Not sure if this is a bad idea.

I would like the change the grid behaviour such that it will switch into edit mode on the first click, instead of 2nd click.

Also, is it necessary to call RefreshData() everytime i update the datasource when handling the EditorValueChanged event?