From mboxrd@z Thu Jan 1 00:00:00 1970 From: Stephan Schmitt Subject: Re: reference to same row in spreadsheet Date: Thu, 18 Dec 2008 17:50:58 +0100 Message-ID: <494A7F72.1000700@cs.tu-berlin.de> References: <494A65E5.8050309@cs.tu-berlin.de> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1LDM69-0003pz-Or for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 11:51:41 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LDM68-0003pT-3L for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 11:51:41 -0500 Received: from [199.232.76.173] (port=59533 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LDM67-0003pN-Td for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 11:51:40 -0500 Received: from mail.cs.tu-berlin.de ([130.149.17.13]:33211) by monty-python.gnu.org with esmtps (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1LDM67-00075e-CZ for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 11:51:39 -0500 Received: from localhost (localhost [127.0.0.1]) by localhost-12225.cs.tu-berlin.de (Postfix) with ESMTP id B93F028265 for ; Thu, 18 Dec 2008 17:51:36 +0100 (MET) In-Reply-To: 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 For me the new behaviour is fine, if leaving out the row specification works. The distinction between @0 and @+0 would work, too, but is rather confusing and hard to remember. I think both should represent either the last or the current row. Greetings, Stephan Carsten Dominik wrote: > 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 >