Exception with CalculateFormula (ABS+VLOOKUP)

greg_france · December 13, 2007, 7:15am

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

amjad.sahi · December 13, 2007, 11:14am

Hi Gregory,

Thanks for the template file.

We will figure out the issue soon.

Thank you.

Laurence · December 14, 2007, 12:59am

Please try this attached fix.

greg_france · December 14, 2007, 2:42am

Thank you for the fix.

Gregory