I wonder if there is something written about how MS Excel handles filtering internally; maybe it is something like a directed graph?
Reactive programming is a directed graph underneath. Excel itself is a poster child of reactive programming.
Speaking of reactive programming, what is the name of the "fuller" form that works on a proper graph, with loops, and can handle fixpoints? Constraint solving?
Great! This means that I was right when I mentioned to a co-worker that Excel (and its filtering) would have an intersting implementation underneath (from my category theoretic perspective). In fact, I am quite interested to understand the formalisms behind it.
Comments
Reactive programming is a directed graph underneath. Excel itself is a poster child of reactive programming.
Speaking of reactive programming, what is the name of the "fuller" form that works on a proper graph, with loops, and can handle fixpoints? Constraint solving?
Great! This means that I was right when I mentioned to a co-worker that Excel (and its filtering) would have an intersting implementation underneath (from my category theoretic perspective). In fact, I am quite interested to understand the formalisms behind it.
Do you know of any links or resources about this?
And I'm no more able to debug an Excel spreadsheet I didn't write myself than I am to debug a reactive program I didn't write myself.