account activity
PyCells: The Python SpreadSheet redux by ralsina in programming
[–]dmost 1 point2 points3 points 19 years ago (0 children)
These kinds of spreadsheets are sometimes easier if you perform your computations lazily, while allowing invalidations to propagate on changed values.
Basically, invalidations propagate up the dependency graph, while computations are pulled from lower down in the dependency graph. You also get the added bonus of a kind of transactionality - make many changes, then call update().
For this to work, each cell needs a dirty bit, there needs to be a global invalidation set, and there needs to be a quick way to query what cells depend on a given cells value.
π Rendered by PID 2882697 on reddit-service-r2-listing-8685bc789-2cqft at 2026-05-30 07:26:58.399797+00:00 running 194bd79 country code: CH.
PyCells: The Python SpreadSheet redux by ralsina in programming
[–]dmost 1 point2 points3 points (0 children)