Implement cell reference handling

lightsheet-team / lightsheet

GNU Lesser General Public License v3.0

1 stars 1 forks source link

Implement cell reference handling #80

Closed Fluglow closed 5 months ago

Fluglow commented 5 months ago

Implement tracking cell references in referencesIn and referencesOut
When a cell's value is changed, its incoming references are used to update any other cells' values that have a reference to it
- Since the core does no callbacks to the UI, this update is currently not reflected in the HTML
Implement detecting circular cell references
Clear cell value on invalid state

Fluglow commented 5 months ago

I've updated the code to use the event system to fully update incoming references. This required adding position information to reference tracking, but now chained references are also updated properly in the UI.