From mboxrd@z Thu Jan 1 00:00:00 1970 From: Russell Adams Subject: FR: Columnview Tables & Formulas Date: Sat, 6 Sep 2008 16:57:55 -0500 Message-ID: <20080906215755.GC14306@thinkpad.adamsinfoserv.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1Kc5n6-00007Y-Vs for emacs-orgmode@gnu.org; Sat, 06 Sep 2008 17:58:00 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1Kc5n5-0008W3-I1 for emacs-orgmode@gnu.org; Sat, 06 Sep 2008 17:58:00 -0400 Received: from [199.232.76.173] (port=55245 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Kc5n5-0008Vl-AM for emacs-orgmode@gnu.org; Sat, 06 Sep 2008 17:57:59 -0400 Received: from squirtle.drak.net ([72.52.144.201]:55152) by monty-python.gnu.org with esmtps (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1Kc5n5-0006Li-40 for emacs-orgmode@gnu.org; Sat, 06 Sep 2008 17:57:59 -0400 Received: from [206.180.154.177] (helo=localhost) by squirtle.drak.net with esmtpsa (TLSv1:AES128-SHA:128) (Exim 4.69) (envelope-from ) id 1Kc5mu-0005ms-O3 for emacs-orgmode@gnu.org; Sat, 06 Sep 2008 16:57:48 -0500 Content-Disposition: inline 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: Org Mode List I've taken to using the column view tables to aggregate table from an outline. I'd like to be able to use standard spreadsheet features in the same table, specifically column formulas. Right now it works, I can add an extra column and enter a column formula. However when the table is refreshed in column mode, I lose the spreadsheet data. I see two fixes, either the TBLFM line is preserved, or could the column formula be specified in the COLUMNS line? Imagine a small table with two properties, VALUE and QUANTITY, where TOTAL VALUE should be calculated via simple multiplication. Thanks. ------------------------------------------------------------------ Russell Adams RLAdams@AdamsInfoServ.com PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/ Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3