[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
swingkyd

Joined: 15 Sep 2004
Posts: 479

Posted: Tue Jun 06, 2006 11:32 am    Post subject: Complex Numbers Add - in: COMPLEX(Real num; I num; Suffix)

I am using an Add-in that provides the function:
 Code: COMPLEX The result is a complex number which is returned from a real coefficient and an imaginary coefficient. Syntax COMPLEX(Real num;I num;Suffix) Real num: the real coefficient of the complex number. I num: the imaginary coefficient of the complex number. Suffix: list of options, "i" or "j". Example =COMPLEX(3;4;j) returns 3+4j.

However, when I use the function:
 Code: =COMPLEX(3;4;j)

I get the following output:
 Code: #NAME?

Other functions seem to work such as "IMSUM"...

Does anyone have any ideas what might be causing this?
David
Super User

Joined: 24 Oct 2003
Posts: 5668

 Posted: Tue Jun 06, 2006 12:07 pm    Post subject: Re: Complex Numbers Add - in: COMPLEX(Real num; I num; Suffi Put "j" in quotes. P.S. Version 2, I don't recall a need for an addin. The function works there as needed. David.
swingkyd

Joined: 15 Sep 2004
Posts: 479

 Posted: Tue Jun 06, 2006 12:17 pm    Post subject: I JUST found that out on my own... It appears that the documentation is a little off since the example shows simply j when it should be "j"... but thanks Yes I don't remember adding the Add-in manually. However, the documentation still puts it as an "add-in". thanks for your reply
swingkyd

Joined: 15 Sep 2004
Posts: 479

 Posted: Tue Aug 29, 2006 12:25 pm    Post subject: has anyone else noticed that the complex functions don't filter to MS Excel?
David
Super User

Joined: 24 Oct 2003
Posts: 5668

 Posted: Tue Aug 29, 2006 3:31 pm    Post subject: I had no problem with a file having complex numbers and their sum saved as XLS, opened with Excel, nor with one saved in Excel then opened in Calc. David.
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum