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: [email protected]
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
