From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Reference to same row in spreadsheet Date: Fri, 19 Dec 2008 18:49:03 +0100 Message-ID: <6A739C05-988F-41CA-95A9-78E5223DD524@uva.nl> References: <494A65E5.8050309@cs.tu-berlin.de> <494A7F72.1000700@cs.tu-berlin.de> <73C77123-15BF-47B9-A8D4-28073D85EEA0@uva.nl> 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 1LDjTI-0008Cn-Vm for emacs-orgmode@gnu.org; Fri, 19 Dec 2008 12:49:09 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LDjTI-0008CJ-33 for emacs-orgmode@gnu.org; Fri, 19 Dec 2008 12:49:08 -0500 Received: from [199.232.76.173] (port=43196 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LDjTH-0008CC-Qq for emacs-orgmode@gnu.org; Fri, 19 Dec 2008 12:49:07 -0500 Received: from ug-out-1314.google.com ([66.249.92.168]:62286) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1LDjTH-0005tA-5w for emacs-orgmode@gnu.org; Fri, 19 Dec 2008 12:49:07 -0500 Received: by ug-out-1314.google.com with SMTP id 36so670107uga.17 for ; Fri, 19 Dec 2008 09:49:06 -0800 (PST) In-Reply-To: <73C77123-15BF-47B9-A8D4-28073D85EEA0@uva.nl> 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: Stephan Schmitt , Emacs-orgmode mailing list With the latest push to the git repo, you can use $LR1, $LR2, ... to reference fields in the last row. HTH - Carsten On Dec 18, 2008, at 11:14 PM, Carsten Dominik wrote: > 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 >>> >