FR: Columnview Tables & Formulas

FR: Columnview Tables & Formulas

[Russell Adams]

I've taken to using the column view tables to aggregate table from an
outline.

I'd like to be able to use standard spreadsheet features in the same
table, specifically column formulas.

Right now it works, I can add an extra column and enter a column
formula. However when the table is refreshed in column mode, I lose
the spreadsheet data.

I see two fixes, either the TBLFM line is preserved, or could the
column formula be specified in the COLUMNS line?

Imagine a small table with two properties, VALUE and QUANTITY, where
TOTAL VALUE should be calculated via simple multiplication.

Thanks.

------------------------------------------------------------------
Russell Adams                            RLAdams@AdamsInfoServ.com

PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/

Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3

Re: FR: Columnview Tables & Formulas

[Carsten Dominik]

Hi Russel,


hmmm, an alternative would be to introduce a new property and do the  
computation in the properties.  I can see that it would be relatively  
simple to define a TBLFM line that should be added to the table  
capturing the the column view, but if you need to add extra columns to  
the table, this makes things a lot harder.

- Carsten

On Sep 6, 2008, at 11:57 PM, Russell Adams wrote:

> I've taken to using the column view tables to aggregate table from an
> outline.
>
> I'd like to be able to use standard spreadsheet features in the same
> table, specifically column formulas.
>
> Right now it works, I can add an extra column and enter a column
> formula. However when the table is refreshed in column mode, I lose
> the spreadsheet data.
>
> I see two fixes, either the TBLFM line is preserved, or could the
> column formula be specified in the COLUMNS line?
>
> Imagine a small table with two properties, VALUE and QUANTITY, where
> TOTAL VALUE should be calculated via simple multiplication.
>
> Thanks.
>
> ------------------------------------------------------------------
> Russell Adams                            RLAdams@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
> Remember: use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode

Re: FR: Columnview Tables & Formulas

[Russell Adams]

On Sun, Sep 07, 2008 at 08:43:52AM +0200, Carsten Dominik wrote:
> Hi Russel,
>
>
> hmmm, an alternative would be to introduce a new property and do the  
> computation in the properties.  I can see that it would be relatively  
> simple to define a TBLFM line that should be added to the table  
> capturing the the column view, but if you need to add extra columns to  
> the table, this makes things a lot harder.
>
> - Carsten

Do we have to ability to calculate a property from another property?
If I could set that at the parent, where the calculation is inherited
by the children, that would be perfect!

Thanks.


------------------------------------------------------------------
Russell Adams                            RLAdams@AdamsInfoServ.com

PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/

Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3

Re: FR: Columnview Tables & Formulas

[Carsten Dominik]

No, not yet - but with the recently implemented mapping functions, it  
would not be so hard.  Nice extension!  Anyone interested in trying to  
write it?

- Carsten

On Sep 7, 2008, at 8:59 AM, Russell Adams wrote:

> On Sun, Sep 07, 2008 at 08:43:52AM +0200, Carsten Dominik wrote:
>> Hi Russel,
>>
>>
>> hmmm, an alternative would be to introduce a new property and do the
>> computation in the properties.  I can see that it would be relatively
>> simple to define a TBLFM line that should be added to the table
>> capturing the the column view, but if you need to add extra columns  
>> to
>> the table, this makes things a lot harder.
>>
>> - Carsten
>
> Do we have to ability to calculate a property from another property?
> If I could set that at the parent, where the calculation is inherited
> by the children, that would be perfect!
>
> Thanks.
>
>
> ------------------------------------------------------------------
> Russell Adams                            RLAdams@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
> Remember: use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode

Re: FR: Columnview Tables & Formulas

[Eric Schulte]

Carsten Dominik <dominik@science.uva.nl> writes:

> No, not yet - but with the recently implemented mapping functions, it
> would not be so hard.  Nice extension!  Anyone interested in trying to
> write it?
>
> - Carsten

I second that it would be very nice to be able to specify calc/elisp
functions to be applied to property values before dumping the results to
tables.  I run IR experiments, and dump the results to org-mode
formatted text files with individual runs as subtrees and specific
values stored as properties of those trees, I then use column tables to
collect these values into tables which I plot with org-plot.  It would
be nice to be able to preserve #+PLOT lines for these tables as well as
apply formulas to the tables. -- Eric

Re: FR: Columnview Tables & Formulas

[Carsten Dominik]

On Sep 8, 2008, at 1:34 AM, Eric Schulte wrote:

> Carsten Dominik <dominik@science.uva.nl> writes:
>
>> No, not yet - but with the recently implemented mapping functions, it
>> would not be so hard.  Nice extension!  Anyone interested in trying  
>> to
>> write it?
>>
>> - Carsten
>
> I second that it would be very nice to be able to specify calc/elisp
> functions to be applied to property values before dumping the  
> results to
> tables.  I run IR experiments, and dump the results to org-mode
> formatted text files with individual runs as subtrees and specific
> values stored as properties of those trees, I then use column tables  
> to
> collect these values into tables which I plot with org-plot.  It would
> be nice to be able to preserve #+PLOT lines for these tables as well  
> as
> apply formulas to the tables. -- Eric

I can certainly preserve the #+PLOT and #+TBLFM lines when updating a  
column view capture.  That is easy.  Lets start with that and see if  
that turns out to be enough.  I am pushing a change which does this,  
and which will even automatically reapply the formulas when the  
capture dblock is updated.

- Carsten