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 <shanzhu33@gmail.com>:
> 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";"34i")
> The formula =IMPRODUCT(3+i4,3i4) will be regarded as (3+ (value in cell
> i4))*(3(value in cell i4)), so it returns 9.
> The formula =IMPRODUCT(2+i2,0.5i.5), i.5 is not a valid cell reference, so
> #REF returned.
>
> Regards, Shan Zhu
>
>
> 2012/6/7 Dan Lewis <elderdanlewis@gmail.com>
>
>> 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;34j) do not work.
>>>
>>> Advice? Thoughts?
>>>
>>> Thank you.
>>>
>>> Jim Easton
>>> 8585270240
>>>
>> I would not trust IMPRODUCT() to do calculations: they are not
>> correct.
>> For example, I made this calculation: =IMPRODUCT(3+i4,3i4). 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.5i.5). Calc gives an error: #REF.
>>
>> Dan
>>
>>
>> ****
>> To unsubscribe, email:
>> ooousersunsubscribe@**incubator.apache.org<ooousersunsubscribe@incubator.apache.org>
>> For additional commands, email:
>> ooousershelp@incubator.**apache.org<ooousershelp@incubator.apache.org>
>>
>>
>

To unsubscribe, email: ooousersunsubscribe@incubator.apache.org
For additional commands, email: ooousershelp@incubator.apache.org
