I just touched Handsontable, I want to use Handsontable on the web side just like using Excel, let him have a lot of blank lines and columns when initializing, and can write functions when editing (I didn’t find it available in the official website example). It is a function such as =INTERCEPT(D14:J14, D13:J13), =IF(A1<A3,“111”,“222”) And it can get the value calculated by the function, not the function, and it also needs the ability to modify it again. Can it be realized? Thank you very much!
Handsontable has support for Excel like formulas. Check the docs: https://handsontable.com/docs/7.1.1/demo-formula-support.html
Also you can set
minRows to fill the grid with blank rows and columns.