Is this an error when entering its own cell into the formula?

Is this an error when entering its own cell into the formula?

Posted by: nguyenvu.work on 20 April 2025, 6:01 am EST

• 

  nguyenvu.work

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 April 2025, 6:01 am EST

  -Hi. I am using formula in spreadjs with SUM function. I got a case:

  • B1: 3
  • A1: =SUM(B1,A1) => 3000
  • When I change B2 to 2, A1 will be 5000, next change B2 to 3, A1 will be 8000
  • There is an error, isn’t it?
• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 21 April 2025, 2:28 am EST - Updated 21 April 2025, 2:33 am EST

  Hi,

  We can replicate the behavior you mentioned on our end. However, the same behavior is shown by Microsoft Excel and it is not a bug. In SpreadJS, the iterative calculations are ON by default which is why it calculates to a value, everytime a value changes in the SpreadSheet cells.

  Please refer to the attached screen recording which illustrates similar behavior of SpreadJS and Microsoft Excel:

  Please feel free to reach out if you encounter any further issues or require additional guidance.

  Best Regards,

• 

  nguyenvu.work

  • Post Options:
  • Link
    Copy

  Posted 21 April 2025, 4:27 am EST

  Thank you so much! I got it.