* remote reference
@ 2010-01-15 8:49 Karl Eichwalder
2010-01-15 9:21 ` Sébastien Vauban
2010-01-15 9:38 ` Carsten Dominik
0 siblings, 2 replies; 14+ messages in thread
From: Karl Eichwalder @ 2010-01-15 8:49 UTC (permalink / raw)
To: emacs-orgmode
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
^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: remote reference
2010-01-15 8:49 remote reference Karl Eichwalder
@ 2010-01-15 9:21 ` Sébastien Vauban
2010-01-15 9:59 ` Sébastien Vauban
2010-01-15 9:38 ` Carsten Dominik
1 sibling, 1 reply; 14+ messages in thread
From: Sébastien Vauban @ 2010-01-15 9:21 UTC (permalink / raw)
To: emacs-orgmode-mXXj517/zsQ
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
^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: remote reference
2010-01-15 8:49 remote reference Karl Eichwalder
2010-01-15 9:21 ` Sébastien Vauban
@ 2010-01-15 9:38 ` Carsten Dominik
2010-01-15 10:29 ` Giovanni Ridolfi
2010-05-11 19:16 ` Karl Eichwalder
1 sibling, 2 replies; 14+ messages in thread
From: Carsten Dominik @ 2010-01-15 9:38 UTC (permalink / raw)
To: Karl Eichwalder; +Cc: emacs-orgmode
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
^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: remote reference
2010-01-15 9:21 ` Sébastien Vauban
@ 2010-01-15 9:59 ` Sébastien Vauban
0 siblings, 0 replies; 14+ messages in thread
From: Sébastien Vauban @ 2010-01-15 9:59 UTC (permalink / raw)
To: emacs-orgmode-mXXj517/zsQ
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
^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: remote reference
2010-01-15 9:38 ` Carsten Dominik
@ 2010-01-15 10:29 ` Giovanni Ridolfi
2010-01-15 15:55 ` Carsten Dominik
2010-05-11 19:16 ` Karl Eichwalder
1 sibling, 1 reply; 14+ messages in thread
From: Giovanni Ridolfi @ 2010-01-15 10:29 UTC (permalink / raw)
To: Carsten Dominik; +Cc: Sébastien Vauban, emacs-orgmode
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
^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: remote reference
2010-01-15 10:29 ` Giovanni Ridolfi
@ 2010-01-15 15:55 ` Carsten Dominik
2010-01-18 8:53 ` Giovanni Ridolfi
0 siblings, 1 reply; 14+ messages in thread
From: Carsten Dominik @ 2010-01-15 15:55 UTC (permalink / raw)
To: Giovanni Ridolfi; +Cc: Sébastien Vauban, org-mode mailing list
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
^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: remote reference
2010-01-15 15:55 ` Carsten Dominik
@ 2010-01-18 8:53 ` Giovanni Ridolfi
2010-01-28 17:34 ` Carsten Dominik
0 siblings, 1 reply; 14+ messages in thread
From: Giovanni Ridolfi @ 2010-01-18 8:53 UTC (permalink / raw)
To: Carsten Dominik; +Cc: Sébastien Vauban, mailing list
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
^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: remote reference
2010-01-18 8:53 ` Giovanni Ridolfi
@ 2010-01-28 17:34 ` Carsten Dominik
0 siblings, 0 replies; 14+ messages in thread
From: Carsten Dominik @ 2010-01-28 17:34 UTC (permalink / raw)
To: Giovanni Ridolfi; +Cc: Sébastien Vauban, org-mode mailing list
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
^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: remote reference
2010-01-15 9:38 ` Carsten Dominik
2010-01-15 10:29 ` Giovanni Ridolfi
@ 2010-05-11 19:16 ` Karl Eichwalder
2010-05-12 6:16 ` Carsten Dominik
1 sibling, 1 reply; 14+ messages in thread
From: Karl Eichwalder @ 2010-05-11 19:16 UTC (permalink / raw)
To: Carsten Dominik; +Cc: emacs-orgmode
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
^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: remote reference
2010-05-11 19:16 ` Karl Eichwalder
@ 2010-05-12 6:16 ` Carsten Dominik
2010-05-12 11:26 ` Karl Eichwalder
0 siblings, 1 reply; 14+ messages in thread
From: Carsten Dominik @ 2010-05-12 6:16 UTC (permalink / raw)
To: Karl Eichwalder; +Cc: emacs-orgmode
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
^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: remote reference
2010-05-12 6:16 ` Carsten Dominik
@ 2010-05-12 11:26 ` Karl Eichwalder
2010-05-12 13:06 ` Carsten Dominik
0 siblings, 1 reply; 14+ messages in thread
From: Karl Eichwalder @ 2010-05-12 11:26 UTC (permalink / raw)
To: Carsten Dominik; +Cc: emacs-orgmode
[-- 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
^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: remote reference
2010-05-12 11:26 ` Karl Eichwalder
@ 2010-05-12 13:06 ` Carsten Dominik
2010-12-11 14:42 ` Karl Eichwalder
0 siblings, 1 reply; 14+ messages in thread
From: Carsten Dominik @ 2010-05-12 13:06 UTC (permalink / raw)
To: Karl Eichwalder; +Cc: emacs-orgmode
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
^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: remote reference
2010-05-12 13:06 ` Carsten Dominik
@ 2010-12-11 14:42 ` Karl Eichwalder
2010-12-11 14:46 ` Carsten Dominik
0 siblings, 1 reply; 14+ messages in thread
From: Karl Eichwalder @ 2010-12-11 14:42 UTC (permalink / raw)
To: Carsten Dominik; +Cc: emacs-orgmode
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
^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: remote reference
2010-12-11 14:42 ` Karl Eichwalder
@ 2010-12-11 14:46 ` Carsten Dominik
0 siblings, 0 replies; 14+ messages in thread
From: Carsten Dominik @ 2010-12-11 14:46 UTC (permalink / raw)
To: Karl Eichwalder; +Cc: emacs-orgmode
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
^ permalink raw reply [flat|nested] 14+ messages in thread
end of thread, other threads:[~2010-12-11 14:46 UTC | newest]
Thread overview: 14+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2010-01-15 8:49 remote reference Karl Eichwalder
2010-01-15 9:21 ` Sébastien Vauban
2010-01-15 9:59 ` Sébastien Vauban
2010-01-15 9:38 ` Carsten Dominik
2010-01-15 10:29 ` Giovanni Ridolfi
2010-01-15 15:55 ` Carsten Dominik
2010-01-18 8:53 ` Giovanni Ridolfi
2010-01-28 17:34 ` Carsten Dominik
2010-05-11 19:16 ` Karl Eichwalder
2010-05-12 6:16 ` Carsten Dominik
2010-05-12 11:26 ` Karl Eichwalder
2010-05-12 13:06 ` Carsten Dominik
2010-12-11 14:42 ` Karl Eichwalder
2010-12-11 14:46 ` Carsten Dominik
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).