Re: Spreadsheet FR

[Xiao-Yong Jin <xj2106@columbia.edu>]

On Sun, 4 Apr 2010 09:01:30 +0200, Carsten Dominik wrote:

> On Apr 2, 2010, at 10:16 AM, Russell Adams wrote:

>> On Fri, Apr 02, 2010 at 09:49:46AM +0200, Carsten Dominik wrote:
>>> 
>>>> Would it be feasible to "narrow" a table by criteria on a specific
>>>> field in between separators? Ie: only display those cells in field A
>>>> if they are > 2, or if field B matches "Pick Me!".
>>> 
>>> This one might be possible - but dangerous for losing data.
>> 
>> Ideally we're just narrowing away lines, collapsing a table like org
>> collapses headlines.
>> 
>> Why would that be more likely to cause data loss?

> Because there would be ellipsis in unfamiliar places and the danger to
> accidentally modify invisible text would be higer.

I have an idea.  We can leave the original table intact,
while making a new dynamically generated table derived from
the original one.

#+tblname: myexptable
| x | y |            z |
|---+---+--------------|
| 1 | 1 |   0.36787944 |
| 1 | 2 |   0.13533528 |
| 2 | 3 |  0.099574137 |
| 2 | 4 |  0.036631278 |
| 3 | 5 |  0.020213841 |
| 3 | 6 | 7.4362565e-3 |
#+TBLFM: $3=$1*exp(-$2)

#+DERIVEDTBL :origin myexptable :criteria $1==2
| x | y |           z |
|---+---+-------------|
| 2 | 3 | 0.099574137 |
| 2 | 4 | 0.036631278 |

It is just a quick thought.  I am not sure how easy it is to
implement it, but at least it is unlikely to make any
confusion to users.

                                        -- jxy
-- 
J    c/*    __o/*
X    <\     * (__
Y    */\      <