From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: FR: Columnview Tables & Formulas Date: Sun, 7 Sep 2008 08:43:52 +0200 Message-ID: References: <20080906215755.GC14306@thinkpad.adamsinfoserv.com> Mime-Version: 1.0 (Apple Message framework v926) Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1KcE07-0006wE-Vi for emacs-orgmode@gnu.org; Sun, 07 Sep 2008 02:44:00 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1KcE07-0006w0-0G for emacs-orgmode@gnu.org; Sun, 07 Sep 2008 02:43:59 -0400 Received: from [199.232.76.173] (port=38650 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1KcE06-0006vx-RM for emacs-orgmode@gnu.org; Sun, 07 Sep 2008 02:43:58 -0400 Received: from mx20.gnu.org ([199.232.41.8]:65456) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1KcE06-0000nQ-HO for emacs-orgmode@gnu.org; Sun, 07 Sep 2008 02:43:58 -0400 Received: from ey-out-1920.google.com ([74.125.78.146]) by mx20.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1KcE04-0000bv-WA for emacs-orgmode@gnu.org; Sun, 07 Sep 2008 02:43:57 -0400 Received: by ey-out-1920.google.com with SMTP id 4so484568eyg.24 for ; Sat, 06 Sep 2008 23:43:56 -0700 (PDT) In-Reply-To: <20080906215755.GC14306@thinkpad.adamsinfoserv.com> 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: Russell Adams Cc: Org Mode List Hi Russel, hmmm, an alternative would be to introduce a new property and do the computation in the properties. I can see that it would be relatively simple to define a TBLFM line that should be added to the table capturing the the column view, but if you need to add extra columns to the table, this makes things a lot harder. - Carsten On Sep 6, 2008, at 11:57 PM, Russell Adams wrote: > 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 > > > _______________________________________________ > Emacs-orgmode mailing list > Remember: use `Reply All' to send replies to the list. > Emacs-orgmode@gnu.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode