From: Christian Moe <mail@christianmoe.com>
To: nicholas.dokos@hp.com, jamshark70@gmail.com,
Org Mode <emacs-orgmode@gnu.org>
Subject: Re: Table cell refs with @0 or $0 are broken
Date: Wed, 04 Apr 2012 22:24:25 +0200 [thread overview]
Message-ID: <4F7CADF9.8070609@christianmoe.com> (raw)
In-Reply-To: <5119.1333559874@alphaville>
On 4/4/12 7:17 PM, Nick Dokos wrote:
> James Harkins<jamshark70@gmail.com> wrote:
>
>> Don't know if this is fixed in a later org update, but -- the online
>> org manual says that you can refer to table cells in the current row
>> or column using @0 and $0 respectively, but that's definitely not
>> working on my machine.
(...)
>> ** Broken: "Not in table data field"
>> | 1.0 |
>> | 2.0 |
>> | |
>> #+TBLFM: @>$1=vsum(@1$0..@2$0)
(...)
> Did this ever work? I've spot-checked back to 6.36c and I cannot find
> a release where it actually worked: assuming I haven't made a mistake,
> it seems to be an implementation oversight, rather than some patch
> specifically breaking the functionality.
>
> Nick
>
I find that zero references do work, albeit not quite as one might be
led to believe by the manual.
Agreed, it does not work in James' example. And agreed, the manual
seems to me to suggest, to the contrary, that `@1$0' should work.
Though it does also make clear that the `$0' is superfluous and can be
omitted, because when only the row is given, the current column is
taken as implied. So we all agree `@1' works.
But consider the following example, which also works. Here is some
output from fitting a linear trend in Org-Babel/R. (I've shaved off
some decimals to fit this in an email.) Computing the TBLFM will round
the number in each cell to three decimal places.
#+results:
| Record | Slope | ConfLower | ConfUpper |
|----------+--------------+--------------+--------------|
| GISTEMP | 0.0173837600 | 0.0133209130 | 0.0214466060 |
| HadCrut3 | 0.0158602890 | 0.0118664610 | 0.0198541180 |
#+TBLFM: @2$2..@>$>=@0;%.3f
Try substituting `$0' for `@0', it works the same. @0 designates the
current row, and the current column is taken as implied. Ditto when $0
designates the current column. However, `@0$0' will not work.
It would seem that either one of $0 and @0 on its own in practice
designates "the current cell".
Also, I can't think of a situation where either would be needed to
designate a whole column or row respectively.
Yours,
Christian
next prev parent reply other threads:[~2012-04-04 20:24 UTC|newest]
Thread overview: 11+ messages / expand[flat|nested] mbox.gz Atom feed top
2012-04-04 9:35 Table cell refs with @0 or $0 are broken James Harkins
2012-04-04 17:17 ` Nick Dokos
2012-04-04 20:24 ` Christian Moe [this message]
2012-04-04 20:59 ` Nick Dokos
2012-04-04 21:05 ` Nick Dokos
2012-04-04 21:13 ` Christian Moe
2012-04-04 22:36 ` Nick Dokos
2012-04-09 18:07 ` Bastien
2012-04-09 18:13 ` Nick Dokos
2012-04-09 18:19 ` Bastien
2012-04-05 0:35 ` James Harkins
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=4F7CADF9.8070609@christianmoe.com \
--to=mail@christianmoe.com \
--cc=emacs-orgmode@gnu.org \
--cc=jamshark70@gmail.com \
--cc=nicholas.dokos@hp.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).