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 23:14:32 +0100 Message-ID: <73C77123-15BF-47B9-A8D4-28073D85EEA0@uva.nl> References: <494A65E5.8050309@cs.tu-berlin.de> <494A7F72.1000700@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 1LDRpt-0006PT-MB for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 17:59:17 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LDRps-0006Oq-Eu for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 17:59:16 -0500 Received: from [199.232.76.173] (port=52846 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LDRps-0006On-8C for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 17:59:16 -0500 Received: from nf-out-0910.google.com ([64.233.182.187]:10062) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1LDRpq-0000oD-CL for emacs-orgmode@gnu.org; Thu, 18 Dec 2008 17:59:14 -0500 Received: by nf-out-0910.google.com with SMTP id c7so105812nfi.26 for ; Thu, 18 Dec 2008 14:59:13 -0800 (PST) In-Reply-To: <494A7F72.1000700@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 Hi all, thanks for your constructive contributions to the thread. However, I will still reverse the change that introduced @0 as a reference to the last line. The risk that someone will be bitten by this is too high, and @0 is really too similar to @+0, so I think the distinction is not large enough. I will try to find a different solution, like @last$2 or so, but this is harder to implement and will take a little while. Sorry Matt. The reason why I am in a hurry to revert this change is, among others, because Emacs 23 might go into pretest very soon, and I really want a clean, good version to ship with it. - Carsten On Dec 18, 2008, at 5:50 PM, Stephan Schmitt wrote: > 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 >>