From: Nick Dokos <ndokos@gmail.com>
To: Gunnar Wolf <gwolf@gwolf.org>
Cc: emacs-orgmode@gnu.org
Subject: Re: Tables for attendance lists - A problem understanding TBLFM?
Date: Tue, 9 Apr 2013 11:10:13 -0400 [thread overview]
Message-ID: <CANU-iVAkPXo1rcFYyCpDKsmmeHK3bo359FFJtPmBGdkq4ojN+Q@mail.gmail.com> (raw)
In-Reply-To: <20130409145509.GC115357@gwolf.org>
[-- Attachment #1: Type: text/plain, Size: 1404 bytes --]
On Tue, Apr 9, 2013 at 10:55 AM, Gunnar Wolf <gwolf@gwolf.org> wrote:
>
> > Try this:
> >
> > #+CAPTION: Attendances for April
> > |---------+-------------------+---+---+---+---+----+-------|
> > | Account | Name | 1 | 3 | 5 | 8 | 10 | Total |
> > |---------+-------------------+---+---+---+---+----+-------|
> > | 1234 | Cárdenas, Lázaro | X | | X | X | | 3 |
> > | 5678 | Madero, Francisco | X | X | X | X | | 4 |
> > | 1544 | Villa, Pancho | | | | | | 0 |
> > | 0113 | Zapata, Emiliano | | X | X | | | 2 |
> > |---------+-------------------+---+---+---+---+----+-------|
> > #+tblfm: @II+1$>..@III-1$>='(length (delq "" '($<<<..$>>)))
>
> Interesting, my org-mode version behaves differently, and still gives
> '1' for the empty row with your version:
>
> Substitution history of formula
> (...)
> @r$c-> '(length (delq "" '("0")))
> $1-> '(length (delq "" '("0")))
> Result: 1
>
>
Check the formula again: you seem to have captured the 0 from the last
column, instead of stopping at the penultimate column. The range should
be $3..$>> or $<<<..$>> - also, you should have posted the whole
substitution history so we could see the range, instead of me guessing. The
motto should be "More information is better than less", but of course that
should be tempered by common sense :-)
HTH,
Nick
[-- Attachment #2: Type: text/html, Size: 2663 bytes --]
next prev parent reply other threads:[~2013-04-09 15:10 UTC|newest]
Thread overview: 21+ messages / expand[flat|nested] mbox.gz Atom feed top
2013-04-08 23:57 Tables for attendance lists - A problem understanding TBLFM? Gunnar Wolf
2013-04-09 0:25 ` Suvayu Ali
2013-04-09 2:21 ` Gunnar Wolf
2013-04-09 3:31 ` Nick Dokos
2013-04-09 3:34 ` Nick Dokos
2013-04-09 12:40 ` Michael Brand
2013-04-09 14:57 ` Gunnar Wolf
2013-04-09 17:06 ` Bastien
2013-04-11 12:15 ` Michael Brand
2013-04-14 8:04 ` Michael Brand
2013-04-14 10:11 ` Bastien
2013-04-14 11:17 ` Michael Brand
2013-04-14 23:28 ` Bastien
2013-04-09 14:55 ` Gunnar Wolf
2013-04-09 15:10 ` Nick Dokos [this message]
2013-04-09 15:31 ` Gunnar Wolf
2013-04-09 15:34 ` Michael Brand
2013-04-09 15:50 ` Michael Brand
2013-04-09 16:03 ` Nick Dokos
2013-04-09 16:13 ` Gunnar Wolf
2013-04-09 12:41 ` Michael Brand
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=CANU-iVAkPXo1rcFYyCpDKsmmeHK3bo359FFJtPmBGdkq4ojN+Q@mail.gmail.com \
--to=ndokos@gmail.com \
--cc=emacs-orgmode@gnu.org \
--cc=gwolf@gwolf.org \
/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).