IFERROR issue with spreadjs

Posted by: ross.hulford on 30 April 2023, 7:16 pm EST

  • Posted 30 April 2023, 7:16 pm EST

    I have a formula which should return 0 if there is an error. As you can see from the example it tries to calculate the previous column (-1) but sometime this column can be the column header which throws the error.

    The same equation handles the error in Excel the way you would expect. When consoling out the formula in spread js the formuals looks fine


    Is there a reason why spreadjs handles this differently and if so is there a workaround?


  • Posted 2 May 2023, 5:08 pm EST


    Thank you for providing us a sample and excel file.

    We were able to replicate the issue on our end. Hence, we have taken necessary steps and escalated the issue to the concerned team for further investigation. The internal tracking id for this issue is: SJS-18106. Please be rest assured that we will keep you updated as there is any progress on this issue.



  • Posted 14 May 2023, 2:18 pm EST


    This bug will be fixed in the SpreadJS V16.1.1. which is expected to be released by the next week. I will let you know when the release will be available.



  • Posted 21 May 2023, 2:29 pm EST


    The mentioned issue has been fixed in the latest version of SpreadJS V16.1.1. Kindly upgrade to the latest version of SpreadJS. You may download the latest version using the following link:


    Please let us know if you still face any problems.



Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels