[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Orgmode] Spreadsheet FR
From: |
Russell Adams |
Subject: |
Re: [Orgmode] Spreadsheet FR |
Date: |
Fri, 2 Apr 2010 09:55:16 -0500 |
User-agent: |
Mutt/1.5.18 (2008-05-17) |
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(@address@hidden)
>
> #+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 @address@hidden, 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 address@hidden
PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/
Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3
- [Orgmode] Spreadsheet FR, Russell Adams, 2010/04/01
- Re: [Orgmode] Spreadsheet FR, Carsten Dominik, 2010/04/02
- Re: [Orgmode] Spreadsheet FR, Russell Adams, 2010/04/02
- Re: [Orgmode] Spreadsheet FR, Darlan Cavalcante Moreira, 2010/04/02
- Re: [Orgmode] Spreadsheet FR, Carsten Dominik, 2010/04/04
- Re: [Orgmode] Spreadsheet FR, Xiao-Yong Jin, 2010/04/04
- Re: [Orgmode] Spreadsheet FR, Russell Adams, 2010/04/04
- Re: [Orgmode] Spreadsheet FR, Xiao-Yong Jin, 2010/04/04
Re: [Orgmode] Spreadsheet FR, Dan Davison, 2010/04/02
[Orgmode] Re: Spreadsheet FR, Matt Lundin, 2010/04/02
[Orgmode] Re: Spreadsheet FR, Matt Lundin, 2010/04/02