IFERROR issue with spreadjs

IFERROR issue with spreadjs

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

• 

  ross.hulford

  • Post Options:
  • Link
    Copy

  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

  IFERROR(SUBTOTAL(9,OFFSET(values,SEQUENCE(1,1,0),SEQUENCE(yearTo-yearFrom+1)-1,1)),0)+IFERROR(SUBTOTAL(9,OFFSET(values,SEQUENCE(1,1,0),SEQUENCE(yearTo-yearFrom+1),1)),0)

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

  recalc-breaks-value.zip

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 2 May 2023, 5:08 pm EST

  Hello,

  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.

  Regards,

  Ankit

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 14 May 2023, 2:18 pm EST

  Hi,

  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.

  Regards,

  Ankit

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 21 May 2023, 2:29 pm EST

  Hi,

  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:

  http://cdn.grapecity.com/spreadjs/16.1.1/Files/SpreadJS.Release.16.1.1.zip

  Please let us know if you still face any problems.

  Regards,

  Ankit