#975476 No error reported for self-referential formula

Package:
gnumeric
Source:
gnumeric
Description:
spreadsheet application for GNOME - main program
Submitter:
Ben Hutchings
Date:
2020-11-22 18:15:31 UTC
Severity:
normal
#975476#5
Date:
2020-11-22 18:02:21 UTC
From:
To:
In certain circumstances, that I haven't yet identified precisely, a
cell containing the SUM function applied to a range of values above
it appears to be recalculated including its own previous value!
This results in the sum increasing on every recalculation.

You should be able to see this in the attached sheet.  A99 contains
the formula =SUM(A1:A98) and is initially shown with a value of 4950.
If you fill in the value 1 in A98, the sum changes to 9901.

Ben.
#975476#10
Date:
2020-11-22 18:13:14 UTC
From:
To:
Sorry, this is actually the result of a typo I couldn't see.  The sum
is of A1:A298, so it does include itself.

But I think it's a bug that self-referential formulae are not detected
as an error.  LibreOffice Calc does report an error for this.

Ben.