From mboxrd@z Thu Jan 1 00:00:00 1970 From: Tassilo Horn Subject: Re: Spreadsheet question Date: Thu, 04 Dec 2008 11:49:53 +0100 Message-ID: <877i6gcizy.fsf@thinkpad.tsdh.de> References: <87abbdc58q.fsf@thinkpad.tsdh.de> <6BD7F784-D3F6-4953-9156-11A9F3136B72@uva.nl> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1L8BmS-0003i3-LI for emacs-orgmode@gnu.org; Thu, 04 Dec 2008 05:50:00 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1L8BmR-0003hk-4L for emacs-orgmode@gnu.org; Thu, 04 Dec 2008 05:50:00 -0500 Received: from [199.232.76.173] (port=55427 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1L8BmR-0003hb-0O for emacs-orgmode@gnu.org; Thu, 04 Dec 2008 05:49:59 -0500 Received: from deliver.uni-koblenz.de ([141.26.64.15]:6997) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1L8BmQ-0001j7-K2 for emacs-orgmode@gnu.org; Thu, 04 Dec 2008 05:49:58 -0500 In-Reply-To: <6BD7F784-D3F6-4953-9156-11A9F3136B72@uva.nl> (Carsten Dominik's message of "Thu, 4 Dec 2008 09:06:18 +0100") 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: Carsten Dominik Cc: emacs-orgmode@gnu.org Carsten Dominik writes: Hi Carsten, > @-1 references the row above the current. If that is a hline, if > actually references the current line. Yes, I see that, but I wonder if that's actually the right thing to do. IMO defaulting to some cell/row/column which is not referenced correctly might obscure wrong formulas. For example, in my case the first calculation gave 2 which is correct and only the second recalculation shows me that the forumla is wrong. So I'd prefer an #ERROR if a reference doesn't exist. Bye, Tassilo