From mboxrd@z Thu Jan  1 00:00:00 1970
From: Levin <zslevin@gmail.com>
Subject: Feature Request: Number format on sum of property
Date: Thu, 25 Oct 2007 11:59:14 +0800
Message-ID: <200710251159.14646.zslevin@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1Iktt8-0001Av-St
	for emacs-orgmode@gnu.org; Thu, 25 Oct 2007 00:00:06 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1Iktt7-00018m-2R
	for emacs-orgmode@gnu.org; Thu, 25 Oct 2007 00:00:06 -0400
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1Iktt6-00018j-Tl
	for emacs-orgmode@gnu.org; Thu, 25 Oct 2007 00:00:04 -0400
Received: from rv-out-0910.google.com ([209.85.198.184])
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <zslevin@gmail.com>) id 1Iktt6-0004nK-JS
	for emacs-orgmode@gnu.org; Thu, 25 Oct 2007 00:00:04 -0400
Received: by rv-out-0910.google.com with SMTP id c27so339718rvf
	for <emacs-orgmode@gnu.org>; Wed, 24 Oct 2007 21:00:02 -0700 (PDT)
Content-Disposition: inline
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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

Currently I'm using org-mode to manage my financial tables. The columnview is 
absolutely great on this:

------------8<------------------8<------------
* org-balance
   :PROPERTIES:
:COLUMNS: %30ITEM %20balance(Book Balance){+} %20uncleared(Uncleared)
{+} %20bank(Bank Balance){+}
   :END:

#+BEGIN: columnview :hlines 1 :id local
| ITEM                |       Book Balance | Uncleared |       Bank Balance |
|---------------------+--------------------+-----------+--------------------|
| *  org-balance      | 244.85000000000002 |       0.0 | 244.85000000000002 |
| **  housing         |             -150.0 |       0.0 |             -150.0 |
| ***  Parking        |            -150.00 |      0.00 |            -150.00 |
| **  communication   |             394.85 |       0.0 |             394.85 |
| ***  wang tong      |             160.00 |      0.00 |             160.00 |
| ***  xiao ling tone |             103.00 |      0.00 |             103.00 |
| ***  shen zhou xing |             131.85 |      0.00 |             131.85 |
#+END
------------8<------------------8<------------

However, you might notice that the float number is not correctly formatted.
May I have some magic cookie in COLUMNS format to specify it? Something like
 "%20balance(Book Balance){+}[%.2f]" ?

Thanks.

Levin