Re: [O] wrap long table formula

[Nick Dokos]

Christian Moe <address@hidden> wrote:

> On 11/1/11 8:17 AM, henry atting wrote:
> 
> > I was thinking of a column formula but have no clue if it's
> > possible and if so, how.
> >
> > In this short example the formula's length is no problem but for a
> > table with 12 rows or more it certainly is; -- and currently it's the
> > only way I can realize it.
> >
> > |   |   |
> > |---+---|
> > | 2 |   |
> > | 6 | 4 |
> > | 7 | 5 |
> > #+TBLFM: @3$2=vmean(@address@hidden::@4$2=vmean(@address@hidden
> 
> 
> |   |     |
> |---+-----|
> | 2 |     |
> | 6 |   4 |
> | 7 |   5 |
> | 3 | 4.5 |
> | 9 | 5.4 |
> #+TBLFM: @3$2..@>$2=vmean(@address@hidden)
> 

Another common way to deal with an exceptional cell is to use a field
formula for the exceptional cell and a column formula for the rest:
field formulas take precedence:

#+TBLFM: @2$2 = string("") :: $2 = vmean(@address@hidden)

Nick