emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* Question on spreadsheet formula
@ 2009-09-26  3:08 RC
  2009-09-26  3:14 ` Benjamin Andresen
  2009-09-26  3:34 ` Andreas Burtzlaff
  0 siblings, 2 replies; 6+ messages in thread
From: RC @ 2009-09-26  3:08 UTC (permalink / raw)
  To: emacs-orgmode

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: $4=@-1$4+$2-$3

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

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

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

^ permalink raw reply	[flat|nested] 6+ messages in thread

end of thread, other threads:[~2009-09-28 13:56 UTC | newest]

Thread overview: 6+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2009-09-26  3:08 Question on spreadsheet formula RC
2009-09-26  3:14 ` Benjamin Andresen
2009-09-26  3:34 ` Andreas Burtzlaff
2009-09-27 19:35   ` RC
2009-09-28  6:51     ` Carsten Dominik
2009-09-28 13:56       ` Bernt Hansen

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).