Nick Dokos <nicholas.do...@hp.com> writes:
> Christian Moe <m...@christianmoe.com> 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(@2$1..@3$1::@4$2=vmean(@2$1..@4$1
>>
>>
>> | | |
>> |---+-----|
>> | 2 | |
>> | 6 | 4 |
>> | 7 | 5 |
>> | 3 | 4.5 |
>> | 9 | 5.4 |
>> #+TBLFM: @3$2..@>$2=vmean(@2$1..@0$1)
>>
>
> 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(@2$1..@0$2)
>
> 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
