Spreadjs returns incorrect value

Spreadjs returns incorrect value

Posted by: dean.kinnear on 14 April 2026, 11:31 am EST

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy

  Posted 14 April 2026, 11:31 am EST - Updated 14 April 2026, 11:34 am EST

  Please find attached Excel file and screenshots: [Proof of Tax - 2025 -Mod.zip

  For cell ‘Computation reconciliation’!A140, Excel returns a string value.
  
  For cell ‘Computation reconciliation’!A140, Excel correctly returns a string value (“Business 1 - Total capital allowances”) despite the formula containing a #NAME? token as a named parameter in the LET function.

  In SpreadJS:

  When opened without fullRecalc, the cell displays #NAME?
  
  When opened with fullRecalc, the cell displays #REF!

  Thanks,
  
  Dean Kinnear

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 14 April 2026, 11:38 pm EST

  Hi Dean,

  Thank you for sharing the sample file and detailed observations.

  We were able to investigate the behavior and would like to share our findings:

  1. Regarding the #NAME? result (without full recalculation): We can reproduce the #NAME? value in SpreadJS when the file is opened without automatic recalculation. However, this behavior is consistent with Microsoft Excel as well. When Excel is set to manual calculation mode, the same cell (‘Computation reconciliation’!A140) also displays #NAME? until a recalculation is triggered.
  2. Regarding the #REF! result (with full recalculation): We were unable to reproduce the #REF! issue. In our testing, both Excel and SpreadJS correctly evaluate the formula and return the expected string value: “Business 1 - Total capital allowances”

  Please refer to the screen recording below demonstrating this behavior in both Excel and SpreadJS:

  https://gccontent.blob.core.windows.net/discourse-forum-uploads/file-3b540cec-7050-47d2-a853-e677b7ea28e8.gif(image larger than 4 MB)

  Please review and let us know if you are observing different results in a specific environment or configuration.

  Kind regards,
  
  Chirag