From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id OOgyFvyHQ19SAwAA0tVLHw (envelope-from ) for ; Mon, 24 Aug 2020 09:27:24 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id gKr/EfyHQ1/BVQAA1q6Kng (envelope-from ) for ; Mon, 24 Aug 2020 09:27:24 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id DA7D394036A for ; Mon, 24 Aug 2020 09:27:23 +0000 (UTC) Received: from localhost ([::1]:43206 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kA8l8-0006DP-R2 for larch@yhetil.org; Mon, 24 Aug 2020 05:27:22 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:41882) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kA8kl-0006DD-5f for emacs-orgmode@gnu.org; Mon, 24 Aug 2020 05:26:59 -0400 Received: from mail-vk1-xa2d.google.com ([2607:f8b0:4864:20::a2d]:36752) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1kA8kh-0002Dh-Af for emacs-orgmode@gnu.org; Mon, 24 Aug 2020 05:26:57 -0400 Received: by mail-vk1-xa2d.google.com with SMTP id s81so1828016vkb.3 for ; Mon, 24 Aug 2020 02:26:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=GCXaEqMXSeFk/tELY6gg1VxWluI7EGS5QU0+hAGNmss=; b=esfGoGo/EgJ+M2KQTFoXJMDiCgMu8RqIfVA7VuTyuuw9UEz6dcC72x6Rcm3QKKRm6g GvALjUvVEifeTAi9B+kFMnygp0iAra4ZNFlbBtLqHX2sldTm6HsXUserHuxFyFuz8vGK yOy1gJnP87UedoudnQ1Os0VdFs7X50uqOYXUqm16ChwTWpvJ2L2VCZSki9De3VCySFZq rkDlCzn0c/n2pN/RApdoSoGkYE9RSTKg4DKsGE5KxkDGpV6PyBV8TFTo2Fc767wl5g7P 04QeHOTHRYhIa+Qf/EFE3I/vHneaXQ/4QsdIQDDWWLVekPIedZbMpr04GJgvzvuLBr6l lDRA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=GCXaEqMXSeFk/tELY6gg1VxWluI7EGS5QU0+hAGNmss=; b=YjXuaqWAf1rrRC3zkC/DKl1o6j5Jg+Oo6ILGGd1ruOsstBTDRs284GmZH12VB5znP4 YuepXpUVLBz8lvjktA84Zb4GqDYbXDsb92IuMBoi5dG7iBXF1XmvT/7FyKOjPPemd+HL h/xOgck1fpqv90uxnt0AdaiaHZCD19DFLxA5P1HxdtSiDnwMYMDfM3gtTFP+Yb3TR0JO 0F/CArAcffvHCYKm656fd/RJIEkF54yadG9Tm6CqUS4Wd42Stict9kRJzFjGkVQCzqLg oXEd76iyS/kPIvTH74xxypyr+GNxocNpcR0ctskqko3YiYj2ELKHHFoyBO28yux8Vo6C v8Og== X-Gm-Message-State: AOAM531hIKCfm2VFqygO1Hl/+h+M2Dtm+TcLHujhTiPNgdrv5fz8l6Ay vrpDq5rO5CoAtowL5puDOqW9FqP265mh7z9FDEWgZ3xZb5/ccw== X-Google-Smtp-Source: ABdhPJwpHFkwofRqmr12eHuTZI8FTJGWLWOCV4hvFKmdVGeN1GI4NlaovbpKRHEVaqwLVQ+n5N1mq+nUsISuhT4kFhg= X-Received: by 2002:a1f:7c4b:: with SMTP id x72mr1919518vkc.14.1598261213714; Mon, 24 Aug 2020 02:26:53 -0700 (PDT) MIME-Version: 1.0 References: <878se4ifg5.fsf@mat.ucm.es> In-Reply-To: <878se4ifg5.fsf@mat.ucm.es> From: Dov Grobgeld Date: Mon, 24 Aug 2020 12:26:42 +0300 Message-ID: Subject: Re: spreadsheet formulas without a . To: emacs-orgmode Content-Type: multipart/alternative; boundary="000000000000e6de1105ad9c2f53" Received-SPF: pass client-ip=2607:f8b0:4864:20::a2d; envelope-from=dov.grobgeld@gmail.com; helo=mail-vk1-xa2d.google.com X-detected-operating-system: by eggs.gnu.org: No matching host in p0f cache. That's all we know. X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20161025 header.b=esfGoGo/; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Spam-Score: -0.71 X-TUID: dKVFCkpf+xGx --000000000000e6de1105ad9c2f53 Content-Type: text/plain; charset="UTF-8" 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 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 > > > --000000000000e6de1105ad9c2f53 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
You can do the following:

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

Search for % at https://orgmode.org/manual/Form= ula-syntax-for-Calc.html .

Regards,

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

Hi

Please look at


| 20 | 0.9 | 18. |
#+TBLFM: $3=3D$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


--000000000000e6de1105ad9c2f53--