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 2FzMEt+QBF82eQAA0tVLHw (envelope-from ) for ; Tue, 07 Jul 2020 15:12:31 +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 aEilDt+QBF/6EgAA1q6Kng (envelope-from ) for ; Tue, 07 Jul 2020 15:12:31 +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 D3A34940D36 for ; Tue, 7 Jul 2020 15:12:28 +0000 (UTC) Received: from localhost ([::1]:51752 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jspGl-0007Fy-1a for larch@yhetil.org; Tue, 07 Jul 2020 11:12:27 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:46118) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jspGN-0007Fp-KX for emacs-orgmode@gnu.org; Tue, 07 Jul 2020 11:12:03 -0400 Received: from out2-smtp.messagingengine.com ([66.111.4.26]:40601) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jspGH-0004uI-DD for emacs-orgmode@gnu.org; Tue, 07 Jul 2020 11:12:03 -0400 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id B70585C0068 for ; Tue, 7 Jul 2020 11:11:56 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Tue, 07 Jul 2020 11:11:56 -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; s=fm2; bh=zDCXwP2QOLUhxgU QC54CyuJjIKp5Q1v4Mlurx8lKwTs=; b=MGiM0fFx/hWbSUABCI/wdM9Am2AUZa+ 856i6eQRHX9W58e298VtMG5bI7Nk3XuIJYczboI9DRBT8CUW8B9NvFGuaxxTJ5Wf hbgTEsGQuQAnITwhdab+Pil1XYxCDGUsgVv5HCHrzqmDvtXPCI+XsJghFHQWOPfk ZgxlUfqdPNy0vqRl9GbJUetfVnV5pgvVCwMPJ7XU2smcdowV/nzq17666ioJFVQJ 9FWcJSAw5fJXeNMGDcdZ6stsc0ths6WpiunsVLxKYcxvOkBqZUMc5UsDcGrAkBAE g6Z0vMDbbzVzB123cjLlsc+UicRZ30/1/lU4a04FXlvpjuZo4UBoyCA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=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=zDCXwP 2QOLUhxgUQC54CyuJjIKp5Q1v4Mlurx8lKwTs=; b=HFZPDckBfywRtATQsFsf08 SWdm/09IYFO4oPeEw64tEjL53cjwtHKtr0eSdStRe8cmQHombeolQDz7U9xwdegH q57hzSmIVTnQkS/n+T2oEdmn8X8ZudUb4lho+EE0KMA5SjXwDZ3QPsOHvoD1VF78 LvB46GQs6JBOybfqMMssW6aMBzlzJos+iog2c861mdbO1lfGGHVm6joueOauttJE Kk1vHr/TL9rD8YOBlJfIEstZmeUFftZFb4Eeqig0YlLJW98nJrrNzONmXz52GLcD 5Efzdd7amBxA3upwE1Z7aKROq6/NOeax3iis/omi6S6UvdLEb8uj9F7H9nPhkN4Q == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduiedrudehgdektdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhephffvufhfffgjkfgfgggtsehttdertd dtredtnecuhfhrohhmpeftohgsucffuhhntggrnhcuoegrnhgurghpohhnhiesthgrsghs thhophgtlhgvrghrrdhorhhgqeenucggtffrrghtthgvrhhnpedtteevteejffevleefhe ejgfetgeffhfeivedvgeefudekueegudegteeiteelueenucfkphepudegkedrieegrdel ledrvdefnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomh eprghnuggrphhonhihsehtrggsshhtohhptghlvggrrhdrohhrgh 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 241953280060 for ; Tue, 7 Jul 2020 11:11:56 -0400 (EDT) From: Rob Duncan To: emacs-orgmode@gnu.org Subject: Re: Spreadsheet calc complex number display format References: <20200707035721.GJ19456@volibear> Date: Tue, 07 Jul 2020 08:11:54 -0700 In-Reply-To: <20200707035721.GJ19456@volibear> (Russell Adams's message of "Tue, 7 Jul 2020 05:57:21 +0200") Message-ID: User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/26.2 (darwin) MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=66.111.4.26; envelope-from=andapony@tabstopclear.org; helo=out2-smtp.messagingengine.com X-detected-operating-system: by eggs.gnu.org: First seen = 2020/07/07 11:11:56 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=MGiM0fFx; dkim=pass header.d=messagingengine.com header.s=fm3 header.b=HFZPDckB; 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: mVYHFc20vqJy Russell Adams writes: > On Mon, Jul 06, 2020 at 05:59:18PM -0700, Rob Duncan wrote: >> Rob Duncan writes: >> >> > 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 ended up explicitly using the `polar(Z)' and `rect(Z)' functions in >> the table formulae and I now get the display format I'm looking for. > > Rob, can you paste an example for others to reference later? Yep, here's one: | ! | A | B | R | P | |---+------------+------------+-----------------+------------------| | # | (1,1) | (1,1) | (0, 2) | (2; 90.) | | # | (1.414;45) | (1.414;45) | (0., 1.999396) | (1.999396; 90) | | # | (1,1) | (1.414;45) | (0., 1.9996980) | (1.9996980; 90.) | | # | (1.414;45) | (1,1) | (0., 1.9996980) | (1.9996980; 90.) | #+TBLFM: $4=rect($A*$B)::$5=polar($A*$B) Rob.