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!
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