On Fri, Apr 02, 2010 at 10:44:23AM -0400, Dan Davison wrote: > How about keeping a master table containing all the information, and > then generating narrowed views as separate tables? The babel way to do > this would be to have a block function "filter-table" (provided below) > and then call it where needed: > > #+TBLNAME: lime-table > | *Lime* | *Cost* | > |--------+--------| > | Y | 1 | > | Y | 2 | > | Y | 2 | > | N | 3 | > | N | 4 | > | Y | 5 | > | Total | 17 | > #+TBLFM: @8$2=vsum(@-...@-ii) > > #+call: filter-table(table=lime-table, field=0, value="Y") > > #+results: filter-table(table=lime-table, field=0, value="Y") > | *Lime* | *Cost* | > |--------+--------| > | Y | 1 | > | Y | 2 | > | Y | 2 | > | Y | 5 | > > As you can see I got rid of a few horizontal separator lines, and we > don't currently have totals. I'll suggest fixes for that below, but my > main point is that although it may make sense to extend org-mode, it's > already easy to do this in org-babel.
That's a better way to do it than properties in my opinion. Whether extension was required or not, my only point was that for small lists the only reason I still use OO or Excel was for the ability to dynamically narrow a list. Given org narrows outlines, I thought it might fit. I'll have to play with babel now! > OK, so I hard wired a 6 into the TBLFM line. Perhaps someone can tell me > how to refer to the last line of the table. Also, it might be nice if > babel could apply the table formula automaticaly after generating the > table. This is why I use @-...@-ii, the separators are your cues. There's an LR symbol, but I don't use it often. That alone is a good reason to make sure separator lines are preserved. Thanks. ------------------------------------------------------------------ Russell Adams rlad...@adamsinfoserv.com PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/ Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3 _______________________________________________ Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
