[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Orgmode] Re: Question on spreadsheet formula
From: |
RC |
Subject: |
[Orgmode] Re: Question on spreadsheet formula |
Date: |
Sun, 27 Sep 2009 19:35:07 +0000 (UTC) |
User-agent: |
Loom/3.14 (http://gmane.org/) |
Thank you benny and Andreas for your solutions to my question.
I did notice a couple of things I did not expect and would appreciate if someone
could tell me what I am missing.
In the following table, if I change the value in @2$4, I have to run C-c C-c
twice for the change to be propagated. Turning on formula debugging, the first
time the first formula gets executed starting only from @3$4 until the end of
the table, then the second substitution formula is executed for cell @2#4. This
happens even if cells @2$2 and @2$3 have values in them. Does the presence of
the substitution formula later in the #+TBLFM line, cause execution of the first
formula to start only from the succeeding row?
|-----+------+------+-------|
| No. | P | E | B |
|-----+------+------+-------|
| | | | 300 |
| 1 | 5000 | 2000 | 3200 |
| 2 | 7000 | 1000 | 9200 |
| 3 | 5000 | 1000 | 13200 |
#+TBLFM: address@hidden::@2$4=300
For the table above, or the following, having a ! in the first column of the
first row (which I thought was a way to label columns) causes the calculation
formulas not to be executed.
|---+-----+------+------+-------|
| ! | No. | P | E | B |
|---+-----+------+------+-------|
| | 1 | 5000 | 2000 | 3000 |
| | 2 | 7000 | 1000 | 9000 |
| | 3 | 5000 | 1000 | 13000 |
| | 4 | 5000 | 2000 | 16000 |
#+TBLFM: $5=vsum(@address@hidden)-vsum(@address@hidden)
Thanks,
RC