2012 Archives by date, by thread · List index

# RE: [libreoffice-users] IMPRODUCT() does not work in Calc

```The problem was resolved by a sharp-eyed developer on the ooo-user list.

The result of 4 is correct.

2+i2 is 2 (because cell i2 is either empty or 0)

2-i2 is 2 (same reason).

(This is because Calc allows simplified direct references to cells.)

The result is 4.

Try =IMPRODUCT("2+2i";"2-2i");

or =IMPRODUCT(COMPLEX(2,2);COMPLEX(2,-2))

etc.

In OpenFormula, There is no direct notation for complex numbers as a numerical form. Text is used
to convey the notation in a way that is distinct in those places where complex operands are allowed
for.  There does not appear to be any reasonable way around this in Calc.

-----Original Message-----
From: Jay Lozier [mailto:jslozier@gmail.com]
Sent: Wednesday, June 06, 2012 20:02
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] IMPRODUCT() does not work in Calc

On 06/06/2012 10:07 PM, Dan Lewis wrote:
```
```     IMPRODUCT() is suppose to calculate products of complex numbers.
However, its answers are not correct: only the real portion of the
complex numbers seem to be used.
=IMPRODUCT(2+i2,2-i2)
= 2*2+2*i2-2*i2-i2*i2
= 4 +i4 -i4 -(4)          [i2*i2=-4]
= 8
But Calc lists the answer as 4.

Are there any complex functions that really work other than
IMREAL()? (It only reads the real part of a complex number.

--Dan

```
```I confirm this result with 3.5.4.2, Ubuntu 12.04

--
Jay Lozier
jslozier@gmail.co

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
```