emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
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

             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

  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=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 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).