Calculate custom Excel formulas in Microsoft Excel macro-enabled spreadsheet Xlsm using Aspose.Cells REST API

Hoping someone can help with what is probably a vague query at the moment. Not deliberately so, I just don’t hold all the information. We use calls to the Aspose API v1.1 when we package a download from our website. This download includes an xlsm file that has macros and custom formulas. All that Aspose has to do is delete a sheet if it exists and then insert a sheet with about 3 cells filled in. However, when we do this the resultant download will not calculate the custom formulas. No amount of calculation will solve this - the only way to then remove the #NAME error is to go into the cell, edit it (by doing nothing) and hitting enter. Then it works.

Has anyone else experienced this? Is it a known issue? Or is it possible the calls to the API are somehow causing an issue?

TIA

@malcmail

Thank you for contacting us.

Please calculate the formula for workbook using the following API before downloading the workbook:

POST /cells/{name}/calculateformula

We hope this helps!