OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Complex Numbers Add - in: COMPLEX(Real num; I num; Suffix)

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
swingkyd
OOo Advocate
OOo Advocate


Joined: 15 Sep 2004
Posts: 479

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

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?
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Tue Jun 06, 2006 12:07 pm    Post subject: Re: Complex Numbers Add - in: COMPLEX(Real num; I num; Suffi Reply with quote

Put "j" in quotes.

P.S. Version 2, I don't recall a need for an addin. The function works there as needed.

David.
Back to top
View user's profile Send private message
swingkyd
OOo Advocate
OOo Advocate


Joined: 15 Sep 2004
Posts: 479

PostPosted: Tue Jun 06, 2006 12:17 pm    Post subject: Reply with quote

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 Smile

Yes I don't remember adding the Add-in manually. However, the documentation still puts it as an "add-in".

thanks for your reply Smile
Back to top
View user's profile Send private message
swingkyd
OOo Advocate
OOo Advocate


Joined: 15 Sep 2004
Posts: 479

PostPosted: Tue Aug 29, 2006 12:25 pm    Post subject: Reply with quote

has anyone else noticed that the complex functions don't filter to MS Excel?
Back to top
View user's profile Send private message
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Tue Aug 29, 2006 3:31 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group