Hi! I’m using Cells for Cloud and trying to update some cells in a workbook, recalculate the workbook, then convert it to a pdf. I’m able to update cells and convert to pdf, but I can’t figure out how to recalculate the workbook… it still shows the old formula results.
Thanks for your posting and using Aspose.Cells.
You can calculate the formulas of your workbook using the following URI.
Suppose, your excel file name is “source.xlsx”, then the above URI will look like
Here is a PHP code to calculate the formula of the workbook. It will give you idea how to write your code in other languages like C#, Java etc.
$strURI = “http://api.aspose.com/v1.1/cells/” . $workbookName . “/CalculateFormula”;
$signedURI = Utils::Sign($strURI);
$responseStream = Utils::processCommand($signedURI, “POST”, “”, “”);
Thanks, Shakeel – this solved my problem!
Thanks for your feedback and using Aspose.Cells for Cloud.
It is good to know that your problem is resolved with the above URI suggestion. Let us know if you encounter any other issue, we will be glad to look into it and help you further.