From mboxrd@z Thu Jan 1 00:00:00 1970 From: Kaushal Modi Subject: Re: Bug in vsum in org-mode table? Date: Fri, 22 Apr 2016 20:46:01 +0000 Message-ID: References: <571A7CCD.5050403@free.fr> <3e95f54e-9e99-f579-748e-6d593018b39a@verizon.net> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=94eb2c0934b6b74745053118ead3 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:50389) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1athxs-0004bh-1R for emacs-orgmode@gnu.org; Fri, 22 Apr 2016 16:46:12 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1athxr-000749-4f for emacs-orgmode@gnu.org; Fri, 22 Apr 2016 16:46:11 -0400 Received: from mail-oi0-x22b.google.com ([2607:f8b0:4003:c06::22b]:34734) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1athxq-000745-VY for emacs-orgmode@gnu.org; Fri, 22 Apr 2016 16:46:11 -0400 Received: by mail-oi0-x22b.google.com with SMTP id k142so128075870oib.1 for ; Fri, 22 Apr 2016 13:46:10 -0700 (PDT) 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: Charles Millar , emacs-orgmode@gnu.org --94eb2c0934b6b74745053118ead3 Content-Type: text/plain; charset=UTF-8 Thank you guys. Both of the below worked. #+TBLFM: @>$1=vsum(@2..@>>);f1 #+TBLFM: @>$1=vsum(@2..@>>);%0.1f On Fri, Apr 22, 2016 at 4:11 PM Charles Millar wrote: > > 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=vsum(@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 > -- -- Kaushal Modi --94eb2c0934b6b74745053118ead3 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thank you guys. Both of the below worked.=

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

#+TBLFM: @>$1=3Dvsum(@2..@>>);%0.1f

On Fri, Apr 22, 2016 at 4:= 11 PM Charles Millar <millarc@verizon.net> wrote:

On 04/22/2016 03:34 PM, Thierry Banel wrote:
=20
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<= br>
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
--

--
Kaushal Modi

--94eb2c0934b6b74745053118ead3--