org-table: decimal numbers with a dot at the end: for example 10.

org-table: decimal numbers with a dot at the end: for example 10.

[Uwe Brauer]

Hello 

Take the following example 

| Apellido | Nombre |  E1 |  E2 | E3 |  E4 |  E5 |  E6 | E7 | E8 |  E9 | E10 | E11 | Res |
|----------+--------+-----+-----+----+-----+-----+-----+----+----+-----+-----+-----+-----|
| Brauer   |        | 1.5 | 0.5 |  1 | 0.5 | 0.5 | 0.5 |  1 |  1 | 0.5 |   1 |   2 | 10. |
#+TBLFM: $14=$3+$4+$5+$6+$7+$8+$9+$10+$11+$12+$13


The result is 10.

Instead of 10

How can I get rid of the «.» at the end of the number?

thanks

Uwe Brauer 

Re: org-table: decimal numbers with a dot at the end: for example 10.

[Robert Klein]

Hello,

On Wed, 24 Jun 2015 10:22:43 +0200
Uwe Brauer <oub@mat.ucm.es> wrote:

> 
> Hello 
> 
> Take the following example 
> 
> | Apellido | Nombre |  E1 |  E2 | E3 |  E4 |  E5 |  E6 | E7 | E8 |
> E9 | E10 | E11 | Res |
> |----------+--------+-----+-----+----+-----+-----+-----+----+----+-----+-----+-----+-----|
> | Brauer   |        | 1.5 | 0.5 |  1 | 0.5 | 0.5 | 0.5 |  1 |  1 |
> 0.5 |   1 |   2 | 10. | #+TBLFM:
> $14=$3+$4+$5+$6+$7+$8+$9+$10+$11+$12+$13
> 
> 
> The result is 10.
> 
> Instead of 10
> 
> How can I get rid of the «.» at the end of the number?

you can put a format in the tblfm line, e.g.:

#+TBLFM: $14=$3+$4+$5+$6+$7+$8+$9+$10+$11+$12+$13;%.0f

However, this cuts any numbers at the dot, that is a 10.5 would be
displayed as 10.

If you can live with a 10.0  use %.1f instead of %.0f after the
semicolon.

Best regards
Robert

Re: org-table: decimal numbers with a dot at the end: for example 10.

[Uwe Brauer]

Hi
   > Hello,
   > On Wed, 24 Jun 2015 10:22:43 +0200
   > Uwe Brauer <oub@mat.ucm.es> wrote:


   > you can put a format in the tblfm line, e.g.:

   > #+TBLFM: $14=$3+$4+$5+$6+$7+$8+$9+$10+$11+$12+$13;%.0f

   > However, this cuts any numbers at the dot, that is a 10.5 would be
   > displayed as 10.

   > If you can live with a 10.0  use %.1f instead of %.0f after the
   > semicolon.

I think I can live with 10.00 and then later make a query-replace of .00

Thanks!

Uwe 

Re: org-table: decimal numbers with a dot at the end: for example 10.

[Robert Klein]

Hello,

On Wed, 24 Jun 2015 12:06:14 +0200
Uwe Brauer <oub@mat.ucm.es> wrote:

> 
> Hi
>    > Hello,
>    > On Wed, 24 Jun 2015 10:22:43 +0200
>    > Uwe Brauer <oub@mat.ucm.es> wrote:
> 
> 
>    > you can put a format in the tblfm line, e.g.:
> 
>    > #+TBLFM: $14=$3+$4+$5+$6+$7+$8+$9+$10+$11+$12+$13;%.0f
> 
>    > However, this cuts any numbers at the dot, that is a 10.5 would
>    > be displayed as 10.

*cough* this should be:

   would be displayed as "10" .  (This dot is the sentence ending dot :)

> 
>    > If you can live with a 10.0  use %.1f instead of %.0f after the
>    > semicolon.
> 
> I think I can live with 10.00 and then later make a query-replace
> of .00
> 

Best regards
Robert

Re: org-table: decimal numbers with a dot at the end: for example 10.

[Uwe Brauer]

>> "Robert" == Robert Klein <roklein@roklein.de> writes:

   > Hello,
   > On Wed, 24 Jun 2015 12:06:14 +0200
   > Uwe Brauer <oub@mat.ucm.es> wrote:

   >> 
   >> Hi
   >> > Hello,
   >> > On Wed, 24 Jun 2015 10:22:43 +0200
   >> > Uwe Brauer <oub@mat.ucm.es> wrote:
   >> 
   >> 
   >> > you can put a format in the tblfm line, e.g.:
   >> 
   >> > #+TBLFM: $14=$3+$4+$5+$6+$7+$8+$9+$10+$11+$12+$13;%.0f
   >> 
   >> > However, this cuts any numbers at the dot, that is a 10.5 would
   >> > be displayed as 10.

   > *cough* this should be:

   >    would be displayed as "10" .  (This dot is the sentence ending dot :)

Yes I understand that much.
However if I chose this setting 6.25 gets displayed as 6 which is not
acceptable.