Free Support Forum - aspose.com

Formula recalculation is not working as expected

Aspose.Cells Product Family
#1

Hi,

We have issue with the workbook not recalculating on opening.

Scenario that we have is:

1) we set the formula to the cell, using Cell.Formula =

2)save the workbook, with ReCalcOnOpen property set to true

as well as RecalculateBeforeSave property set to true

3) When we open the saved workbook in excel, formulas are not recalculated.

Our formula looks something like this:

=IF(ISERROR(VLOOKUP(A1,!$A$1:$A$50,1,FALSE)),!BG1,"something")

I have been looking at aspose forum regarding the Recalculation issue, and it is one of the issue, which pops up quite often.

Anyway, Can you direct me in right direction if i am doing something wrong here? or it is actually a bug in the aspose library?

Cheers,

Bhavin

#2

Hi,

Please try to call Workbook.CalculateFormula method before saving the excel file. Also, RecalculateBeforeSave is only an option for MS Excel settings that sets an attribute for MS Excel (and not for Aspose.Cells library), so, use Workbook.CalculateFormula instead.

Also, I have attached the latest version/fix v4.8.0.15, so you may try.

If you still find any issue, kindly post your template file here, we will check it soon.

Thank you.