Re: Formatting complex numbers?

I'm not sure if this was intentional?


Excel's number system, and thus Gnumeric's (and LO's, etc), know
nothing about complex numbers.  They are bolted on sideways as
strings, lots of duct tape involved.  There is no support for
rounding-for-purposes of display.

So it's not going to be elegant.

What you can do, as a sort-of workaround, is to extract the real and
imaginary parts.  Say, A1 contains a complex formula.  Then enter
=REAL(A1) into B1 and =IMAGINARY(A1) into C1.  Those numbers you can
format in all the usual ways.

We could introduce a function to round complex numbers but any use of
it would actually change values and thus results.  Not a great idea


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]