From: Karl Eichwalder <ke@gnu.franken.de>
To: Carsten Dominik <carsten.dominik@gmail.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: remote reference
Date: Wed, 12 May 2010 13:26:22 +0200 [thread overview]
Message-ID: <shbpcltl7l.fsf@frechet.suse.de> (raw)
In-Reply-To: <D82E7749-E5BE-4243-968A-45F33A28201C@gmail.com> (Carsten Dominik's message of "Wed, 12 May 2010 08:16:23 +0200")
[-- 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
next prev parent reply other threads:[~2010-05-12 11:26 UTC|newest]
Thread overview: 14+ messages / expand[flat|nested] mbox.gz Atom feed top
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 [this message]
2010-05-12 13:06 ` Carsten Dominik
2010-12-11 14:42 ` Karl Eichwalder
2010-12-11 14:46 ` Carsten Dominik
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
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=shbpcltl7l.fsf@frechet.suse.de \
--to=ke@gnu.franken.de \
--cc=carsten.dominik@gmail.com \
--cc=emacs-orgmode@gnu.org \
/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 external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.