I am testing a trial (30 day limited) version of Aspose.Excel and have been impressed with the performance and stability of the product.
My spreadsheet uses formulas extensively. They are not particularly complex formulas, but there are a lot. The problem we are experiancing is that some of the formulas are not being updated when the CalculateFormula method is called. I think it simply because the current version of the FormulaCalculation engine does not support the Formula methods we use. Would it be possible to add the following fomulas into Aspose.Excel:
INT - For rounding to nearset integer. INT(number).
POWER and ^ - for raising a number to a power. =POWER(5,2) and 5^2.
MOD - Returns remainder after number divided by divisor. MOD(num,divisor).
I think these are the only ones affecting progress at the moment.
Thank you in advance for any assistance you may give.