emacs-orgmode
[Top][All Lists]
Advanced

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

Re: [O] recalculate tables


From: Russell Adams
Subject: Re: [O] recalculate tables
Date: Thu, 25 Aug 2016 18:19:34 +0200
User-agent: Mutt/1.5.21 (2010-09-15)

> > This doesn't update either (C-u C-c *):
> >
> > |---+-------+---+---|
> > | 1 | derp  | 3 | 3 |
> > | 2 | derp2 | 5 |   |
> > |---+-------+---+---|
> > |   |       |   | 0 |
> > #+TBLFM: $4=$1*$3
> >
> > I'd been working with these recently and discovered sometimes it
> > wasn't updating... I hadn't gotten an MWE though so based on yours I
> > composed a few.
>
> It may be related to the fact that the first row group is considered as
> a table header. Column formulas do not apply on these headers. See first
> paragraph in (info "(org) Column formulas").

Excellent point! That fits the other examples as well.

I thought the header required an extra character in another column to
trigger.

I frequently use horizontal lines to trigger calculation using the
relative range for lines above the current cell, like so:

|   |       |   |       |
|---+-------+---+-------|
| 1 | derp  | 3 |     3 |
| 2 | derp2 | 5 |    10 |
|---+-------+---+-------|
|   |       |   | 13.00 |
#+TBLFM: $4=$1*$3::@4$4=vsum(@address@hidden);%0.2f

Perhaps someone knows a better way?


------------------------------------------------------------------
Russell Adams                            address@hidden

PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/

Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3



reply via email to

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