[Orgmode] Reference to same row in spreadsheet

[Carsten Dominik]

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: 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