2 ms·
Right, but that only works if when looking at a formula you can figure out which other cell it refers to. I guess I asked what I asked because I hoped having Py
by omaranto 16y ago
Right, but that only works if when looking at a formula you can figure out which other cell it refers to. I guess I asked what I asked because I hoped having Python would let you use computed references --something like cell(x,y) where x and y are expressions computing the row and column, or even eval(str) where the str is a formula that refers to some cells.
- gruseom 16y agoSomehow I didn't see your reply till now. It turns out this problem of computed cell references is a nontrivial one. (Excel can do it, but slowly and I suspect not with full generality.) The trouble is that you need the reference graph to compute the spreadsheet, but now computing the spreadsheet can modify the reference graph, so you have to maintain the graph dynamically as you calculate. I'd be interested in discussing this further if you are, but email would be better than here. (My address is in my profile.)