emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Orgmode] Question on spreadsheet formula


From: RC
Subject: [Orgmode] Question on spreadsheet formula
Date: Sat, 26 Sep 2009 03:08:11 +0000 (UTC)
User-agent: Loom/3.14 (http://gmane.org/)

Hi,
On applying the column formula on the table shown below:
  |-----+------+------+----------|
  | No. |    P |    E | B        |
  |-----+------+------+----------|
  |     |      |      | 0        |
  |   1 | 5000 | 2000 |          |
  |   2 | 7000 | 1000 |          |
  |   3 | 5000 | 1000 |          |
#+TBLFM: address@hidden

I get:
  |-----+------+------+-----------|
  | No. |    P |    E | B         |
  |-----+------+------+-----------|
  |     |      |      | B         |
  |   1 | 5000 | 2000 | B + 3000  |
  |   2 | 7000 | 1000 | B + 9000  |
  |   3 | 5000 | 1000 | B + 13000 |
#+TBLFM: address@hidden

When what I would like is:
  |-----+------+------+-------|
  | No. |    P |    E | B     |
  |-----+------+------+-------|
  |     |      |      | 0     |
  |   1 | 5000 | 1000 | 3000  |
  |   2 | 5000 | 1000 | 9000  |
  |   3 | 5000 | 1000 | 13000 |
#+TBLFM: address@hidden

Is there a way I can restrict application of the column formula to below the
horizontal line.
Thanks,
RC






reply via email to

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