Race condition when displaying formulas result

[hexaltation]

Describe the current behavior

Since 1.7.10 (or short living 1.7.9) a same deterministic formula can have a different return at each page load.

See in the example below how the same formula in two adjacent column give a different result.
False results are partials of the expected result.

Steps to reproduce

1. load this document in grist

Base Notification-2.grist.zip

2. Go to FichePIAL page
3. Reload page until Column A and Column ListDroitCourantPIAL that contains the exact same formula gets different results.

Describe the expected behavior

Same deterministic formula must have the same result.
Result must not be displayed before any calculation (underlying breadth first or depth first searches) are completed.

Where have you encountered this bug?

• On docs.getgrist.com
• On a self-hosted instance

Instance information (when self-hosting only)

• Grist instance: DINUM

  • Version: 1.7.10
  • URL (if it's OK for you to share it): grist.numerique.gouv.fr
  • Installation mode: kubernetes
  • Architecture: multi-workers

• Browser name, version and platforms on which you could reproduce the bug: Firefox ESR 140

• Link to browser console log if relevant:

• Link to server log if relevant:

[hexaltation]

Maybe related to #2108