Hello Marc,
What I could suggest you is to handle the
render event of the Spreadsheet, iterate over the cells, that should contain formulas and set their values as formulas:
Attached you will find a simple MVC solution, that implements the above. You will notice, that in the formulas I have used the
R1C1 notation.
Regards,
Veselin Tsvetanov
Telerik by Progress