From mboxrd@z Thu Jan  1 00:00:00 1970
From: Benjamin Andresen <benny@in-ulm.de>
Subject: How to ignore horizontal lines in tables and references
Date: Fri, 31 Jul 2009 16:34:45 +0200
Message-ID: <87iqh8x6nu.fsf@in-ulm.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1MWtCS-0006mz-Ne
	for emacs-orgmode@gnu.org; Fri, 31 Jul 2009 10:35:12 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1MWtCN-0006hf-Pv
	for emacs-orgmode@gnu.org; Fri, 31 Jul 2009 10:35:12 -0400
Received: from [199.232.76.173] (port=60981 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1MWtCN-0006hG-AI
	for emacs-orgmode@gnu.org; Fri, 31 Jul 2009 10:35:07 -0400
Received: from mail.in-ulm.de ([217.10.8.10]:34817)
	by monty-python.gnu.org with smtp (Exim 4.60)
	(envelope-from <benny@in-ulm.de>) id 1MWtCM-0004r4-JS
	for emacs-orgmode@gnu.org; Fri, 31 Jul 2009 10:35:07 -0400
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

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