------- 原始郵件 ------- 主旨: Re: [libreoffice-users] IMPRODUCT() does not work in Calc 從: Jay Lozier <jsloz...@gmail.com> 到: users@global.libreoffice.org 日期: Wed, 06 Jun 2012 23:02:05 -0400
> 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 > According to the help document "http://help.libreoffice.org/scalc/SC_HID_AAI_FUNC_IMPRODUCT?Language=en_US&System=WIN&Version=3.5#bm_id3150661";, the formula should be IMPRODUCT("2+2j","2-2j") Thank you. -- For unsubscribe instructions e-mail to: users+h...@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
