Hi William,
Easton, William schrieb:
My complex numbers seem always to be displayed to full precision
independent of what I set in Cell/Number. This is not beautiful.
Suggestions? Comments?
Much thanks for the responses to my earlier function query!
Because it is a text, there exists no difference between cell content
and visual appearance of the content. If you will use the output from
one calculation as input to another calculation, you need all figures to
retain maximal accuracy. There exists no special number format for
complex numbers, but the general text format is used. In addition, the
syntax of complex numbers do not allow a blank inside the number, so you
cannot wrap the entry.
https://issues.apache.org/ooo/show_bug.cgi?id=36036
https://issues.apache.org/ooo/show_bug.cgi?id=84363
This calculating on texts has the second shortcoming, that you have no
local numberformat but always a decimal dot.
As workaround you might consider to write the complex number to a hidden
row/column/sheet or to a cell with alignment "shrink to fit" and make
the value readable by yourself with IMAGINARY() and IMREAL().
Or you have to write a set of macros and implement you own complex
functions as array function.
You are indeed using complex functions? Then you might be interested
watching https://issues.apache.org/ooo/show_bug.cgi?id=111609 ODFF:
implement missing imaginary functions
Kind regards
Regina
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
