Question on available features

Getting help Questions
1

Hello all, doing research and trying to see if Handonstable will fit my needs. Docs are a little hard for me to follow…so I’m asking here to see if this table supports the following features

  1. Column picker: I see that there is a HiddenColumns plugin but what I’m wondering if it is possible for a user to select which columns they can see? http://jsfiddle.net/mikemsq/2586p/18/

  2. Copy/Paste: Is it possible to modify the data before being placed in the clipboard? When Copy/Pasting the data is pasted as-is without any commas or spacing. Is it possible to do something like add commas between cells before being placed in the clipboard?

  3. Persistence of how the table has been set up? If customized columns are allowed (from #1) is it possible to get this data serialized somehow to store it in LocalStorage or something similar?

  4. Access deeply nested data: If I have a json object where the data resides n-levels deep, is it possible to access that nested data directly?

  5. Ability to dynamically add data: We do a request/websocket-stream to get data from our backend. Is it possible to add this data and have the table update?

Thanks all!
.nathan.

2

Hi @nathasm

for the 1) question, here’s a demo where a user can hide preferred columns and rows: http://jsfiddle.net/4vj9aoxh/

Ad 2) it should be possible but it won’t be easy as we do not have a beforeCopy callback. Although I think it can be possible by using beforeChange.

Ad 3) we offer an option called persistentState, here’s a quick tutorial on how to manage it: https://docs.handsontable.com/pro/1.4.1/Options.html#persistentState

Ad 4) I think this demo can be helpful http://jsfiddle.net/4hj1ybo8/ you can access to nested data

Ad 5) This tutorial may come in handy when it comes to loading and changing data https://docs.handsontable.com/pro/1.4.1/tutorial-load-and-save.html we leave the back-end to the developers but if you’d have any questions regarding Handsontable itself I’d be happy to help.