Hi. Our workflow with book supposed, that context could have several states. Formulas should be calculated depended of context state.
Hi Alexey,
Thanks for your posting and using Aspose.Cells.
We were able to observe this issue. Once, the formula is calculated, it is not calculated again. There should be some method to invalidate the formula to force re-calculation of the formula.
We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update/advice for you, we will let you know asap.
This issue has been logged as CELLSJAVA-40769.
The issues you have found earlier (filed as CELLSJAVA-40769) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.
Hi Shakeel Faiz. Can you provide name of method for invalidate recalculation cache?
Hi,
Thanks for using Aspose.Cells.
You do not need to invalidate recalculation cache explicitly. CalculateFormula() methods for Workbook/Worksheet/Cell will force all formulas to be recalculated automatically. One exception is Workbook.CalculateFormula() method with WorkbookSettings.CreateCalcChain as true(default it is false). When WorkbookSettings.CreateCalcChain is true, Workbook.CalculateFormula() will only calculate those formulas that have not been calculated or need to be recalculated because their precedents have been changed.