| View previous topic :: View next topic |
| Author |
Message |
swingkyd
OOo Advocate
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:
I get the following output:
Other functions seem to work such as "IMSUM"...
Does anyone have any ideas what might be causing this? |
|
| Back to top |
|
 |
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| 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. |
|
| Back to top |
|
|
swingkyd
OOo Advocate
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 |
|
| Back to top |
|
|
swingkyd
OOo Advocate
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? |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| 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. |
|
| Back to top |
|
|
|
