Re: [Orgmode] Re: org-table and formulas

2010-01-13 Thread Alan Boudreault
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

Re: [Orgmode] Re: org-table and formulas

2010-01-13 Thread Carsten Dominik
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

Re: [Orgmode] Re: org-table and formulas

2010-01-13 Thread Stephan Schmitt
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

Re: [Orgmode] Re: org-table and formulas

2010-01-13 Thread Alan Boudreault
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 | |--

[Orgmode] Re: org-table and formulas

2010-01-13 Thread Sébastien Vauban
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