2012 Archives by date, by thread · List index

# [libreoffice-users]

```=IMPRODUCT(2+i2,2-i2)
Excuse me, but I believe the terms +2*i2 and -2+i2 do in fact cancel
```
```
should be written:
(2+2i)(2-2i)
2*2 + 2*2i + -2*2i + (-4i^2)
=4          +         (-4)(-1)
=8

--- On Wed, 6/6/12, JOE CONNER <joeconner2007@gmail.com> wrote:

```
```From: JOE CONNER <joeconner2007@gmail.com>
Subject: Re: [libreoffice-users] IMPRODUCT() does not work in Calc
To: users@global.libreoffice.org
Date: Wednesday, June 6, 2012, 8:33 PM
On 6/6/2012 08:02 PM, Jay Lozier
wrote:
```
```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

```
```Excuse me, but I believe the terms +2*i2 and -2+i2 do in
fact cancel
each other out.
This leaves 2*2 and -(-4) as the remaining terms, or 4 + 4 =
8.

Or, have I missed something?

Joe Conner, Poulsbo, WA USA

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

### Context

• [libreoffice-users] · ultraxlnt-domai20044888