ASPOSE version 7.0.2 does not evaluate the formula fully

[jimmyaugustine]

Hello,

Here is my formula

"=IF(OFFSET(FR!$A$1,($F$2=1)*I293+($F$2=2)*J293+($F$2=3)*K293+($F$2=4)*L293-1,$F$3-1)<0,-OFFSET(FR!$A$1,($F$2=1)*I293+($F$2=2)*J293+($F$2=3)*K293+($F$2=4)*L293-1,$F$3-1),0)"

ASPOSE does not evaluate this formula completely, I get different values if I calculate using ASPOSE and excel

I have checked supported functions and I understand both IF and OFFSET are supported. However, I am not sure if ASPOSE supports OFFSET nested.

Thanks in advance to provide a guidence.

Thanks and Regards,

Jimmy

[shakeel.faiz]

Hi,

Please also post the sample file containing this formula and with the actual results.

We will compare it with Aspose.Cells results and if we found the problem, we will report it as a bug.