From: Gunnar Wolf <gwolf@gwolf.org>
To: Nick Dokos <ndokos@gmail.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: Tables for attendance lists - A problem understanding TBLFM?
Date: Tue, 9 Apr 2013 09:55:09 -0500 [thread overview]
Message-ID: <20130409145509.GC115357@gwolf.org> (raw)
In-Reply-To: <CANU-iVAbsDbrAqo-8dp1OW-UOzJuaWgi-7YRuvxNpAdc+fAP2Q@mail.gmail.com>
Nick Dokos dijo [Mon, Apr 08, 2013 at 11:31:14PM -0400]:
> You can turn on formula debugging with C-c { and then you'd
> see that in Pancho's case, the list is ("") i.e. a list containing the
> empty string - a list of length 1. That might qualify as a bug (or not) but
>
> you can easily work around it, using (delq "" list) which deletes empty
> strings from the list.
Ok - I was not sure on how to use/interpret the debugging facility,
but it will surely help me
> 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
I tried substituting the empty quotes in the 'delq' with "0", '(""),
'("0")... but always got the same result: 1.
> I kept just one formula for clarity. I also tried to avoid absolute
> row and column numbers (the $3 seemed better than $<<< though
> so I kept it)
> : @II is the second separator, $> is the last column
> and $>> is the penultimate column.
Right, I want to better understand relative addressing, as each month
has a different number of columns (and some have different number of
rows), and I'd prefer having the same formulas everywhere. How would
you suggest me to address "from the third and until the next-to-last
column"?
next prev parent reply other threads:[~2013-04-09 14:55 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 [this message]
2013-04-09 15:10 ` Nick Dokos
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=20130409145509.GC115357@gwolf.org \
--to=gwolf@gwolf.org \
--cc=emacs-orgmode@gnu.org \
--cc=ndokos@gmail.com \
/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).