From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms5.migadu.com with LMTPS id 4MLaHc7PhmIgGQAAbAwnHQ (envelope-from ) for ; Fri, 20 May 2022 01:16:30 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id WHykHc7PhmIIlwAAauVa8A (envelope-from ) for ; Fri, 20 May 2022 01:16:30 +0200 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 F3FEE715C for ; Fri, 20 May 2022 01:16:29 +0200 (CEST) Received: from localhost ([::1]:36294 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1nrpNc-000893-Ks for larch@yhetil.org; Thu, 19 May 2022 19:16:28 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:56772) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1nrpMJ-00082p-Q5 for emacs-orgmode@gnu.org; Thu, 19 May 2022 19:15:13 -0400 Received: from mail-wr1-x433.google.com ([2a00:1450:4864:20::433]:35599) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1nrpMH-0005li-Rv for emacs-orgmode@gnu.org; Thu, 19 May 2022 19:15:07 -0400 Received: by mail-wr1-x433.google.com with SMTP id r23so9277438wrr.2 for ; Thu, 19 May 2022 16:15:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=WDDmb+mQz3HTZsMoRHhDRtY6c+LHOYfaeqIa2wvN4G4=; b=RFfIcsvscsXgylDFDylS46XIjdFw8vlmPpX0ES0WT+vagAhzzxzSPpNbsDHJzxTSj5 x74TP6Nz6KntkI3wKjChh4K2OkLjdi8vtWB6KTmz1oINF3lTbRJLzmW3P5pGGnZ+a90F UDpN2bp6iv1yhRfUKBm7fsYZ8so/NIRzmsKBjuzsZ295I3jJPyFfzT2vSuuVXXhQ0jkC ewRcaSJltREAeJxd8yH/ySOYsFOSDyN9uVnJzJJFZjiMf9eki4qYf1c1vAKzm5oWYNdq ZlZKk4uYih41LQcAu7JHAF5JxdH/OHPiV1tC13SrBbuG9yhzrp+FhYRNDL+XszkQmZft JfLw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=WDDmb+mQz3HTZsMoRHhDRtY6c+LHOYfaeqIa2wvN4G4=; b=wfjFVzYb78vb7zk+4uBPg52sb5Af2citvulFg/V/B+we4lRyyNuIMLXFyzf11YKizf Yuf7eYTw8j5uIhxTdMa0z167Pl9GL2/rnRNgIKpAhMsFTqCKxwIcdxXtFKg+g0Z+16Yc RyQ1zip1No5tSb9nJVXP8i1oAV+1qcQ+W+Jz5HTzmAqJS4ru3MiDfAImakKmKWMYjfPR eh7LhQpyN4JTXPFYF4dV64BPlSISVTlyt2APzAaFuk9T3/A+Ut4bh2fsmlafKmrNUXys 5ULGv3x65qgMwu4ZWc3O0+T2uF016i+Z4zlTV50NODSMsvHeKtrJqecCjenUrGFvvNTc Iqhw== X-Gm-Message-State: AOAM533qJZdc1VUtvaYMR9bgqJrIZFXzKNgy76pgH/t03iI/euaIvzkr 96TVO7MsQVWSSdybv+nNix4ZsYY+Cphcb6XhG04= X-Google-Smtp-Source: ABdhPJzBjXQA24qHHHxpWbySKLtf2XGJFwiqa3HXK6T5W1HRqqGc5y2IVppbY4RC//b86Irf/H6LNSBe1hq1Oh6WHak= X-Received: by 2002:a05:6000:188a:b0:20c:e43e:83f3 with SMTP id a10-20020a056000188a00b0020ce43e83f3mr6133163wri.621.1653002103944; Thu, 19 May 2022 16:15:03 -0700 (PDT) MIME-Version: 1.0 References: <4938a7eacc0d5db3d3b7be4fb54b378b@riseup.net> In-Reply-To: <4938a7eacc0d5db3d3b7be4fb54b378b@riseup.net> From: Jun Inoue Date: Fri, 20 May 2022 08:14:37 +0900 Message-ID: Subject: Re: Newbie Questions on Spreadsheets To: =?UTF-8?B?UXVpbGlybyBPcmTDs8OxZXo=?= Cc: emacs-orgmode@gnu.org Content-Type: multipart/alternative; boundary="00000000000037f94c05df658b8e" Received-SPF: pass client-ip=2a00:1450:4864:20::433; envelope-from=jun.lambda@gmail.com; helo=mail-wr1-x433.google.com 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, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.29 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-Migadu-Flow: FLOW_IN X-Migadu-To: larch@yhetil.org X-Migadu-Country: US ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1653002190; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=WDDmb+mQz3HTZsMoRHhDRtY6c+LHOYfaeqIa2wvN4G4=; b=sAyVIu/rZn0JRkKoOCsvoPEvUbbLM5aFklbBxYBvu5frWasqOO8w1bkxgvngH1drwkD/t6 v3SxA41PkZGbbKEGvsQCViT5Duib31H1G7cOSRKmYoWEmESoFBiXNGtGbPg5tP2qUlu0Mc /cmv24uLxb5T5FiBSHut6QQfZWMfHb9F/vfre42wEImzYUeCED6vQDWurP+Ma8lw+51KAC 3+z98vCmHgF+LtgwhGbg/RWQ0ngV0slzqaICZDTdCfFQLwA/hR0pEiTBajSmXtIstrmA0o /sSOEq5iFuZegFzx9nPBwKoCQe+kFibpyq8m2Y95WRw/3J98AR/e60KxazHW4w== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1653002190; a=rsa-sha256; cv=none; b=iGwwKkqDpxEawmCpPiPVzaVBFj1P4gOEEhSd7T936mOkqaqF2LLx3mWHBPcyoVwlgF/dMk DhkUQdP2HlSdHYUFOm4tltz7XwGvTKPCVLAbuGEH/qmCb66vRYbuK4TzAloVOyI2J5VN2t NJD49k9eybP44eVFy5HyDwJth5X6GS4AzuqJ92mUmIKHXNPV2ESUd2YBWP84tgduTaIpoS Z1oupA6uQQdltps4E8qqd1JgBCNJZRTTil9gWQxeIDJ1KOy6igGpXi1w8s1w0dgMZ+Zpuf p1g7h5T00i13gbLdb6xbGOBAWaKUmkwUTYWxQ/Rj4fvsBdrIDIdc407nZtPI0Q== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=RFfIcsvs; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Spam-Score: -2.54 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=gmail.com header.s=20210112 header.b=RFfIcsvs; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (aspmx1.migadu.com: domain of "emacs-orgmode-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="emacs-orgmode-bounces+larch=yhetil.org@gnu.org" X-Migadu-Queue-Id: F3FEE715C X-Spam-Score: -2.54 X-Migadu-Scanner: scn0.migadu.com X-TUID: YbfCn9EUgDLw --00000000000037f94c05df658b8e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, May 19, 2022 at 10:47 PM Quiliro Ord=C3=B3=C3=B1ez wrote: > El 2022-05-18 21:13, Jun Inoue escribi=C3=B3: > > > 1. How do you apply a column formula? > > > > The info manual mentions C-u C-c *, but this doesn't always work. For > > example, I have > > > > | $ | | | > > | | 2.80 | | > > | | 5.53 | | > > #+TBLFM: $3=3D$2 > > > > and typing C-u C-c * inside the table changes nothing. If I remove > > the $ cell the C-u C-c * does update the whole table, so could it be a > > bug in the handling of $? > > I changed the `$' for `dollars' and it worked for me. I am a newbie > too. > > Hi Quiliro! This $ is actually not a money amount, but it has special meaning within org-mode spreadsheets. Have a look at this page: https://orgmode.org/manual/Advanced-features.html --=20 Jun Inoue --00000000000037f94c05df658b8e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Thu, May 19, 2022 at 10:47 PM Quil= iro Ord=C3=B3=C3=B1ez <quiliro@ris= eup.net> wrote:
El 2022-05-18 21:13, Jun Inoue escribi=C3=B3:

> 1. How do you apply a column formula?
>
> The info manual mentions C-u C-c *, but this doesn't always work.= =C2=A0 For
> example, I have
>
> | $ |=C2=A0 =C2=A0 =C2=A0 |=C2=A0 =C2=A0|
> |=C2=A0 =C2=A0| 2.80 |=C2=A0 =C2=A0|
> |=C2=A0 =C2=A0| 5.53 |=C2=A0 =C2=A0|
> #+TBLFM: $3=3D$2
>
> and typing C-u C-c * inside the table changes nothing.=C2=A0 If I remo= ve
> the $ cell the C-u C-c * does update the whole table, so could it be a=
> bug in the handling of $?

I changed the `$' for `dollars' and it worked for me.=C2=A0 I am a = newbie
too.


Hi Quiliro!=C2=A0 This $ is actually= not a money amount, but it has special=20 meaning within org-mode spreadsheets.=C2=A0 Have a look at this page: https://orgmode.or= g/manual/Advanced-features.html

--
Jun Inoue
--00000000000037f94c05df658b8e--