From: Benjamin Andresen <benny@in-ulm.de>
To: emacs-orgmode@gnu.org
Subject: How to ignore horizontal lines in tables and references
Date: Fri, 31 Jul 2009 16:34:45 +0200 [thread overview]
Message-ID: <87iqh8x6nu.fsf@in-ulm.de> (raw)
Hello everyone,
I'm having a bit of a problem with tables and references. I try to use
tables + spreadsheet capabilities for data entry while testing certain
things, and one table design that works conceptually for me is the
following:
| Attempt | Start | End | Success | Wait in Min |
|---------+------------------------+------------------------+---------+-------------|
| 1 | <2009-07-31 Fri 04:43> | <2009-07-31 Fri 04:44> | No | 1 |
| 2 | <2009-07-31 Fri 04:45> | <2009-07-31 Fri 04:46> | No | 1 |
| 3 | <2009-07-31 Fri 04:48> | <2009-07-31 Fri 04:49> | No | 1 |
|---------+------------------------+------------------------+---------+-------------|
| Results | | | 0% | 1 |
#+TBLFM: $5='(ba/org-time-diff-min $2 $3)::@5$4='(ba/find "Yes"|'(@2$4..@4$4))::@5$5=vmean(@2$5..@4$5);%.1f
The problem I'm having is when my cursor is at @4$1 and I'm pressing RET.
It creates a new row where I can enter new data, as expected.
It will increment the
@5$5 part to @6$5
Now the problem is when I try to automate the formulas a bit.
If I would instead of
@5$5=vmean(@2$5..@4$5);%.1f
use
@5$5=vmean(@2$5..@-1$5);%.1f
the following message will come up during evaluation:
Row descriptor -1 used in line <line> crosses hline
Does anyone have any idea how I can make this work? The problem goes
away when I delete the horizontal line. If my table design is wrong or
there is a better way to do what I'm open to changing it.
Thanks in advance,
benny
next reply other threads:[~2009-07-31 14:35 UTC|newest]
Thread overview: 4+ messages / expand[flat|nested] mbox.gz Atom feed top
2009-07-31 14:34 Benjamin Andresen [this message]
2009-07-31 14:54 ` How to ignore horizontal lines in tables and references Benjamin Andresen
2009-07-31 15:10 ` Nick Dokos
2009-08-03 4:37 ` Carsten Dominik
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
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=87iqh8x6nu.fsf@in-ulm.de \
--to=benny@in-ulm.de \
--cc=emacs-orgmode@gnu.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 external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.