Spreadsheet functionality with table data

[entwine.llc.wi]

Is it possible to load data from a database table and then allow users to add/manipulate a custom formula column? If it is possible, can the new formula column be saved as part of the Grid State?

[paramvir]

There is no online example doing the exact thing, but conceptually yes, it's feasible.

Spreadsheet functions are stored in pq_fn property of rowData as shown in this example: https://paramquery.com/pro/demos/excel_formula

you can add extra column in the table to save Spreadsheet formula corresponding to each column expecting a formula.

When data is posted to remote server, extract formula from pq_fn and save in respective columns.

When data is fetched from the server, add pq_fn property ( containing the formulas ) back to the rowData in json data.