Spreadsheet: Stable circular definitions aren't errors
- In cell A0, type a literal number (e.g. 5).
- In cell A1, type the formula
=A0. - Edit cell A0 to use the formula
=A1.
Despite the circular reference, both cells still have the value 5:
If the circular definition isn't stable (e.g. A1 = A0 + 1 instead of A1 = A0), both cells instead get the value NaN:
In contrast, Google Sheets treats all circular definitions as errors:
This is arguably a feature, not a bug. If this is intended behavior, feel free to close this issue!
SerenityOS / serenity
The Serenity Operating System 🐞
30.6k
Contributors get 100% of received funds after fees
How does funding with Polar work?
1
Pay now to fund the work behind this issue.
2
Get updates on progress being made.
3
Maintainer is rewarded once the issue is completed.
FAQ
Backer
You're funding impactful open source efforts
Contributor
You want to contribute to this effort
Maintainer
You want to get funding like this too