We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

ASPOSE version 7.0.2 does not evaluate the formula fully

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

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.