Thanks for your help Carsten, Stephan and Sébastien. I'm going to take a look
at your suggestions and see what I can do.
Alan
On January 13, 2010 06:59:54 am Carsten Dominik wrote:
> Hi Alan,
>
> I think what you would have to do is to build a lisp function that
> creates the full reference by
Hi Alan,
I think what you would have to do is to build a lisp function that
creates the full reference by string manipulation, and then calls org-
table-get-remote-range directly to retrieve the result.
That function returns a string or a list of strings, so conversion
might be needed depe
Hi Alan,
seems what you're looking for is some relational database functionality, which
is not possible with org spreadsheets :-(
Find a possible solution for your problem in the attached org file. You will
need org-babel to execute the source blocks.
hth,
Stephan
Also sprach Alan Boud
Hi Sébastien and thank you for your answer.
The problem with that technique is that I'll have to name ALL the cell
for ALL the colomn. Here's an example of my table:
#+TBLNAME: FOOD
| Name| Brand | Amounts (g) | Calories | Protein |
Carbohydrate | Fat |
|--
Hi Alan,
Alan Boudreault wrote:
>
> Here's what I'm trying to do (without success) in my spreadsheet:
>
> I have a first table :
>
> #+TBLNAME: table1
> | ... |... | |...|...
>
> and a second table:
>
> #+TBLNAME: table2
> | line_reference | ... |... | |...|...
>
> The line_reference is th