From mboxrd@z Thu Jan 1 00:00:00 1970 From: Thierry Banel Subject: Re: Bug in vsum in org-mode table? Date: Sat, 23 Apr 2016 00:12:36 +0200 Message-ID: <571AA1D4.2070904@free.fr> References: <571A7CCD.5050403@free.fr> <3e95f54e-9e99-f579-748e-6d593018b39a@verizon.net> Mime-Version: 1.0 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:33338) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1atjJa-0000ps-Hd for emacs-orgmode@gnu.org; Fri, 22 Apr 2016 18:12:43 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1atjJX-00020f-9e for emacs-orgmode@gnu.org; Fri, 22 Apr 2016 18:12:42 -0400 Received: from smtp6-g21.free.fr ([212.27.42.6]:17104) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1atjJX-0001zu-4K for emacs-orgmode@gnu.org; Fri, 22 Apr 2016 18:12:39 -0400 Received: from [IPv6:2a01:e35:2e21:def0:14cd:8e14:62e8:eee6] (unknown [IPv6:2a01:e35:2e21:def0:14cd:8e14:62e8:eee6]) by smtp6-g21.free.fr (Postfix) with ESMTP id 6DADE7802C5 for ; Fri, 22 Apr 2016 20:25:03 +0200 (CEST) In-Reply-To: <3e95f54e-9e99-f579-748e-6d593018b39a@verizon.net> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: emacs-orgmode@gnu.org
Le 22/04/2016 22:10, Charles Millar a =C3=A9crit=C2=A0:

On 04/22/2016 03:34 PM, Thierry Bane= l wrote:
You can format the result as 2.= 0 with the f1 modifier
(or f5 to get 2.00000 and so on)

#+TBLFM: @>$1=3Dvsum(@2..@>>);f1<= /b>

In the manual the decimal format %.2f, etc. is shown as an example but apparently the f2 format is not mentioned.

Is the %.Xf format preferred or is either one OK?

Regards,

Charlie Millar=C2=A0

%.2f is handy for those who are used to printf() syntax (in the C language).
But Calc unlimited precision numbers are converted to double floats before applying %.2f
Whereas f2 operates on Calc numbers without conversion.