From mboxrd@z Thu Jan 1 00:00:00 1970 From: Inquisitive Scientist Subject: questions about table mode and spreadsheets Date: Mon, 6 Sep 2010 09:38:49 -0400 Message-ID: Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============0387297341==" Return-path: Received: from [140.186.70.92] (port=51883 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1OsbuO-0005Tb-Bk for emacs-orgmode@gnu.org; Mon, 06 Sep 2010 09:38:53 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1OsbuM-0004aO-QU for emacs-orgmode@gnu.org; Mon, 06 Sep 2010 09:38:52 -0400 Received: from mail-gx0-f169.google.com ([209.85.161.169]:34792) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1OsbuM-0004aI-Mp for emacs-orgmode@gnu.org; Mon, 06 Sep 2010 09:38:50 -0400 Received: by gxk9 with SMTP id 9so2171114gxk.0 for ; Mon, 06 Sep 2010 06:38:49 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org --===============0387297341== Content-Type: multipart/alternative; boundary=0016e6d278e4868c12048f9766f9 --0016e6d278e4868c12048f9766f9 Content-Type: text/plain; charset=ISO-8859-1 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 variety of org-mode things will produce a table as output and allow me to specify some formulas. I'd like to add a formula that says something like "create a row at the bottom that sums column 3" and have that be a new row that gets added. Any thoughts? 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 in the table below: | name | a | b | c | |------+---+---+---| | foo | 1 | 2 | 3 | | bar | 3 | 2 | 1 | | bar | 4 | 5 | 6 | |------+---+---+---| Thanks, -I.S. --0016e6d278e4868c12048f9766f9 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Dear Experts,

I am becoming very fond of the table/spreadsheet in or= g-mode and trying to use it more extensively. I have tried digging through = the docs but am still having trouble with some things:

=A0 1. Is the= re a way to dynamically add a new row to a table using a table formula? For= example, a variety of org-mode things will produce a table as output and a= llow me to specify some formulas. I'd like to add a formula that says s= omething like "create a row at the bottom that sums column 3" and= have that be a new row that gets added. Any thoughts?

=A0 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 i= n column a for which the name in column "name" is "bar"= ? For example, I should get 7 for the sum in column a in the table below:
| name | a | b | c |
|------+---+---+---|
| foo=A0 | 1 | 2 | 3 |<= br>| bar=A0 | 3 | 2 | 1 |
| bar=A0 | 4 | 5 | 6 |
|------+---+---+---|=

Thanks,
-I.S.
--0016e6d278e4868c12048f9766f9-- --===============0387297341== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode --===============0387297341==--