From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?utf-8?b?RmzDoXZpbw==?= Subject: Formulas in columnview table Date: Tue, 3 Feb 2009 13:46:08 +0000 (UTC) Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1LULba-0003Fs-LS for emacs-orgmode@gnu.org; Tue, 03 Feb 2009 08:46:22 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LULbY-0003FF-TL for emacs-orgmode@gnu.org; Tue, 03 Feb 2009 08:46:21 -0500 Received: from [199.232.76.173] (port=35578 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LULbX-0003F0-8E for emacs-orgmode@gnu.org; Tue, 03 Feb 2009 08:46:19 -0500 Received: from main.gmane.org ([80.91.229.2]:46178 helo=ciao.gmane.org) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1LULbW-0000Ys-Sc for emacs-orgmode@gnu.org; Tue, 03 Feb 2009 08:46:19 -0500 Received: from list by ciao.gmane.org with local (Exim 4.43) id 1LULbV-000160-02 for emacs-orgmode@gnu.org; Tue, 03 Feb 2009 13:46:17 +0000 Received: from 200-225-219-189.static.ctbctelecom.com.br ([200.225.219.189]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 03 Feb 2009 13:46:16 +0000 Received: from flaviostz by 200-225-219-189.static.ctbctelecom.com.br with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 03 Feb 2009 13:46:16 +0000 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 I am using columnview table now to get some summaries of worked hours and quantity balance as well. This is one example showing a quantity of quoted computers and the real sold quantity: | | ITEM | Quotation | Sold | |---+-------------------------+-----------+------+ | | ** Computers | 10 | 7 | |---+-------------------------+-----------+------+ Is there any way to automatically insert a fórmula in a third column? For example, I could insert a "Difference" column and make Sold - Quotation and get this result: | | ITEM | Quotation | Sold | Difference | |---+-------------------------+-----------+------+------------| | | ** Computers | 10 | 7 | -3 | |---+-------------------------+-----------+------+------------| So I could change the column defintion from: :COLUMNS: %50ITEM %10Quoted(Quotation){+} %10Sold(Sold){+} To: :COLUMNS: %50ITEM %10Quoted(Quotation){+} %10Sold(Sold){+} %10Sold-Quoted(Difference) Maybe I am going too far with tables and columns view and the developers did not intend this kind of feature because of complexity. But I think this would be a great feature. Regards, Flávio