[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] Using last row in remote table references
From: |
Phil (Philip) Mason |
Subject: |
[O] Using last row in remote table references |
Date: |
Tue, 10 Jan 2012 13:39:48 +0000 |
Hello all,
Should I be able to use @> in references to remote tables?
For example in the tables below I would expect the results table to show "cde"
as the result of both formulas.
#+TBLNAME: TEST1
|---+---|
| a | f |
| b | g |
| c | h |
| d | i |
| e | j |
|---+---|
#+TBLNAME: RESULTS
|--------------|
| Formula test |
|--------------|
| cde |
| abc |
|--------------|
#+TBLFM: @2$1='(concat remote(TEST1, @address@hidden))::@3$1='(concat
remote(TEST1, @3$1..@>$1))
Is there a syntax I should be using if I want to get all the entries in a table
below a certain row without explicitly entering the number of the last row?
Thanks in advance
Phil Mason
- [O] Using last row in remote table references,
Phil (Philip) Mason <=