I have an Interactive Grid.

Howevere here i had to hide Apex Row Selector and Row Actions features.

I have a page process that inserts and deletes rows on click of custom save button.

Usually if a person doesnt want to save change they would simply refresh the page .
But i have requirement to add a Cancel button which would reset the grid data.

If i add a simple button that submits the page, it works only during update. If i insert new record it will throw validation errors since i have not null column validations.

Any suggestions as to how this can be configured?

Version- 22.1