Free Support Forum - aspose.com

Exception with CalculateFormula (ABS+VLOOKUP)

Hi,

I am using Aspose.Cells.dll version 4.4.0.21.

I have an exception when I want to use the function CalculateFormula (Object reference not set to an instance of an object). I send you a sample workbook wich reproduce the error. The exception occurs with a formula like "ABS(VLOOKUP(....))" (cells J15 and J21 in my sample). In Excel, these formulas are correct, but with Aspose.cells they are causing an exception when I am using the function CalculateFormula.

Please, can you fix this issue, it is very important for us.

Thank you,

Gregory

Hi Gregory,

Thanks for the template file.

We will figure out the issue soon.

Thank you.

Please try this attached fix.

Thank you for the fix.

Gregory