20 Oct
2011
20 Oct
'11
2:10 p.m.
There are some support in OpenOffice Calc.
There are a number of functions that operates of complex numbers as
strings. You have to use IMABS() IMPOWER, IMSUB, IMPRODUCT, IMSQRT...
etc when creating formulas. But otherwise it works.
/G?ran
Tony Duell skrev 2011-10-20 21:36:
No, I've not managed to find one, and nor has anyone I've talked to
(many of whom also want it).
This is a serious question, BTW, not M$-bashing or anything like that. I
do use complex numbers for AC circuit analysis, they are useful to
represent the magnitude and pahse of signals, things like that. I'ev been
told many times that the reason I can't get a 'good' scientific
calcualtor any more is that 'everybody uses a spreadsheet'. That may be
true (for suitable approximations to 'everybody' :-)), but nonetheless my
HP RPL machines handle complex numbers directly and are much easier to
sue for AC circuit problems than any normal spreadsheet as a result,
-tony
Did/does any spreadsheet, on any platform, allow you
to put complex
numbers in the cells and operate on them?
Yes, of course you can treat a complex numner as 2 real numbers and
define the appropriate operations -- any spreadsheet will do that. I di=
d
it in Visicalc. But as I use complex numbers a
lot in AC circuit
analysis, and I know others who do too, I am suprised no spreadsheet
handles them as well as my HP calculators.
Gosh.
Not that I know of, no!