[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] delete, add new row
From: |
henry atting |
Subject: |
[O] delete, add new row |
Date: |
Thu, 01 Dec 2011 18:42:17 +0100 |
User-agent: |
Gnus/5.110018 (No Gnus v0.18) Emacs/24.0.90 (gnu/linux) |
Suppose I have this table:
| month | expenses | average |
|-------+----------+---------|
| 1 | 20 | |
| 2 | 30 | 25.0 |
| 3 | 40 | 30.0 |
#+TBLFM: @3$3..@>$3=vmean(@address@hidden);%.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(@address@hidden);%.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(@address@hidden);%.1f
henry
--
http://literaturlatenight.de
- [O] delete, add new row,
henry atting <=