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

Free Support Forum - aspose.com

Reg : Aspose Cell Formula Issue

HI Team,



We are using Aspose 8.3.2 jar in our application



We are facing issue while using the following formula in one of the scenario.



r1c1=if(isnumber(R[-13]C[-12]),R[-13]C[-12],0);display=false



Issue scenario,



When this formula is applied on the cell J50, c[-12] will be invalid, in such case, I should get result as 0, but the formula is getting evaluated as R[-13] alone, ie(the following formula is applied as =IF(ISNUMBER(J37),J37,0) ) and this is resulting in wrong values for the fields.



Please refer the attached screenshot for your reference



Please suggest us , how to overcome this issue.



Thanks in advance

Hi,


Thanks for your posting and using Aspose.Cells.

Please provide us your source excel file and sample code so that we could investigate this issue at our end and update you asap.

Please also download and try the latest version: Aspose.Cells for Java v16.11.7 and let us know if it makes any difference in resolving this issue.