Executing formulas of a sheet

Aspose.Cells Product Family
1
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.
2

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,
3

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.