From mboxrd@z Thu Jan 1 00:00:00 1970 From: Charles Millar Subject: Re: Bug in vsum in org-mode table? Date: Sun, 24 Apr 2016 12:41:36 -0400 Message-ID: <16c7e3e5-1898-c20a-ed59-d1a5d9ee5efc@verizon.net> References: <571A7CCD.5050403@free.fr> <3e95f54e-9e99-f579-748e-6d593018b39a@verizon.net> <571AA1D4.2070904@free.fr> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="Boundary_(ID_7qhqTV+m5bpfLHYE6MLyCg)" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:37048) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1auN6r-0003iW-BK for emacs-orgmode@gnu.org; Sun, 24 Apr 2016 12:42:14 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1auN6o-0008BL-2K for emacs-orgmode@gnu.org; Sun, 24 Apr 2016 12:42:13 -0400 Received: from vms173015pub.verizon.net ([206.46.173.15]:49904) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1auN6n-00089A-Ta for emacs-orgmode@gnu.org; Sun, 24 Apr 2016 12:42:09 -0400 Received: from vz-proxy-m005.mx.aol.com ([64.236.83.15]) by vms173015.mailsrvcs.net (Oracle Communications Messaging Server 7.0.5.32.0 64bit (built Jul 16 2014)) with ESMTPA id <0O6500ITOD1E7D30@vms173015.mailsrvcs.net> for emacs-orgmode@gnu.org; Sun, 24 Apr 2016 11:41:38 -0500 (CDT) In-reply-to: <571AA1D4.2070904@free.fr> 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 This is a multi-part message in MIME format. --Boundary_(ID_7qhqTV+m5bpfLHYE6MLyCg) Content-type: text/plain; charset=utf-8; format=flowed Content-transfer-encoding: QUOTED-PRINTABLE On 04/22/2016 06:12 PM, Thierry Banel wrote: > Le 22/04/2016 22:10, Charles Millar a =C3=A9crit : >> >> On 04/22/2016 03:34 PM, Thierry Banel 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* >>> >> In the manual the decimal format %.2f, etc. is shown as an example= =20 >> but apparently the f2 format is not mentioned. >> >> Is the %.Xf format preferred or is either one OK? >> >> Regards, >> >> Charlie Millar > > *%.2f* is handy for those who are used to *printf()* syntax (in the= C=20 > language). > But Calc unlimited precision numbers are converted to double floats= =20 > before applying *%.2f* > Whereas *f2* operates on Calc numbers without conversion. Thank you, Thierry. --Boundary_(ID_7qhqTV+m5bpfLHYE6MLyCg) Content-type: text/html; charset=utf-8 Content-transfer-encoding: QUOTED-PRINTABLE

On 04/22/2016 06:12 PM, Thierry Ba= nel wrote:

Le 22/04/2016 22:10, Charles Mil= lar a =C3=A9crit=C2=A0:

On 04/22/2016 03:34 PM, Thierr= y Banel 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=

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.<= br>

Thank you, Thierry.

--Boundary_(ID_7qhqTV+m5bpfLHYE6MLyCg)--