[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Orgmode] Spreadsheet bug?
From: |
meingbg |
Subject: |
Re: [Orgmode] Spreadsheet bug? |
Date: |
Fri, 24 Jul 2009 17:20:02 +0200 |
> I suspect @2$3 was 4 when you evaluated the formulas, hence the 7.
> If you clear column c completely, what is the output of the evaluation then?
The same. And so now I can't reproduce my original problem... that's
good, I guess.
> A good solution is to use
> $3=vsum(@-I$-1..$-1)
That works. Thanks!
Here's another thing I'm trying:
| a | b | c |
| | 7 | 210 |
|---+----+-----|
| a | 2 | 30 |
| b | 3 | 5 |
| c | -3 | 2 |
| d | 5 | 7 |
#+TBLFM: @2$2=vsum(@address@hidden)::@2$3=vsum(@3$3..$LR3)
I want row 2 to contain sums for what's below. Is there a way to make
the LR-reference work here?
//meingbg