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
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=
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
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
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)