From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: How to ignore horizontal lines in tables and references Date: Mon, 3 Aug 2009 06:37:48 +0200 Message-ID: References: <87iqh8x6nu.fsf@in-ulm.de> Mime-Version: 1.0 (Apple Message framework v935.3) Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1MXpJ6-000159-M9 for emacs-orgmode@gnu.org; Mon, 03 Aug 2009 00:37:56 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1MXpJ1-000104-Mw for emacs-orgmode@gnu.org; Mon, 03 Aug 2009 00:37:56 -0400 Received: from [199.232.76.173] (port=33774 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1MXpJ1-0000zv-Hu for emacs-orgmode@gnu.org; Mon, 03 Aug 2009 00:37:51 -0400 Received: from ey-out-1920.google.com ([74.125.78.148]:34241) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1MXpJ0-00038Q-Tz for emacs-orgmode@gnu.org; Mon, 03 Aug 2009 00:37:51 -0400 Received: by ey-out-1920.google.com with SMTP id 5so853865eyb.24 for ; Sun, 02 Aug 2009 21:37:50 -0700 (PDT) In-Reply-To: <87iqh8x6nu.fsf@in-ulm.de> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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: Benjamin Andresen Cc: Org Mode On Jul 31, 2009, at 4:34 PM, Benjamin Andresen wrote: > 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 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. The fact that relative references are not allowed to cross horizontal separator lines is an old feature which I implemented fro some obscure reason. I think now is the tie to get rid of it, because it causes more confusion than anything. I have just pushed a change to this effect, thanks for bringing it up. - Carsten > > Thanks in advance, > benny > > > _______________________________________________ > Emacs-orgmode mailing list > Remember: use `Reply All' to send replies to the list. > Emacs-orgmode@gnu.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode