Excel-like data manipulation

Hi,
I’m putting together an app that partly replaces a tool built in Excel.
The user enters some time series data and it uses this to make a forecast.
In the current form, users regularly use Excel’s features to adjust and shift the data. For instance using copy and paste, or double clicking on a cell to copy the value down the column, or selecting a group of cells and using control+enter to enter a single value for all the cells at once.
I was wondering if any of the editable table/grid options allow these? As far as I can tell from a moderate glance at the documentation the answer is probably no, but I’m hoping I’m wrong.
Alternatively, do you have any advice on how to add these as custom features through JavaScript or other means? Which option would be easiest to customise?
Thanks for your expertise!

Hello @benh66,

AG Grid has these features for their enterprise suite.

I would recommend that you go this route rather than trying to do it by hand. As things like range selection and copy and paste are very smooth in the enterprise and make life very simple.

Excellent! Thank you for that. That’s probably the best long term option.

1 Like