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. Thanks, Rob.
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=vsum(@-I..@-II);%0.2f https://orgmode.org/manual/Formula-syntax-for-Calc.html Can that help you with polar form? ------------------------------------------------------------------ Russell Adams RLAdams@AdamsInfoServ.com PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/ Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3
Russell Adams <RLAdams@AdamsInfoServ.Com> 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=vsum(@-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’ or `;J’ for
rectangular format, or `;P’ for polar format), but that isn't supported.
I don't quite see how to use your `;%f’ suggestion for this, though.
Can you elaborate?
I also tried messing around with org-calc-default-modes to no avail.
Thanks,
Rob.
Rob Duncan <andapony@tabstopclear.org> 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.
On Mon, Jul 06, 2020 at 05:59:18PM -0700, Rob Duncan wrote: > Rob Duncan <andapony@tabstopclear.org> 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? ------------------------------------------------------------------ Russell Adams RLAdams@AdamsInfoServ.com PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/ Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3
Russell Adams <RLAdams@AdamsInfoServ.Com> writes:
> On Mon, Jul 06, 2020 at 05:59:18PM -0700, Rob Duncan wrote:
>> Rob Duncan <andapony@tabstopclear.org> 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.