Re: reference to same row in spreadsheet

From: Carsten Dominik <dominik@science.uva.nl>
To: Stephan Schmitt <drmabuse@cs.tu-berlin.de>
Cc: emacs-orgmode@gnu.org
Subject: Re: reference to same row in spreadsheet
Date: Thu, 18 Dec 2008 17:25:14 +0100	[thread overview]
Message-ID: <D72050B6-53AA-44DD-A4D3-3EF12C293BBA@uva.nl> (raw)
In-Reply-To: <494A65E5.8050309@cs.tu-berlin.de>

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