| View previous topic :: View next topic |
| Author |
Message |
cgr4668
Newbie
Joined: 30 Dec 2008
Posts: 3
|
 Posted: Tue Dec 30, 2008 6:39 am Post subject: Add-ins in O-O Calc? |
 |
|
| I'm new to O-O, and have downloaded O-O-2.4 then O-O-3.0, installed under Windows. Cannot find add-in functions in Calc (complex math functions, for example). Are these functions part of the download, or does a .dll file need to be downloaded separately? |
|
| Back to top |
|
 |
thomasjk
Super User
Joined: 16 Dec 2005
Posts: 2308
|
| Posted: Tue Dec 30, 2008 6:49 am Post subject: |
|
|
| What complex functions do you need? OOo has an equation editor but I don't think that's what you're talking about. |
|
| Back to top |
|
|
cgr4668
Newbie
Joined: 30 Dec 2008
Posts: 3
|
| Posted: Tue Dec 30, 2008 7:57 am Post subject: |
|
|
| No, the equation editor isn't the problem. Under the Help tab, there is a topic "add-in functions; Analysis Functions, part 1 and part 2". The functions that I want to use in a spreadsheet are listed on these tabs. Functions like BIN2HEX(), IMABS(), COMPLEX(). etc. When I try to use the Insert>>Function>>AddIn pull down to insert the COMPLEX() function for example, the result is an error (ERR:504), I think that means that the function couldn't be found. |
|
| Back to top |
|
|
thomasjk
Super User
Joined: 16 Dec 2005
Posts: 2308
|
| Posted: Tue Dec 30, 2008 8:40 am Post subject: |
|
|
You have to experiment a bit but there are a minimum number of paces needed in the formulas.
For example: =BIN2HEX(A2;6) anything less than 6 places give an error 502. |
|
| Back to top |
|
|
cgr4668
Newbie
Joined: 30 Dec 2008
Posts: 3
|
| Posted: Tue Dec 30, 2008 10:29 am Post subject: |
|
|
| Thank you. Your post led me to a couple of help topics, that held the key to solving my problem! |
|
| Back to top |
|
|
|
