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

Free Support Forum - aspose.com

Incorrect value from reading cell with formula?

Hello support,
we are evaluating the excel library and found some weird case,

We tried to read some result from a cell with formule like this,

=IF($P5>0,LOOKUP($P5,Freq!$B1:$AE2),””) => FAILED

But the value seems incorrect , while we tried different way to specify the range as following,

=IF($P5>0,LOOKUP($P5,Freq!$B1:$AE1,Freq!$B2:$AE2),””) =>This one is OK

Could you help to verify ?

Hi Frankie.

Thank you for considering Aspose APIs.

Please provide your sample spreadsheet having the base data and the said formulas to verify your presented scenario. Moreover, please mention how you are using Aspose.Cells API to insert/evaluate the formula. It would be appropriate if you could provide us an executable sample application along with the template spreadsheet for detailed analysis.

Before you move forward to provide the above requested, please give a try to the latest version of Aspose.Cells for .NET on your end to see if it makes any difference.