Re: [O] wrap long table formula

[henry atting]

Nick Dokos <address@hidden> writes:

> 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

Thanks again to all, both solutions are working fine; I could get rid of my
tapeworm formula.

Is there a place where these advanced features are explained more thoroughly?

henry

-- 
http://literaturlatenight.de