From mboxrd@z Thu Jan  1 00:00:00 1970
From: "Phil (Philip) Mason" <phil.mason@broadcom.com>
Subject: Using last row in remote table references
Date: Tue, 10 Jan 2012 13:39:48 +0000
Message-ID: <2D76BBD878DB8B49BBE309F15526B38E8042@SJEXCHMB06.corp.ad.broadcom.com>
Mime-Version: 1.0
Content-Type: text/plain;
 charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:54300)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <phil.mason@broadcom.com>) id 1RkcPi-0007vm-37
	for emacs-orgmode@gnu.org; Tue, 10 Jan 2012 09:11:03 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <phil.mason@broadcom.com>) id 1RkcPe-0003M4-0l
	for emacs-orgmode@gnu.org; Tue, 10 Jan 2012 09:10:58 -0500
Received: from mms3.broadcom.com ([216.31.210.19]:2754)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <phil.mason@broadcom.com>) id 1RkcPd-0003LS-PB
	for emacs-orgmode@gnu.org; Tue, 10 Jan 2012 09:10:53 -0500
Content-Language: en-US
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: "emacs-orgmode@gnu.org" <emacs-orgmode@gnu.org>

Hello all,

Should I be able to use @> in references to remote tables?=20

For example in the tables below I would expect the results table to show "c=
de" as the result of both formulas.=20

#+TBLNAME: TEST1
|---+---|
| a | f |
| b | g |
| c | h |
| d | i |
| e | j |
|---+---|
=20
#+TBLNAME: RESULTS
|--------------|
| Formula test |
|--------------|
| cde          |
| abc          |
|--------------|
#+TBLFM: @2$1=3D'(concat remote(TEST1, @3$1..@5$1))::@3$1=3D'(concat remote=
(TEST1, @3$1..@>$1))

Is there a syntax I should be using if I want to get all the entries in a t=
able below a certain row without explicitly entering the number of the last=
 row?

Thanks in advance

Phil Mason