search

lightsheet-team / lightsheet

GNU Lesser General Public License v3.0
1 stars 1 forks source link

Cell references are not updated if a formula fails to evaluate #140

Open Fluglow opened 5 months ago

Fluglow commented 5 months ago

To reproduce:

  1. Set the value of A1 to any text. Set the value of A2 to "=1+A1". Evaluating A2 will fail.
  2. Set the value of A1 to a number.
  3. A2's state remains invalid although the formula could now be evaluated.

This happens as a consequence of A2's formula failing to evaluate and therefore not tracking references in the formula. At step 3, it can be observed that A1's referencesIn does not contain A2. The references in the formula (assuming they're valid) should be tracked regardless of the formula's validity.