Re: [Orgmode] question concerning table mode / vsum / automatic adjustments of indices

2008-08-29 Thread William Henney 
Hi Rainer

On Wed, Aug 27, 2008 at 6:35 AM, Rainer Stengele
[EMAIL PROTECTED] wrote:
 Now I want to add a row after c. Being on the row below c
 when I press M-S-DOWN I get this:

   |---+|
   | items | amount |
   |---+|
   | a |0.5 |
   | b |0.0 |
   | c |0.5 |
   |   ||
   |---+|
   | sum   | 1. |
   |---+|
 #+TBLFM:@6$2=vsum(@[EMAIL PROTECTED])

 which is not what I want. I want @5 as in the case before.
 Is this a bug or a feature? How can I get what I need?


The way you have written the vsum, org has no way of knowing that you
really want to sum all the rows between the previous two horizontal
lines. Instead, you should put vsum(@[EMAIL PROTECTED]) to tell it this
explicitly. That way, you can even add/delete rows by hand and it
will still work.

Hope this helps

Will


-- 

 Dr William Henney, Centro de Radioastronomía y Astrofísica,
 Universidad Nacional Autónoma de México, Campus Morelia


___
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

[Orgmode] question concerning table mode / vsum / automatic adjustments of indices

2008-08-27 Thread Rainer Stengele 

I mostly have the same application of using org tables.
I have (many) columns with numbers and want to see the sum in the last row.

See this little example:

   |---+|
   | items | amount |
   |---+|
   | a |0.5 |
   | b |0.0 |
   | c |0.5 |
   |---+|
   | sum   | 1. |
   |---+|
#+TBLFM:@5$2=vsum(@2..4)


Having the cursor on the row with c
and pressing M-S-DOWN I get this:

   |---+|
   | items | amount |
   |---+|
   | a |0.5 |
   | b |0.0 |
   |   ||
   | c |0.5 |
   |---+|
   | sum   | 1. |
   |---+|
#+TBLFM:@6$2=vsum(@[EMAIL PROTECTED])

everything is adjusted correctly!


Now I want to add a row after c. Being on the row below c
when I press M-S-DOWN I get this:

   |---+|
   | items | amount |
   |---+|
   | a |0.5 |
   | b |0.0 |
   | c |0.5 |
   |   ||
   |---+|
   | sum   | 1. |
   |---+|
#+TBLFM:@6$2=vsum(@[EMAIL PROTECTED])

which is not what I want. I want @5 as in the case before.
Is this a bug or a feature? How can I get what I need?

Thanks!


Rainer



___
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