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$...@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$...@5$2=remote(Taba,$4) *** ranges: #+TBLNAME: Tabr | | | | | | | | | | | | | | | |---+---| | ^ | b | #+TBLFM: @1$...@5$2=remote(Taba,@1$...@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 _______________________________________________ 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