|
From: | Carsten Dominik |
Subject: | [Orgmode] Reference to same row in spreadsheet |
Date: | Fri, 19 Dec 2008 18:49:03 +0100 |
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 lastrow for spreadsheet (org-table) formulas. This leads to problems ifyou used it as reference to the same row before.- description from [[http://orgmode.org/Changes.html][Org-mode list ofuser-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: address@hidden 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: address@hidden works as expected Greetings, Stephan _______________________________________________ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. address@hidden http://lists.gnu.org/mailman/listinfo/emacs-orgmode
[Prev in Thread] | Current Thread | [Next in Thread] |