Free Support Forum - aspose.com

Executing formulas of a sheet

HI , I am having an excel sheet with formulas like ={othersheet}!C8, =EOMONTH(A2+1,0), =A18+1, etc In worksheet.calculateformula what is argument exactly expected to make sure these fomulas of worksheet will get executed.

Hi Soyeesh,


Thanks for your inquiry. I’m moving your request to the related Forum; Aspose.Cells. There one of my colleagues will answer you soon.

Best Regards,

Hi,


Well, you may use Worksheet.CalculateFormula() method to calculate the formulas in the worksheet. Also, you may use Workbook.CalculateFormula() method to calculate all the formulas in the whole workbook/worksheets.

See the topic for your reference:
http://www.aspose.com/docs/display/cellsnet/Calculating+Formulas

Thank you.