From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nick Dokos <nicholas.dokos@hp.com>
Subject: Re: wrap long table formula
Date: Tue, 01 Nov 2011 15:13:29 -0400
Message-ID: <4851.1320174809@alphaville.americas.hpqcorp.net>
References: <871utt45w4.fsf@bye.fritz.box>
	<479AAB0D-5CA9-48F8-9CCC-A9DAA75C841C@gmail.com>
	<87wrbl2qeo.fsf@bye.fritz.box>
	<CAJcAo8udjAQQAjgjUEVhiMKiOnOph2jTB_fUnoyJCsFrNR5h_g@mail.gmail.com>
	<CE1D37D6-F4BD-4BCF-8BF6-4728990BCE88@gmail.com>
	<874nyojopl.fsf@bye.fritz.box> <4EAF9FCD.6070605@christianmoe.com>
	<8957.1320158456@alphaville.dokosmarshall.org>
	<87wrbjptbu.fsf@bye.fritz.box>
Reply-To: nicholas.dokos@hp.com
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:37164)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <nicholas.dokos@hp.com>) id 1RLJmM-00019y-QB
	for emacs-orgmode@gnu.org; Tue, 01 Nov 2011 15:13:47 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <nicholas.dokos@hp.com>) id 1RLJmL-00069z-Hr
	for emacs-orgmode@gnu.org; Tue, 01 Nov 2011 15:13:46 -0400
Received: from g1t0028.austin.hp.com ([15.216.28.35]:9464)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <nicholas.dokos@hp.com>) id 1RLJmL-00065y-99
	for emacs-orgmode@gnu.org; Tue, 01 Nov 2011 15:13:45 -0400
In-Reply-To: Message from henry atting <nsmp_02@online.de>
	of "Tue, 01 Nov 2011 19:53:57 BST." <87wrbjptbu.fsf@bye.fritz.box>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: henry atting <nsmp_02@online.de>
Cc: nicholas.dokos@hp.com, emacs-orgmode@gnu.org, mail@christianmoe.com, Carsten Dominik <carsten.dominik@gmail.com>

henry atting <nsmp_02@online.de> wrote:

> Nick Dokos <nicholas.dokos@hp.com> writes:
> 
> > Christian Moe <mail@christianmoe.com> wrote:
> >
> >> |   |     |
> >> |---+-----|
> >> | 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)
> >

> 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?
> 

All of this is contained in

    (info "(org) The spreadsheet")

but sometimes you have to read the section a few times (and refer back
to it a few more times): in particular

   (info "(org) References")

and

   (info "(org) Field and range formulas")

deserve repeated reading. 

   (info "(org) Column formulas")

describes the field formula trick.

The whole spreadsheet section of the manual could benefit from a list of
well chosen examples (perhaps on Worg, with a pointer from the manual).
But afaict, everything is in the manual.

Nick