Re: recalculate tables

[Russell Adams <RLAdams@AdamsInfoServ.Com>]

> > 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(@-I..@-II);%0.2f

Perhaps someone knows a better way?


------------------------------------------------------------------
Russell Adams                            RLAdams@AdamsInfoServ.com

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

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