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

Free Support Forum - aspose.com

Formula error with 8.0.1.0

=IF(ISNUMBER(初验前运维!IJ20),初验前运维!IJ20,0)+IF(ISNUMBER(初验前运维!IN20),初验前运维!IN20,0)+IF(ISNUMBER(初验前运维!IR20),初验前运维!IR20,0)+IF(ISNUMBER(!IV20),初验前运维!IV20,0)+IF(ISNUMBER(#REF!IZ20),#REF!IZ20,0)+IF(ISNUMBER(#REF!JD20),#REF!JD20,0)+IF(ISNUMBER(#REF!JH20),#REF!JH20,0)+IF(ISNUMBER(#REF!JL20),#REF!JL20,0)+IF(ISNUMBER(#REF!JP20),#REF!JP20,0)+IF(ISNUMBER(#REF!JT20),#REF!JT20,0)+IF(ISNUMBER(#REF!JX20),#REF!JX20,0)+IF(ISNUMBER(#REF!KB20),#REF!KB20,0)+IF(ISNUMBER(#REF!KF20),#REF!KF20,0)+IF(ISNUMBER(#REF!KJ20),#REF!KJ20,0)+IF(ISNUMBER(#REF!KN20),#REF!KN20,0)+IF(ISNUMBER(#REF!KR20),#REF!KR20,0)+IF(ISNUMBER(#REF!KV20),#REF!KV20,0)+IF(ISNUMBER(#REF!KZ20),#REF!KZ20,0)+IF(ISNUMBER(#REF!LD20),#REF!LD20,0)+IF(ISNUMBER(#REF!LH20),#REF!LH20,0)



as you see, the formula like this. it has 350 columns in workSheet ‘初验前运维’, and i sum some cells in other sheet. then there’s something wrong with the formula.

My project waiting for this.

Help.

事件ID 7001
ID: 1, Application Name: Microsoft Office Excel, Application Version: 12.0.6683.5002, Microsoft Office Version: 12.0.6612.1000. This session lasted 49 seconds with 0 seconds of active time. This session ended with a crash.

Hi,


Please try our latest version/fix: Aspose.Cells for .NET v8.0.1.4 it it makes any difference.

If you still find the issue, kindly provide your template file and paste your sample runnable code to reproduce the issue on our end, we will check it soon.

Thank you.