From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: reference to same row in spreadsheet Date: Thu, 18 Dec 2008 17:25:14 +0100 Message-ID: References: <494A65E5.8050309@cs.tu-berlin.de> Mime-Version: 1.0 (Apple Message framework v929.2) 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 1LDLge-0008Dv-Px for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 11:25:20 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LDLge-0008DJ-0u for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 11:25:20 -0500 Received: from [199.232.76.173] (port=58667 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LDLgd-0008DA-R5 for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 11:25:19 -0500 Received: from ug-out-1314.google.com ([66.249.92.169]:39812) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1LDLgd-0002Pn-EI for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 11:25:19 -0500 Received: by ug-out-1314.google.com with SMTP id 36so545788uga.17 for ; Thu, 18 Dec 2008 08:25:17 -0800 (PST) In-Reply-To: <494A65E5.8050309@cs.tu-berlin.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: Stephan Schmitt Cc: emacs-orgmode@gnu.org You are right, this is an incompatible change. Dammit. What should do? Opinions? The problem is that this change may lead to older tables evaluated incorrectly. I do like the new convention and think that @+0 or leaving out the row specifications are good alternatives - but maybe we are obliged to keep the old convention.... - Carsten On Dec 18, 2008, at 4:01 PM, Stephan Schmitt wrote: > Hello, > > the reference to the last row @0 led to incompatible changes: > > * spreadsheet: relative reference to same row > (using Org mode version 6.15d) > > The Org mode version 6.15 introduced @0 as a reference to the last > row for spreadsheet (org-table) formulas. This leads to problems if > you used it as reference to the same row before. > > - description from [[http://orgmode.org/Changes.html][Org-mode list > of > user-visible changes]]: > > Spreadsheet references to the last table line. > > You may now use @0 to reference the last dataline in a table in a > stable way. > > - according to [[info:org:References]]: > > `0' refers to the current row and column. Also, if you omit > either the column or the row part of the reference, the current > row/column is implied. > > However this doesn't work since @0 refers to the last line. > > If you press `C-c *' with the cursor inside the tables below, the > second column should contain the doubled value of the first. > > ** @0 refers to last line > > |---+---| > | 1 | 4 | > | 2 | 4 | > |---+---| > #+TBLFM: $2=2*@0$-1 > > this has worked before as reference to the same row, now it refers > to the last row > > ** bug: omitting explicit reference > > |---+--------| > | 1 | #ERROR | > | 2 | #ERROR | > |---+--------| > #+TBLFM: $2=2*$-1 > > this seems to be a bug, should refer to the same row > > ** @+0 refers to same row > > |---+---| > | 1 | 2 | > | 2 | 4 | > |---+---| > #+TBLFM: $2=2*@+0$-1 > > works as expected > > > Greetings, > Stephan > > > > _______________________________________________ > 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