Re: [Orgmode] questions about table mode and spreadsheets

2010-09-15 Thread Inquisitive Scientist
Thanks for the helpful replies to question 2 but what about question 1? Any thoughts on how I can get org-mode to dynamically add an extra row? Thanks, -Emin On Tue, Sep 7, 2010 at 5:20 AM, Christian Moe m...@christianmoe.com wrote: On 9/7/10 2:56 AM, Juan wrote: A very complex way of not

Re: [Orgmode] questions about table mode and spreadsheets

2010-09-07 Thread Christian Moe
On 9/7/10 2:56 AM, Juan wrote: A very complex way of not adding the extra column: | name | a | b | c | |--++---+---| | foo | 1 | 2 | 3 | | bar | 3 | 2 | 1 | | bar | 4 | 5 | 6 | |--++---+---| | | 7 | | | #+TBLFM: @5$2='(apply '+ (mapcar* (lambda(x y) (if (string=

[Orgmode] questions about table mode and spreadsheets

2010-09-06 Thread Inquisitive Scientist
Dear Experts, I am becoming very fond of the table/spreadsheet in org-mode and trying to use it more extensively. I have tried digging through the docs but am still having trouble with some things: 1. Is there a way to dynamically add a new row to a table using a table formula? For example, a

Re: [Orgmode] questions about table mode and spreadsheets

2010-09-06 Thread Christian Moe
On 9/6/10 3:38 PM, Inquisitive Scientist wrote: 2. How do I compute the sum of a column only if a corresponding row matches some condition? For example, how do I compute the sum of numbers in column a for which the name in column name is bar? For example, I should get 7 for the sum in column

Re: [Orgmode] questions about table mode and spreadsheets

2010-09-06 Thread Juan
A very complex way of not adding the extra column: | name | a | b | c | |--++---+---| | foo | 1 | 2 | 3 | | bar | 3 | 2 | 1 | | bar | 4 | 5 | 6 | |--++---+---| | | 7 | | | #+TBLFM: @5$2='(apply '+ (mapcar* (lambda(x y) (if (string= x bar) y 0)) '(@i$...@ii$1)