Hi
an old file made with OOo2 in 2009. It should work.
It contains nearly all usual features about complex in elec
http://campuslibre.educoo.org/courses/BACPROM/document/9B_Nombres_complexes/complexes.ods
I hope that localisation (translation) of used functions will be ok
if useful...
Fred Juan Diaz
=====================
2012/6/7, Shan Zhu :
> Getting 9 as a result, it causes by incorrect parameter format in your
> formula.
> The complex number should be put in a pair of double quotation marks, like
> this:=IMPRODUCT("3+4i";"3-4i")
> The formula =IMPRODUCT(3+i4,3-i4) will be regarded as (3+ (value in cell
> i4))*(3-(value in cell i4)), so it returns 9.
> The formula =IMPRODUCT(2+i2,0.5-i.5), i.5 is not a valid cell reference, so
> #REF returned.
>
> Regards, Shan Zhu
>
>
> 2012/6/7 Dan Lewis
>
>> Easton, William wrote:
>>
>>> I am having difficulties trying to do complex number calculations.
>>>
>>> First, it is a real pain to have to use functions for ordinary
>>> operations. I would like to propose a simple switch that might pop up if
>>> a
>>> complex number were detected substituting the complex versions of
>>> *,/,+,-
>>> for the real counterparts. Even more radical would be to do the same for
>>> functions, but one might need a compatibility mode.
>>>
>>> However, I am finding that things like improduct(1+2j;3-4j) do not work.
>>>
>>> Advice? Thoughts?
>>>
>>> Thank you.
>>>
>>> Jim Easton
>>> 858-527-0240
>>>
>> I would not trust IMPRODUCT() to do calculations: they are not
>> correct.
>> For example, I made this calculation: =IMPRODUCT(3+i4,3-i4). The answer
>> given was 9. But this is just the product of the real numbers. The
>> correct
>> answer is 25 (3*3 +3*i4 -3*i4 +4*4).
>> I also discovered that it may not work with fractions:
>> =IMPRODUCT(2+i2,0.5-i.5). Calc gives an error: #REF.
>>
>> --Dan
>>
>>
>> ------------------------------**------------------------------**---------
>> To unsubscribe, e-mail:
>> ooo-users-unsubscribe@**incubator.apache.org
>> For additional commands, e-mail:
>> ooo-users-help@incubator.**apache.org
>>
>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org