However, once processing completes, the cell will still read "1" in the UI. We've tried this syntax to apply our updated Vendor Number to Cells(0), but get the exact same results as using Vendors. I changed our structure somewhat so that the formatting now occurs in the Cell End Edit event instead and that seems to work, but it doesn't explain why the above code worked when the cell's value wasn't actually changed during Edit but it failed when the value was changed. I am glad that you have found a working solution for this scenario.
The event handler receives an argument of type Cell Validating Event Args containing data related to this event.
The following Cell Validating Event Args properties provide information specific to this event.
Since you have not added your new row yet it should validate OK." yeah i think it is because of the line you have said above how can i avoid this situation???
thanxxxxxxxxxxx If you have attached an event handler to the Cell Validating event then it will always fire when focus leaves the cell.
The Cell Validating event only fires when losing input focus (before leaving the current cell) or when Gc Multi Row validates.
The default key setting assigns end edit without leaving the current cell action to the "Enter" key.
1) Add a conditional statement in the event handler code to only execute when required.
2) Detach the event hander before the unwanted event triggers and re-attach after.
Likewise, if you edit that formatted value and remove a zero, the function will fail to update the value, but if after doing that, you click on the cell and then leave it without making any changes, it will be formatted again and the missing zero will be added back. When you set the cell will remain in edit mode allowing your end users to enter the correct value.
The validating event handler can only update the cell value if that value was not actually changed during editing. In your actual setup indeed it is more appropriate to use the Cell End Edit event because you would want to change the actual cell`s value.
When this event is canceled in data bound mode, the new value is not pushed to the underlying data source.