Spreedsheet and row formulas

Spreedsheet and row formulas

[Daniel Dehennin]

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

Re: Spreedsheet and row formulas

[Carsten Dominik]

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

Re: Spreedsheet and row formulas

[Daniel Dehennin]

Le 4997 Septembre 1993, Carsten Dominik a tapoté:
> 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.

Maybe defining a format for the table, telling that column 1 and row
1 are header ?

Regards.
-- 
Daniel Dehennin
Récupérer ma clef GPG:
gpg --keyserver pgp.mit.edu --recv-keys 0x6A2540D1