You want to provide cell editing...
- But ONLY on specific cells...
- In this e.g: Only the Last Name is editable IF the Country is USA
- AND ONLY for a particular situation...
- In this e.g: Only those listed as a Friend is editable.
- AND want to force validation by keeping the user on the cell if validation fails
- EXCEPT if it's a mouse click off the cell, just revert back to the previous value.
- In this e.g: You have to provide at least 3 chars.
- AND want to prevent the tab/enter key from moving from cell to cell after edit...just make enter commit the value.