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