Re: Spreedsheet and row formulas

From: Carsten Dominik <dominik@science.uva.nl>
To: Daniel Dehennin <dad@baby-gnu.org>
Cc: emacs-orgmode@gnu.org
Subject: Re: Spreedsheet and row formulas
Date: Tue, 8 May 2007 08:58:24 +0200	[thread overview]
Message-ID: <1b130ab56e6de3299ea3959d52e4ee82@science.uva.nl> (raw)
In-Reply-To: <87lkgft7qr.fsf@thorr.asgardr.info>

This is a useful idea, but has not (yet?) been implemented.

One reason why row formulas have not been implemented is that
it is not straight forward to exclude columns from applying the
row formula.

For column formulas, it is natural to exclude the table header.

For now, just insert the formula into every field where you want to 
apply it, like this:

In the first field where you want it, type

   :=vsum(@-II..@-I)

or whatever your formula is.  Then select this text and
copy it with M-w.  Then apply and insert it many times with

TAB C-y TAB C-y ..... C-c C-c

- Carsten

On Apr 26, 2007, at 18:34, Daniel Dehennin wrote:

> Hello,
>
> This is a feature request as it doesn't seems to exists.
>
> I would like to have row formulas, like colum formulas.
>
> It's always possible to invert a table to make the formulas on colums
> instead of row, but it changes the meaning of the table.
>
> Thanks.
> -- 
> Daniel Dehennin
> Récupérer ma clef GPG:
> gpg --keyserver pgp.mit.edu --recv-keys 0x6A2540D1
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>
>

--
Carsten Dominik
Sterrenkundig Instituut "Anton Pannekoek"
Universiteit van Amsterdam
Kruislaan 403
NL-1098SJ Amsterdam
phone: +31 20 525 7477