Re: remote reference

From: Carsten Dominik <carsten.dominik@gmail.com>
To: Giovanni Ridolfi <giovanni.ridolfi@yahoo.it>
Cc: "Sébastien Vauban" <wxhgmqzgwmuf@spammotel.com>,
	"org-mode mailing list" <emacs-orgmode@gnu.org>
Subject: Re: remote reference
Date: Fri, 15 Jan 2010 16:55:07 +0100	[thread overview]
Message-ID: <6D5CED20-6E3E-4FFA-BB8E-89AA119E3317@gmail.com> (raw)
In-Reply-To: <83ockvbr0t.fsf@yahoo.it>

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