emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Orgmode] reference to same row in spreadsheet


From: Stephan Schmitt
Subject: [Orgmode] reference to same row in spreadsheet
Date: Thu, 18 Dec 2008 16:01:57 +0100
User-agent: Thunderbird 2.0.0.18 (X11/20081124)

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





reply via email to

[Prev in Thread] Current Thread [Next in Thread]