From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id 6AJ+LfmWA18lEwAA0tVLHw (envelope-from ) for ; Mon, 06 Jul 2020 21:26:17 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id 6N0zKfmWA1+LbQAAbx9fmQ (envelope-from ) for ; Mon, 06 Jul 2020 21:26:17 +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 965A79401D0 for ; Mon, 6 Jul 2020 21:26:16 +0000 (UTC) Received: from localhost ([::1]:40030 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jsYcx-00040u-7v for larch@yhetil.org; Mon, 06 Jul 2020 17:26:15 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:34526) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jsYcW-00040B-AU for emacs-orgmode@gnu.org; Mon, 06 Jul 2020 17:25:48 -0400 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]:43247) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jsYcU-0002EO-BN for emacs-orgmode@gnu.org; Mon, 06 Jul 2020 17:25:48 -0400 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 97722D21 for ; Mon, 6 Jul 2020 17:25:44 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Mon, 06 Jul 2020 17:25:44 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= tabstopclear.org; h=from:to:subject:references:date:in-reply-to :message-id:mime-version:content-type:content-transfer-encoding; s=fm2; bh=IuFa+wEKRJUiX4AWROicmecJ7kRcNXrExFyNVi9jVvA=; b=es/9J hARkaHA7ZgoXziWl2+A0CCmtlVyz4XDSawwHD+oT1UIX/PXtYfjCai06bwFDPrp8 0QecRV4h2+jhvkOM1gWf87iclNcflOrehSjAXDHidv2pTpOusiTeMWnphdtXfQzf JCPXW4LZaCNFUbVg70QHhiPWDfQlSzjJqAwbI6GXOByavR9ymKDXwdcknOADm+r4 ibXzm7pvCw6pEMQLL/6zd55LhMygqcDNaHUysjBCeWrAb68SdAsvUCvaH4nWAtoV 3PHFTC9UwGzAuPiTTNVHKCAoaSaGxhDxezDG9rfRBAfmR2OvuU5JzUGuIdS8rY3E guz4UZHwqZjT8EK0g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; bh=IuFa+wEKRJUiX4AWROicmecJ7kRcNXrExFyNVi9jV vA=; b=NUqCOzGRJk8obB1riiUiNik/J+3XOgn8R6cURVhQuJ+0YvLzQNsp6poat X8Oj2nsN1tLSSkCM0SMAQGGvYVk+gZslJlMTBYma8tT6mjUFeDTsk48w75wv0Ir7 dH7akVOp3IV6kmjwNIMeJ86jJSUo9Egn7CyO5+p5ccIg92SVPAOiu8twnjA4HjIH ejnqyPpz2NnJxRpXhOEpqe9H6uMWjt8T8S226u9xjngqIU3btQA9Fyx6tDrDelQf DvXnQFFYRd8hsd8YRk+CMmBxLmCj5HTxBy1POKVf2cNYIFK7EHyhSERwLB9nG2PS hoQ8ba+uqYOd1r8HXlQQShVCnq8lQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduiedrudefgdduieefucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucenucfjughrpefhvffufhffjgfkfgggtgfgsehtqh ertddtreejnecuhfhrohhmpeftohgsucffuhhntggrnhcuoegrnhgurghpohhnhiesthgr sghsthhophgtlhgvrghrrdhorhhgqeenucggtffrrghtthgvrhhnpeehteevkeeluedvje evieefkeeuudehfeekieehhedtleehueeghfdtvdegieeftdenucffohhmrghinhepohhr ghhmohguvgdrohhrghenucfkphepudegkedrieegrdelledrvdefnecuvehluhhsthgvrh fuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghnuggrphhonhihsehtrggs shhtohhptghlvggrrhdrohhrgh X-ME-Proxy: Received: from Leroy.local (148-64-99-23.public.monkeybrains.net [148.64.99.23]) by mail.messagingengine.com (Postfix) with ESMTPA id B988A30653F5 for ; Mon, 6 Jul 2020 17:25:43 -0400 (EDT) From: Rob Duncan To: emacs-orgmode@gnu.org Subject: Re: Spreadsheet calc complex number display format References: <20200706060914.GZ19456@volibear> Date: Mon, 06 Jul 2020 14:25:42 -0700 In-Reply-To: <20200706060914.GZ19456@volibear> (Russell Adams's message of "Mon, 6 Jul 2020 08:09:14 +0200") Message-ID: User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.2 (darwin) MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Received-SPF: pass client-ip=64.147.123.25; envelope-from=andapony@tabstopclear.org; helo=wout2-smtp.messagingengine.com X-detected-operating-system: by eggs.gnu.org: First seen = 2020/07/06 17:25:45 X-ACL-Warn: Detected OS = Linux 2.2.x-3.x [generic] [fuzzy] X-Spam_score_int: -27 X-Spam_score: -2.8 X-Spam_bar: -- X-Spam_report: (-2.8 / 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, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001 autolearn=_AUTOLEARN 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=tabstopclear.org header.s=fm2 header.b=es/9J hA; dkim=pass header.d=messagingengine.com header.s=fm3 header.b=NUqCOzGR; dmarc=none; 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: -1.21 X-TUID: CBoDAQrQeTl/ Russell Adams writes: > On Sun, Jul 05, 2020 at 04:00:47PM -0700, Rob Duncan wrote: >> Is there a way to specify the display format used for complex number >> calculations in the table spreadsheet? In particular I'd like to be >> able control whether a value is displayed in rectangular or polar form. > > I often enforce two decimal places in my tables: > > #+TBLFM: @9$1=3Dvsum(@-I..@-II);%0.2f > > https://orgmode.org/manual/Formula-syntax-for-Calc.html > > Can that help you with polar form? Hi Russell, I was initially hoping that there would be some kind of mode string that would directly control this (perhaps something like `;I=E2=80=99 or `;J=E2= =80=99 for rectangular format, or `;P=E2=80=99 for polar format), but that isn't suppo= rted. I don't quite see how to use your `;%f=E2=80=99 suggestion for this, though. Can you elaborate? I also tried messing around with org-calc-default-modes to no avail. Thanks, Rob.