remote refs in spreadsheet

remote refs in spreadsheet

[Alan Bram]

[-- Attachment #1: Type: text/plain, Size: 631 bytes --]

I'm having trouble using a remote reference in an Org-mode spreadsheet.

The Info node entitled "References" says that the first argument to the
"remote()" expression "... can also be the ID of an entry, even in a
different file, ...". What does this mean? What is the syntax for defining
and referring to an "ID"?

I tried making a file called "report.org" like this:

* report output
:PROPERTIES:
:CUSTOM_ID: foo
:END:

| abcde | 17 |
| xyzzy | 42 |


And then I tried to refer to it from an Org-mode spreadsheet in a different
file, like this:

#+TBLFM: @2$1=remote(file:report.org#foo, @2$2)


But it said "invalid reference".

[-- Attachment #2: Type: text/html, Size: 1623 bytes --]

Re: remote refs in spreadsheet

[Alan Bram]

[-- Attachment #1: Type: text/plain, Size: 584 bytes --]

On Sat, Mar 15, 2014 at 4:18 PM, Alan Bram <alanbram@speakeasy.net> wrote:

> I'm having trouble using a remote reference in an Org-mode spreadsheet.
>

Finally found Carsten's answer (1) to this same question from four years
ago. Don't know why I missed it while searching the archives yesterday.

Still, I've fumbled around for a while trying to understand how to get the
org-id module turned on, and how to write the syntax in the "remote()"
formula. (No syntax at all, it turns out. Just the ID value itself.)

(1) https://www.mail-archive.com/emacs-orgmode@gnu.org/msg21313.html

[-- Attachment #2: Type: text/html, Size: 1135 bytes --]