[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Orgmode] Question on spreadsheet formula
From: |
Andreas Burtzlaff |
Subject: |
Re: [Orgmode] Question on spreadsheet formula |
Date: |
Sat, 26 Sep 2009 05:34:09 +0200 |
Hi,
you could rewrite the formula using vertical sums:
|-----+------+------+-------|
| No. | P | E | B |
|-----+------+------+-------|
| 1 | 5000 | 2000 | 3000 |
| 2 | 7000 | 1000 | 9000 |
| 3 | 5000 | 1000 | 13000 |
#+TBLFM: $4=vsum(@address@hidden)-vsum(@address@hidden)
HTH
Andreas
On Sat, 26 Sep 2009 03:08:11 +0000 (UTC)
RC <address@hidden> wrote:
> 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
>
>
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Remember: use `Reply All' to send replies to the list.
> address@hidden
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode