delete, add new row

[henry atting <nsmp_02@online.de>]

Suppose I have this table:

| month | expenses | average |
|-------+----------+---------|
|     1 |       20 |         |
|     2 |       30 |    25.0 |
|     3 |       40 |    30.0 |
#+TBLFM: @3$3..@>$3=vmean(@2$2..@0$2);%.1f

Then I want to delete the second row and add a new one at the bottom.
If I do so I get `#ERROR' on every recalculation.

| month | expenses | average |
|-------+----------+---------|
|     2 |       30 |  #ERROR |
|     3 |       40 |  #ERROR |
|     4 | 50       |  #ERROR |
#+TBLFM: @2$3..@>$3=vmean(@INVALID$2..@0$2);%.1f

If I push the second row to the bottom the
result is as if the last row is still the second one.

| month | expenses | average |
|-------+----------+---------|
|     2 |       30 |    30.0 |
|     3 |       40 |    30.0 |
|     1 |       20 |    20.0 |
#+TBLFM: @2$3..@>$3=vmean(@4$2..@0$2);%.1f


henry

-- 
http://literaturlatenight.de