How to reset handsontable

Tags: #<Tag:0x00007efc64fd49d8>
#1

Hi,
I have used persistentState to store column resize, column reorder , sorting . How to reset to default the handsontable settings without reload the page

#2

Hi @suman.dutta
You can use the persistentStateReset hook to clear local storage saved by Handsontable’s instance. Remember to use the id attribute on the Handsotnable container, as we mentioned in our guide for keeping data locally.
After clearing local storage you can “reset” plugins running updateSettings({ ... }) with the default options for those plugins. Alternatively, you can try to use getPlugin(< plugin name>).enablePlugin() to reset only those plugins that you wish.
Use the second option carefully. It might have some side effects on the table, and sometimes it is better to use the updateSettings option.

#3

it is not working. any other way to restore the table

#4

You can try to recreate IndexMapper’s and plugins definition like in the following example: https://jsfiddle.net/p2ojbght/.

#5

Hi @suman.dutta

how is the progress on this issue?

#6

It worked. Thanks

#7

Great! Thank you for the update.

#8