incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fred Juan DIAZ <fredjuan.d...@gmail.com>
Subject Re: Complex numbers in functions
Date Thu, 07 Jun 2012 13:43:17 GMT
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";"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 <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;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<ooo-users-unsubscribe@incubator.apache.org>
>> For additional commands, e-mail:
>> ooo-users-help@incubator.**apache.org<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


Mime
View raw message