Re: [O] 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 <address@hidden> 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