Bug in vsum in org-mode table?

Bug in vsum in org-mode table?

[Kaushal Modi]

[-- Attachment #1: Type: text/plain, Size: 389 bytes --]

Hi,

The vsum is putting a sum as "2." instead of "2.0". Here is a simple
example:

|-------|
| Title |
|-------|
| 0.5 |
| 1.5 |
|-------|
| 2. |
|-------|
#+TBLFM: @>$1=vsum(@2..@>>)

Org-mode version 8.3.4 (release_8.3.4-748-g7e320e @
/home/kmodi/usr_local/apps/6/emacs/emacs-25/share/emacs/site-lisp/org/)

Is anyone else able to recreate this?

Thanks.

Kaushal
-- 

-- 
Kaushal Modi

[-- Attachment #2: Type: text/html, Size: 609 bytes --]

Re: Bug in vsum in org-mode table?

[Thierry Banel]

[-- Attachment #1: Type: text/html, Size: 1538 bytes --]

Re: Bug in vsum in org-mode table?

[Charles Millar]

[-- Attachment #1: Type: text/plain, Size: 393 bytes --]


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


[-- Attachment #2: Type: text/html, Size: 998 bytes --]

Re: Bug in vsum in org-mode table?

[Kaushal Modi]

[-- Attachment #1: Type: text/plain, Size: 604 bytes --]

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 <millarc@verizon.net> 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

[-- Attachment #2: Type: text/html, Size: 1385 bytes --]

Re: Bug in vsum in org-mode table?

[Thierry Banel]

[-- Attachment #1: Type: text/html, Size: 1651 bytes --]

Re: Bug in vsum in org-mode table?

[Charles Millar]

[-- Attachment #1: Type: text/plain, Size: 804 bytes --]



On 04/22/2016 06:12 PM, Thierry Banel wrote:
> Le 22/04/2016 22:10, Charles Millar a écrit :
>>
>> 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
>
> *%.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.
Thank you, Thierry.




[-- Attachment #2: Type: text/html, Size: 2082 bytes --]