emacs-orgmode
[Top][All Lists]
Advanced

[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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]