* 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).