* org-table: decimal numbers with a dot at the end: for example 10.
@ 2015-06-24 8:22 Uwe Brauer
2015-06-24 9:34 ` Robert Klein
0 siblings, 1 reply; 5+ messages in thread
From: Uwe Brauer @ 2015-06-24 8:22 UTC (permalink / raw)
To: emacs-orgmode
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
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: org-table: decimal numbers with a dot at the end: for example 10.
2015-06-24 8:22 org-table: decimal numbers with a dot at the end: for example 10 Uwe Brauer
@ 2015-06-24 9:34 ` Robert Klein
2015-06-24 10:06 ` Uwe Brauer
0 siblings, 1 reply; 5+ messages in thread
From: Robert Klein @ 2015-06-24 9:34 UTC (permalink / raw)
To: Uwe Brauer; +Cc: emacs-orgmode
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
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: org-table: decimal numbers with a dot at the end: for example 10.
2015-06-24 9:34 ` Robert Klein
@ 2015-06-24 10:06 ` Uwe Brauer
2015-06-24 10:08 ` Robert Klein
0 siblings, 1 reply; 5+ messages in thread
From: Uwe Brauer @ 2015-06-24 10:06 UTC (permalink / raw)
To: emacs-orgmode
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
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: org-table: decimal numbers with a dot at the end: for example 10.
2015-06-24 10:06 ` Uwe Brauer
@ 2015-06-24 10:08 ` Robert Klein
2015-06-24 10:11 ` Uwe Brauer
0 siblings, 1 reply; 5+ messages in thread
From: Robert Klein @ 2015-06-24 10:08 UTC (permalink / raw)
To: Uwe Brauer; +Cc: emacs-orgmode
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
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: org-table: decimal numbers with a dot at the end: for example 10.
2015-06-24 10:08 ` Robert Klein
@ 2015-06-24 10:11 ` Uwe Brauer
0 siblings, 0 replies; 5+ messages in thread
From: Uwe Brauer @ 2015-06-24 10:11 UTC (permalink / raw)
To: emacs-orgmode
>> "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.
^ permalink raw reply [flat|nested] 5+ messages in thread
end of thread, other threads:[~2015-06-24 10:11 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2015-06-24 8:22 org-table: decimal numbers with a dot at the end: for example 10 Uwe Brauer
2015-06-24 9:34 ` Robert Klein
2015-06-24 10:06 ` Uwe Brauer
2015-06-24 10:08 ` Robert Klein
2015-06-24 10:11 ` Uwe Brauer
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).