Handsontable binds to your data source (array or object) by reference. Therefore, all the data entered in the grid will alter the original data source.
In complex applications, you may have a purpose to change data source programatically (outside of Handsontable). A value change that was done programatically will not be presented on the screen unless you refresh the grid on screen using the render method.
In case you want to keep separate working copy of data for Handsontable, it is suggested to clone the data source before you load it to Handsontable.
This can easily be done with $.extend method.
In a similar way, you may find it useful to clone data before saving it.
That would be useful to make programmatic changes that would be saved to server but kept not invisible to the user.
For more examples, head back to the main page.
Handsontable © 2012 Marcin Warpechowski and contributors.
Code and documentation
licensed under the The MIT License.