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

Free Support Forum - aspose.cloud

Aspose excel api

Hi,

we are trying to change the cell value and want to get updated cell value where that cell is as a reference. but when we hit the https://api.aspose.cloud/v3.0/cells/demo1.xlsx/calculateformula API. we are getting below error:
{

"RequestId": "1115eee7-ad84-436d-8688-21ef30372224",

"Error": {

    "Code": "Fail",

    "Message": "PostWorkbookCalculateFormula fails. (IndexOutOfRangeException: Index was outside the bounds of the array.(Based on cell Sheet1!A3))",

    "Description": "Operation Failed. Fail Operation.",

    "DateTime": "2023-06-15T05:10:02.3993288Z"

}

}

@priyap,
From the error message, there is a formula in the file.
Please post your demo file here. I will check it ASAP.