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

Reply via email to