I am working on an grid that has a few editable cells. Users will be able to change things like entity name, budget, etc.
I have an option to make the editable grid "spreadsheet like" with auto save.
The second option is to add Save and Cancel buttons when editing each cell, for each cell.
Which option do you think can work better? other similar web apps have inline editing with save and cancel buttons next to the cell you are editing.
The spreadsheet like experience seems faster to work with but users could make mistakes. some of the changes are important things like changing a budget...things you want to be sure about.
With Save and Cancel: