remote reference

remote reference

[Karl Eichwalder]

I do not understand how I can reference tables (only the first one?)
in remote files.  The manual says:

Remote references
.................

You may also reference constants, fields and ranges from a different
table, either in the current file or even in a different file.  The
syntax is

     remote(NAME-OR-ID,REF)

where NAME can be the name of a table in the current file as set by a
`#+TBLNAME: NAME' line before the table.  It can also be the ID of an
entry, even in a different file, and the reference then refers to the
first table in that entry.  REF is an absolute field or range reference
as described above for example `@3$3' or `$somename', valid in the
referenced table.

========================================================================

remote(FILENAME,REF) does not seem to work.  All the tutorials I
found are either too basic or too advanced or too general.


-- 
Karl Eichwalder

Re: remote reference

[Sébastien Vauban]

Hi Karl,

"Karl Eichwalder" wrote:
> I do not understand how I can reference tables (only the first one?)
> in remote files.  The manual says:
>
> [...]
>
> remote(FILENAME,REF) does not seem to work.  All the tutorials I
> found are either too basic or too advanced or too general.

For an example, see my post of 2010-01-13 11:23, with title "Re: org-table and
formulas", trying to answer a (much more complex, in fact) question from Alan
Boudreault.

HTH,
  Seb

-- 
Sébastien Vauban



_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode-mXXj517/zsQ@public.gmane.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode

Re: remote reference

[Carsten Dominik]

On Jan 15, 2010, at 9:49 AM, Karl Eichwalder wrote:

> I do not understand how I can reference tables (only the first one?)
> in remote files.  The manual says:
>
> Remote references
> .................
>
> You may also reference constants, fields and ranges from a different
> table, either in the current file or even in a different file.  The
> syntax is
>
>     remote(NAME-OR-ID,REF)
>
> where NAME can be the name of a table in the current file as set by a
> `#+TBLNAME: NAME' line before the table.  It can also be the ID of an
> entry, even in a different file, and the reference then refers to the
> first table in that entry.  REF is an absolute field or range  
> reference
> as described above for example `@3$3' or `$somename', valid in the
> referenced table.
>
> = 
> = 
> ======================================================================
>
> remote(FILENAME,REF) does not seem to work.  All the tutorials I
> found are either too basic or too advanced or too general.


For tables in a different file, the remote table must be the first  
table in an outline node, and the outline node must have an ID property.

First configure org-modules and turn on the id module.
Then prepare your target file like this

* here is my table
   :PROPERTIES:
   :ID: DDE64190-0C3D-4088-A303-DA3B60ECEB48
   :END:

    and here we have the table.

    |...|...|...|


The ID can be an arbitrary string, but then you must
make sure yourself that it is globally unique.  Or you
can have Org-mode make the ID for you.

Hope this gets you on the way.

- Carsten


>
>
> -- 
> Karl Eichwalder
>
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode

- Carsten

Re: remote reference

[Sébastien Vauban]

Hi Karl,

> "Karl Eichwalder" wrote:
>> I do not understand how I can reference tables (only the first one?)
>> in remote files.  The manual says:
>>
>> [...]
>>
>> remote(FILENAME,REF) does not seem to work.  All the tutorials I
>> found are either too basic or too advanced or too general.
>
> For an example, see my post of 2010-01-13 11:23, with title "Re: org-table
> and formulas", trying to answer a (much more complex, in fact) question from
> Alan Boudreault.

Sorry, I read too quickly, and didn't spot the fact you wanted to reference a
table in another file...

Interesting question!!

Best regards,
  Seb

-- 
Sébastien Vauban



_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode-mXXj517/zsQ@public.gmane.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode

Re: remote reference

[Giovanni Ridolfi]

Carsten,  

I cannot reference fields in tables as the manual says. 
Org-mode version 6.34
GNU Emacs 23.1.1 (i386-mingw-nt5.1.2600) of 2009-07-30 on SOFT-MJASON

Example:
-------------------------------------------------
* [2010-01-15 ven] table & reference
** table a
#+TBLNAME: Taba
|   | # |  x | y |
|---+---+----+---|
|   | 1 | -2 | 4 |
|   | 2 | -1 | 1 |
|   | 3 |  0 | 0 |
|   | 4 |  1 | 1 |
|   | 5 |  2 | 4 |
| ^ |   |    | a |
** table b
the manual says:  
: remote(NAME-OR-ID,REF)
: REF is an absolute field or range reference
: as described above for example `@3$3' or `$somename', valid in the
: referenced table.

But I found that as a REF I can only  use: 
+ field  a cell  @5$1=remote(Taba,$a)
+ and *NOT* range reference (as $somename) or 
            ranges such as @1$2..@5$2, 
  but in the manual is not explicitly said.
  So I could have misunderstoot the meaning of "range".

See the non working examples:
*** variables
#+TBLNAME: Tabb
|   |   |
|---+---|
| ^ | b |
#+TBLFM: $b=remote(Taba,$a)
*** columns  
#+TBLNAME: Tabc
|   |   |
|   |   |
|   |   |
|   |   |
|   |   |
|---+---|
| ^ | b |
#+TBLFM: $2=remote(Taba,$4)

#+TBLNAME: Tabcc
|   |   |
|   |   |
|   |   |
|   |   |
|   |   |
|---+---|
| ^ | b |
#+TBLFM: @1$2..@5$2=remote(Taba,$4)
*** ranges: 
#+TBLNAME: Tabr
|   |   |
|   |   |
|   |   |
|   |   |
|   |   |
|---+---|
| ^ | b |
#+TBLFM: @1$2..@5$2=remote(Taba,@1$3..@5$3)
------------------------------------------------------------
Is my analysis correct? 
Did I misunderstand the meanong of "range"?
Is the documentation incomplete? 
Is there a bug  and  the documentation is correct?

cheers,
Giovanni

Re: remote reference

[Carsten Dominik]

Hi Giovanni,

ranges are possible in remote references.  However, what
is not allowed it to assign them to a range.  On the left
side of equations you can only have single fields
like @2$3 or a column like $3.

So you might ask what the use of range references then
is?  You can put the ranges into calc functions like
vsum or vmean, or you can get them as lists in an
elisp formula.

Hope this clarifies it a bit....

Looks like someone needs to write a tutorial about that! :-)

- Carsten

On Jan 15, 2010, at 11:29 AM, Giovanni Ridolfi wrote:

>
> Carsten,
>
> I cannot reference fields in tables as the manual says.
> Org-mode version 6.34
> GNU Emacs 23.1.1 (i386-mingw-nt5.1.2600) of 2009-07-30 on SOFT-MJASON
>
> Example:
> -------------------------------------------------
> * [2010-01-15 ven] table & reference
> ** table a
> #+TBLNAME: Taba
> |   | # |  x | y |
> |---+---+----+---|
> |   | 1 | -2 | 4 |
> |   | 2 | -1 | 1 |
> |   | 3 |  0 | 0 |
> |   | 4 |  1 | 1 |
> |   | 5 |  2 | 4 |
> | ^ |   |    | a |
> ** table b
> the manual says:
> : remote(NAME-OR-ID,REF)
> : REF is an absolute field or range reference
> : as described above for example `@3$3' or `$somename', valid in the
> : referenced table.
>
> But I found that as a REF I can only  use:
> + field  a cell  @5$1=remote(Taba,$a)
> + and *NOT* range reference (as $somename) or
>   ranges such as @1$2..@5$2,
> but in the manual is not explicitly said.
> So I could have misunderstoot the meaning of "range".
>
> See the non working examples:
> *** variables
> #+TBLNAME: Tabb
> |   |   |
> |---+---|
> | ^ | b |
> #+TBLFM: $b=remote(Taba,$a)
> *** columns
> #+TBLNAME: Tabc
> |   |   |
> |   |   |
> |   |   |
> |   |   |
> |   |   |
> |---+---|
> | ^ | b |
> #+TBLFM: $2=remote(Taba,$4)
>
> #+TBLNAME: Tabcc
> |   |   |
> |   |   |
> |   |   |
> |   |   |
> |   |   |
> |---+---|
> | ^ | b |
> #+TBLFM: @1$2..@5$2=remote(Taba,$4)
> *** ranges:
> #+TBLNAME: Tabr
> |   |   |
> |   |   |
> |   |   |
> |   |   |
> |   |   |
> |---+---|
> | ^ | b |
> #+TBLFM: @1$2..@5$2=remote(Taba,@1$3..@5$3)
> ------------------------------------------------------------
> Is my analysis correct?
> Did I misunderstand the meanong of "range"?
> Is the documentation incomplete?
> Is there a bug  and  the documentation is correct?
>
> cheers,
> Giovanni
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode

- Carsten

Re: remote reference

[Giovanni Ridolfi]

Carsten Dominik <carsten.dominik@gmail.com> writes:

Hi, Carsten,
>
> On the left 
> side of equations you can only have single fields
> like @2$3 
ok this works
> or a column like $3.
But this does /not/ work: see the example "columns $3"

>> Org-mode version 6.34
>> GNU Emacs 23.1.1 (i386-mingw-nt5.1.2600) of 2009-07-30 on SOFT-MJASON
Example:
-------------------------------------------------
* [2010-01-15 ven] table & reference
** table a
#+TBLNAME: Taba
|   | # |  x | y |
|---+---+----+---|
|   | 1 | -2 | 4 |
|   | 2 | -1 | 1 |
|   | 3 |  0 | 0 |
|   | 4 |  1 | 1 |
|   | 5 |  2 | 4 |
| ^ |   |    | a |
** table b
*** columns $3
|   |   |   |
|   |   |   |
|   |   |   |
|   |   |   |
|   |   |   |
|---+---+---|
|   | ^ | b |
#+TBLFM: $3=remote(Taba,$3)

>
> Looks like someone needs to write a tutorial about that! :-)
>
When I'll have finally understood ;-)

Giovanni

Re: remote reference

[Carsten Dominik]

Hi Giovanny,

yes, that is right, only field references are allowed for direct  
assignment.
Columns or ranges are allowed only as arguments of functions that will  
collapse them into a scalar.

- Carsten

On Jan 18, 2010, at 9:53 AM, Giovanni Ridolfi wrote:

> Carsten Dominik <carsten.dominik@gmail.com> writes:
>
> Hi, Carsten,
>>
>> On the left
>> side of equations you can only have single fields
>> like @2$3
> ok this works
>> or a column like $3.
> But this does /not/ work: see the example "columns $3"
>
>>> Org-mode version 6.34
>>> GNU Emacs 23.1.1 (i386-mingw-nt5.1.2600) of 2009-07-30 on SOFT- 
>>> MJASON
> Example:
> -------------------------------------------------
> * [2010-01-15 ven] table & reference
> ** table a
> #+TBLNAME: Taba
> |   | # |  x | y |
> |---+---+----+---|
> |   | 1 | -2 | 4 |
> |   | 2 | -1 | 1 |
> |   | 3 |  0 | 0 |
> |   | 4 |  1 | 1 |
> |   | 5 |  2 | 4 |
> | ^ |   |    | a |
> ** table b
> *** columns $3
> |   |   |   |
> |   |   |   |
> |   |   |   |
> |   |   |   |
> |   |   |   |
> |---+---+---|
> |   | ^ | b |
> #+TBLFM: $3=remote(Taba,$3)
>
>>
>> Looks like someone needs to write a tutorial about that! :-)
>>
> When I'll have finally understood ;-)
>
> Giovanni

- Carsten

Re: remote reference

[Karl Eichwalder]

Carsten Dominik <carsten.dominik@gmail.com> writes:

> For tables in a different file, the remote table must be the first
> table in an outline node, and the outline node must have an ID
> property.
>
> First configure org-modules and turn on the id module.
> Then prepare your target file like this
>
> * here is my table
>   :PROPERTIES:
>   :ID: DDE64190-0C3D-4088-A303-DA3B60ECEB48
>   :END:
>
>    and here we have the table.
>
>    |...|...|...|
>
>
> The ID can be an arbitrary string, but then you must
> make sure yourself that it is globally unique.  Or you
> can have Org-mode make the ID for you.

This way it works nicely, thanks for the example.  Something related:

C-c C-c in a TBLFM with a remote table reference updates the table as
expected, but also jumps to the referenced table in the remote file.  Is
this intended?  If yes, is it possible to avoid it?

-- 
Karl Eichwalder

Re: remote reference

[Carsten Dominik]

On May 11, 2010, at 9:16 PM, Karl Eichwalder wrote:

> Carsten Dominik <carsten.dominik@gmail.com> writes:
>
>> For tables in a different file, the remote table must be the first
>> table in an outline node, and the outline node must have an ID
>> property.
>>
>> First configure org-modules and turn on the id module.
>> Then prepare your target file like this
>>
>> * here is my table
>>  :PROPERTIES:
>>  :ID: DDE64190-0C3D-4088-A303-DA3B60ECEB48
>>  :END:
>>
>>   and here we have the table.
>>
>>   |...|...|...|
>>
>>
>> The ID can be an arbitrary string, but then you must
>> make sure yourself that it is globally unique.  Or you
>> can have Org-mode make the ID for you.
>
> This way it works nicely, thanks for the example.  Something related:
>
> C-c C-c in a TBLFM with a remote table reference updates the table as
> expected, but also jumps to the referenced table in the remote  
> file.  Is
> this intended?  If yes, is it possible to avoid it?

Hi Karl,

Can you please be more specific.  What exactly happens?

- Carsten

Re: remote reference

[Karl Eichwalder]

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

Carsten Dominik <carsten.dominik@gmail.com> writes:

> On May 11, 2010, at 9:16 PM, Karl Eichwalder wrote:
>> C-c C-c in a TBLFM with a remote table reference updates the table as
>> expected, but also jumps to the referenced table in the remote file.
>> Is
>> this intended?  If yes, is it possible to avoid it?
>
> Can you please be more specific.  What exactly happens?

Consider the following two files:


[-- Attachment #2: 2009 --]
[-- Type: text/plain, Size: 177 bytes --]

* 2009
#+TBLNAME: 2009
  :PROPERTIES:
  :ID:       ea32e5b5-31ba-468e-8e31-3e0d09696bb0
  :END:
|-----+-------|
|  mm |    km |
|-----+-------|
| all | 946.8 |
|-----+-------|


[-- Attachment #3: 2010 --]
[-- Type: text/plain, Size: 620 bytes --]

* 2010
#+TBLNAME: 2010
  :PROPERTIES:
  :ID:       e0df84c4-8abc-458f-a1ee-eb53eb71b4f0
  :END:
|-----+-------+-------+-------|
|  mm |    km |  B km |  G km |
|-----+-------+-------+-------|
| all | 249.4 | 429.2 | 678.6 |
|-----+-------+-------+-------|

* all
  :PROPERTIES:
  :ID:       44751a7f-73a4-4c07-b3c2-e3edb9042acd
  :END:
#+TBLNAME: all
|------+--------|
| yyyy |     km |
|------+--------|
| 2009 |        |
| 2010 |  678.6 |
|------+--------|
|  all | 1625.4 |
|------+--------|
#+TBLFM: @2$2=remote(ea32e5b5-31ba-468e-8e31-3e0d09696bb0,$LR2);%.1f::@3$2=remote(2010,$LR4);%.1f::$LR2=vsum(@2$2..@-1);%.1f

[-- Attachment #4: Type: text/plain, Size: 523 bytes --]


Then, in the 2010 file, eval the formula of the "all" table by pressing
C-c C-c.
==>

It takes the km value from the 2009 file, but also puts the cursor
(point) into the 2009 file in front of the ID:

* 2009
#+TBLNAME: 2009
  :PROPERTIES:
  :ID:       -!-ea32e5b5-31ba-468e-8e31-3e0d09696bb0
  :END:
|-----+-------|
|  mm |    km |
|-----+-------|
| all | 946.8 |
|-----+-------|

-=-=-=-=-=-=-=-=-=-=-=-=-=- cut here -=-=-=-=-=-=-=-=-=-=-=-=-=-

I'd prefer if the point would stay in the 2010 file.

-- 
Karl Eichwalder


[-- Attachment #5: Type: text/plain, Size: 201 bytes --]

_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode

Re: remote reference

[Carsten Dominik]

Fixed, thanks.

- Carsten

On May 12, 2010, at 1:26 PM, Karl Eichwalder wrote:

> Carsten Dominik <carsten.dominik@gmail.com> writes:
>
>> On May 11, 2010, at 9:16 PM, Karl Eichwalder wrote:
>>> C-c C-c in a TBLFM with a remote table reference updates the table  
>>> as
>>> expected, but also jumps to the referenced table in the remote file.
>>> Is
>>> this intended?  If yes, is it possible to avoid it?
>>
>> Can you please be more specific.  What exactly happens?
>
> Consider the following two files:
>
> * 2009
> #+TBLNAME: 2009
>  :PROPERTIES:
>  :ID:       ea32e5b5-31ba-468e-8e31-3e0d09696bb0
>  :END:
> |-----+-------|
> |  mm |    km |
> |-----+-------|
> | all | 946.8 |
> |-----+-------|
>
> * 2010
> #+TBLNAME: 2010
>  :PROPERTIES:
>  :ID:       e0df84c4-8abc-458f-a1ee-eb53eb71b4f0
>  :END:
> |-----+-------+-------+-------|
> |  mm |    km |  B km |  G km |
> |-----+-------+-------+-------|
> | all | 249.4 | 429.2 | 678.6 |
> |-----+-------+-------+-------|
>
> * all
>  :PROPERTIES:
>  :ID:       44751a7f-73a4-4c07-b3c2-e3edb9042acd
>  :END:
> #+TBLNAME: all
> |------+--------|
> | yyyy |     km |
> |------+--------|
> | 2009 |        |
> | 2010 |  678.6 |
> |------+--------|
> |  all | 1625.4 |
> |------+--------|
> #+TBLFM: @2$2=remote(ea32e5b5-31ba-468e-8e31-3e0d09696bb0,$LR2);%. 
> 1f::@3$2=remote(2010,$LR4);%.1f::$LR2=vsum(@2$2..@-1);%.1f
>
> Then, in the 2010 file, eval the formula of the "all" table by  
> pressing
> C-c C-c.
> ==>
>
> It takes the km value from the 2009 file, but also puts the cursor
> (point) into the 2009 file in front of the ID:
>
> * 2009
> #+TBLNAME: 2009
>  :PROPERTIES:
>  :ID:       -!-ea32e5b5-31ba-468e-8e31-3e0d09696bb0
>  :END:
> |-----+-------|
> |  mm |    km |
> |-----+-------|
> | all | 946.8 |
> |-----+-------|
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=- cut here -=-=-=-=-=-=-=-=-=-=-=-=-=-
>
> I'd prefer if the point would stay in the 2010 file.
>
> -- 
> Karl Eichwalder
>

- Carsten

Re: remote reference

[Karl Eichwalder]

Carsten Dominik <carsten.dominik@gmail.com> writes:

> Fixed, thanks.

It is not fixed in the 23.2.91 pre-release, which comes with org 6.33x.
It did not check any other repository (which one?).

> On May 12, 2010, at 1:26 PM, Karl Eichwalder wrote:
>
>> Carsten Dominik <carsten.dominik@gmail.com> writes:
>>
>>> On May 11, 2010, at 9:16 PM, Karl Eichwalder wrote:
>>>> C-c C-c in a TBLFM with a remote table reference updates the table
>>>> as
>>>> expected, but also jumps to the referenced table in the remote file.
>>>> Is
>>>> this intended?  If yes, is it possible to avoid it?
>>>
>>> Can you please be more specific.  What exactly happens?
>>
>> Consider the following two files:
>>
>> * 2009
>> #+TBLNAME: 2009
>>  :PROPERTIES:
>>  :ID:       ea32e5b5-31ba-468e-8e31-3e0d09696bb0
>>  :END:
>> |-----+-------|
>> |  mm |    km |
>> |-----+-------|
>> | all | 946.8 |
>> |-----+-------|
>>
>> * 2010
>> #+TBLNAME: 2010
>>  :PROPERTIES:
>>  :ID:       e0df84c4-8abc-458f-a1ee-eb53eb71b4f0
>>  :END:
>> |-----+-------+-------+-------|
>> |  mm |    km |  B km |  G km |
>> |-----+-------+-------+-------|
>> | all | 249.4 | 429.2 | 678.6 |
>> |-----+-------+-------+-------|
>>
>> * all
>>  :PROPERTIES:
>>  :ID:       44751a7f-73a4-4c07-b3c2-e3edb9042acd
>>  :END:
>> #+TBLNAME: all
>> |------+--------|
>> | yyyy |     km |
>> |------+--------|
>> | 2009 |        |
>> | 2010 |  678.6 |
>> |------+--------|
>> |  all | 1625.4 |
>> |------+--------|
>> #+TBLFM: @2$2=remote(ea32e5b5-31ba-468e-8e31-3e0d09696bb0,$LR2);%.
>> 1f::@3$2=remote(2010,$LR4);%.1f::$LR2=vsum(@2$2..@-1);%.1f
>>
>> Then, in the 2010 file, eval the formula of the "all" table by
>> pressing
>> C-c C-c.
>> ==>
>>
>> It takes the km value from the 2009 file, but also puts the cursor
>> (point) into the 2009 file in front of the ID:
>>
>> * 2009
>> #+TBLNAME: 2009
>>  :PROPERTIES:
>>  :ID:       -!-ea32e5b5-31ba-468e-8e31-3e0d09696bb0
>>  :END:
>> |-----+-------|
>> |  mm |    km |
>> |-----+-------|
>> | all | 946.8 |
>> |-----+-------|
>>
>> -=-=-=-=-=-=-=-=-=-=-=-=-=- cut here -=-=-=-=-=-=-=-=-=-=-=-=-=-
>>
>> I'd prefer if the point would stay in the 2010 file.
>>
>> --
>> Karl Eichwalder
>>
>
> - Carsten
>
>
>
>

-- 
Karl Eichwalder

Re: remote reference

[Carsten Dominik]

On Dec 11, 2010, at 3:42 PM, Karl Eichwalder wrote:

> Carsten Dominik <carsten.dominik@gmail.com> writes:
>
>> Fixed, thanks.
>
> It is not fixed in the 23.2.91 pre-release, which comes with org  
> 6.33x.
> It did not check any other repository (which one?).

This is fixed in our own repository at http://repo.or.cz/w/org-mode.git

It will be in Emacs only with the Emacs 24 release.

- Carsten



>
>> On May 12, 2010, at 1:26 PM, Karl Eichwalder wrote:
>>
>>> Carsten Dominik <carsten.dominik@gmail.com> writes:
>>>
>>>> On May 11, 2010, at 9:16 PM, Karl Eichwalder wrote:
>>>>> C-c C-c in a TBLFM with a remote table reference updates the table
>>>>> as
>>>>> expected, but also jumps to the referenced table in the remote  
>>>>> file.
>>>>> Is
>>>>> this intended?  If yes, is it possible to avoid it?
>>>>
>>>> Can you please be more specific.  What exactly happens?
>>>
>>> Consider the following two files:
>>>
>>> * 2009
>>> #+TBLNAME: 2009
>>> :PROPERTIES:
>>> :ID:       ea32e5b5-31ba-468e-8e31-3e0d09696bb0
>>> :END:
>>> |-----+-------|
>>> |  mm |    km |
>>> |-----+-------|
>>> | all | 946.8 |
>>> |-----+-------|
>>>
>>> * 2010
>>> #+TBLNAME: 2010
>>> :PROPERTIES:
>>> :ID:       e0df84c4-8abc-458f-a1ee-eb53eb71b4f0
>>> :END:
>>> |-----+-------+-------+-------|
>>> |  mm |    km |  B km |  G km |
>>> |-----+-------+-------+-------|
>>> | all | 249.4 | 429.2 | 678.6 |
>>> |-----+-------+-------+-------|
>>>
>>> * all
>>> :PROPERTIES:
>>> :ID:       44751a7f-73a4-4c07-b3c2-e3edb9042acd
>>> :END:
>>> #+TBLNAME: all
>>> |------+--------|
>>> | yyyy |     km |
>>> |------+--------|
>>> | 2009 |        |
>>> | 2010 |  678.6 |
>>> |------+--------|
>>> |  all | 1625.4 |
>>> |------+--------|
>>> #+TBLFM: @2$2=remote(ea32e5b5-31ba-468e-8e31-3e0d09696bb0,$LR2);%.
>>> 1f::@3$2=remote(2010,$LR4);%.1f::$LR2=vsum(@2$2..@-1);%.1f
>>>
>>> Then, in the 2010 file, eval the formula of the "all" table by
>>> pressing
>>> C-c C-c.
>>> ==>
>>>
>>> It takes the km value from the 2009 file, but also puts the cursor
>>> (point) into the 2009 file in front of the ID:
>>>
>>> * 2009
>>> #+TBLNAME: 2009
>>> :PROPERTIES:
>>> :ID:       -!-ea32e5b5-31ba-468e-8e31-3e0d09696bb0
>>> :END:
>>> |-----+-------|
>>> |  mm |    km |
>>> |-----+-------|
>>> | all | 946.8 |
>>> |-----+-------|
>>>
>>> -=-=-=-=-=-=-=-=-=-=-=-=-=- cut here -=-=-=-=-=-=-=-=-=-=-=-=-=-
>>>
>>> I'd prefer if the point would stay in the 2010 file.
>>>
>>> --
>>> Karl Eichwalder
>>>
>>
>> - Carsten
>>
>>
>>
>>
>
> -- 
> Karl Eichwalder