From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Jay Belanger Newsgroups: gmane.emacs.help Subject: Re: Display of numbers (money) in spreadsheet of org-mode Date: Mon, 11 Jun 2007 12:07:53 -0500 Message-ID: <878xaqpggm.fsf@gmail.com> References: <46668b9f$0$323$e4fe514c@news.xs4all.nl> <1181307357.097101.109270@e65g2000hsc.googlegroups.com> Reply-To: jay.p.belanger@gmail.com NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: sea.gmane.org 1181583644 13344 80.91.229.12 (11 Jun 2007 17:40:44 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Mon, 11 Jun 2007 17:40:44 +0000 (UTC) To: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Mon Jun 11 19:40:43 2007 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.50) id 1Hxnsg-00041n-Iv for geh-help-gnu-emacs@m.gmane.org; Mon, 11 Jun 2007 19:40:42 +0200 Original-Received: from localhost ([127.0.0.1] helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Hxnsg-0007wm-24 for geh-help-gnu-emacs@m.gmane.org; Mon, 11 Jun 2007 13:40:42 -0400 Original-Path: shelby.stanford.edu!newsfeed.stanford.edu!newsfeed.berkeley.edu!ucberkeley!feed.news.qwest.net!mpls-nntp-02.inet.qwest.net!newshub.more.net!news.more.net!53ab2750!not-for-mail Original-Newsgroups: gnu.emacs.help User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1.50 (gnu/linux) Cancel-Lock: sha1:k2drrkwM+se+V+9oXk9Ns+a9uyI= Original-Lines: 32 Original-NNTP-Posting-Host: 150.243.64.20 Original-X-Trace: news.more.net 1181581673 150.243.64.20 (Mon, 11 Jun 2007 12:07:53 CDT) Original-NNTP-Posting-Date: Mon, 11 Jun 2007 12:07:53 CDT Original-Xref: shelby.stanford.edu gnu.emacs.help:149304 X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:44892 Archived-At: carsten.dominik@gmail.com writes: > On Jun 6, 12:25 pm, Cecil Westerhof wrote: >> I discovered the spreadsheet inorg-modetoday. I like it. But I would like >> some nicer display. I have a field that is the sum of other fields. At the >> moment it is displayed like >> 15391.72 >> but I would like it to be displayed like >> 15.391,72 >> is this possible? >> >> And if this is possible: is it possible to use this format for the input >> fields? > > I don't think so, because calc does not support this. Org-mode is > using > calc for the computations, and calc is also doing the parsing and > formatting of numbers. Calc can format the numbers as above. In Calc, `d g' (calc-group-digits) will turn grouping on and off (with an optional argument to set how many digits in a group), `d ,' (calc-group-char) will set the grouping character, and `d .' (calc-point-char) will set the decimal point character. So, in Calc, `d g', `d , .', `d , .' will give the desired display. (I don't know how this would be done through org-mode, unless the settings are made in the Calc init file.) However, this doesn't change the way that numbers can be entered, they have to be entered using periods as decimal points. Jay