From mboxrd@z Thu Jan 1 00:00:00 1970 From: Stephan Schmitt Subject: reference to same row in spreadsheet Date: Thu, 18 Dec 2008 16:01:57 +0100 Message-ID: <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 1LDKOt-0000r5-WF for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 10:02:56 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LDKOs-0000mW-39 for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 10:02:55 -0500 Received: from [199.232.76.173] (port=43508 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LDKOr-0000m9-UW for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 10:02:53 -0500 Received: from mail.cs.tu-berlin.de ([130.149.17.13]:60162) by monty-python.gnu.org with esmtps (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1LDKOr-00084K-CG for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 10:02:53 -0500 Received: from localhost (localhost [127.0.0.1]) by localhost-12225.cs.tu-berlin.de (Postfix) with ESMTP id B485A287A8 for ; Thu, 18 Dec 2008 16:02:50 +0100 (MET) Received: from mailhost.cs.tu-berlin.de ([127.0.0.1]) by localhost (mail.cs.tu-berlin.de [127.0.0.1]) (amavisd-new, port 12224) with ESMTP id QmoT79jHRJEC 16488-19 for ; Thu, 18 Dec 2008 16:02:40 +0100 (MET) 16097 Received: from [130.149.24.75] (algieba.ni.cs.tu-berlin.de [130.149.24.75]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: drmabuse) by mailhost.cs.tu-berlin.de (Postfix) with ESMTPSA for ; Thu, 18 Dec 2008 16:02:40 +0100 (MET) 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: emacs-orgmode@gnu.org 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