We're sorry AsposeCloud doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.cloud

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?



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!