I've finished the spreadsheet algorithm. You can download it by clicking the "some other things" link above.
At work I use it for populating comboboxes. I add two nodes for each combobox. If I have a combobox called "brand" for example, I add a node called
brand and a node called
I also specify a relation:
brand. This relation is nice because changing a combo's population might change its value (this happens if the current value is not in the new population), so if that happens, things which are dependand on the value,
brand also need to be recalculated.
Also you can use the calculation event for values to load them during form start up.Another idea: haven't tried it self yet - you might also have a node
state:brandwhich represent the control-state of the
brandcombobox. (If it is enabled or disabled).