emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* spreadsheet formulas without a .
@ 2020-08-24  9:03 Uwe Brauer
  2020-08-24  9:26 ` Dov Grobgeld
  0 siblings, 1 reply; 3+ messages in thread
From: Uwe Brauer @ 2020-08-24  9:03 UTC (permalink / raw)
  To: emacs-orgmode


Hi 

Please look at 


| 20 | 0.9 | 18. |
#+TBLFM: $3=$1*$2;f0


I'd prefer to have the result 18, just written 18 and not 18.

I can't the right format in the documentation.

Thanks and regards

Uwe Brauer 



^ permalink raw reply	[flat|nested] 3+ messages in thread

* Re: spreadsheet formulas without a .
  2020-08-24  9:03 spreadsheet formulas without a Uwe Brauer
@ 2020-08-24  9:26 ` Dov Grobgeld
  2020-08-24 11:33   ` Uwe Brauer
  0 siblings, 1 reply; 3+ messages in thread
From: Dov Grobgeld @ 2020-08-24  9:26 UTC (permalink / raw)
  To: emacs-orgmode

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

You can do the following:

#+TBLFM: $3=$1*$2;%.0f

Search for % at https://orgmode.org/manual/Formula-syntax-for-Calc.html .

Regards,

On Mon, Aug 24, 2020 at 12:03 PM Uwe Brauer <oub@mat.ucm.es> wrote:

>
> Hi
>
> Please look at
>
>
> | 20 | 0.9 | 18. |
> #+TBLFM: $3=$1*$2;f0
>
>
> I'd prefer to have the result 18, just written 18 and not 18.
>
> I can't the right format in the documentation.
>
> Thanks and regards
>
> Uwe Brauer
>
>
>

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

^ permalink raw reply	[flat|nested] 3+ messages in thread

* Re: spreadsheet formulas without a .
  2020-08-24  9:26 ` Dov Grobgeld
@ 2020-08-24 11:33   ` Uwe Brauer
  0 siblings, 0 replies; 3+ messages in thread
From: Uwe Brauer @ 2020-08-24 11:33 UTC (permalink / raw)
  To: emacs-orgmode

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

>>> "DG" == Dov Grobgeld <dov.grobgeld@gmail.com> writes:

> You can do the following:
> #+TBLFM: $3=$1*$2;%.0f

> Search for % at https://orgmode.org/manual/Formula-syntax-for-Calc.html .

Thanks, this was the link I was looking for.

Uwe 

[-- Attachment #2: smime.p7s --]
[-- Type: application/pkcs7-signature, Size: 5673 bytes --]

^ permalink raw reply	[flat|nested] 3+ messages in thread

end of thread, other threads:[~2020-08-24 11:34 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2020-08-24  9:03 spreadsheet formulas without a Uwe Brauer
2020-08-24  9:26 ` Dov Grobgeld
2020-08-24 11:33   ` 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).