Formulas updated Dynamcially

[Stephen Welborn]

Hello all,

Can formulas be set from the model or runtime?  

Any examples?

[Sangeetha Priya Murugan]

Hi Stephan,

You can update the formula in the cell by using the updateCell method, or you can bind the formula in the cellModel, as we demonstrated in our demo site.

https://ej2.syncfusion.com/aspnetcore/Spreadsheet/Formula#/bootstrap5

https://ej2.syncfusion.com/documentation/api/spreadsheet#updatecell

Code Block:

 Spreadsheet.updateCell({ formula: '=SUM(1,2)' }, "A3");

Please check the above details and get back to us if you need any further assistance on this.