From: Nick Dokos <nicholas.dokos@hp.com>
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>
Subject: Re: wrap long table formula
Date: Tue, 01 Nov 2011 15:13:29 -0400 [thread overview]
Message-ID: <4851.1320174809@alphaville.americas.hpqcorp.net> (raw)
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>
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
prev parent reply other threads:[~2011-11-01 19:13 UTC|newest]
Thread overview: 10+ messages / expand[flat|nested] mbox.gz Atom feed top
2011-10-31 14:01 wrap long table formula henry atting
2011-10-31 14:05 ` Carsten Dominik
2011-10-31 14:21 ` henry atting
2011-10-31 18:10 ` Samuel Wales
2011-10-31 19:12 ` Carsten Dominik
2011-11-01 7:17 ` henry atting
2011-11-01 7:29 ` Christian Moe
2011-11-01 14:40 ` Nick Dokos
2011-11-01 18:53 ` henry atting
2011-11-01 19:13 ` Nick Dokos [this message]
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=4851.1320174809@alphaville.americas.hpqcorp.net \
--to=nicholas.dokos@hp.com \
--cc=carsten.dominik@gmail.com \
--cc=emacs-orgmode@gnu.org \
--cc=mail@christianmoe.com \
--cc=nsmp_02@online.de \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).