Spreadsheet calc complex number display format

Spreadsheet calc complex number display format

[Rob Duncan]

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.

Re: Spreadsheet calc complex number display format

[Russell Adams]

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

Re: Spreadsheet calc complex number display format

[Rob Duncan]

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.

Re: Spreadsheet calc complex number display format

[Rob Duncan]

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.

Re: Spreadsheet calc complex number display format

[Russell Adams]

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

Re: Spreadsheet calc complex number display format

[Rob Duncan]

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.