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...@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...@+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
_______________________________________________
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