| View previous topic :: View next topic |
| Author |
Message |
rebelxt
OOo Enthusiast
Joined: 10 Dec 2006
Posts: 114
Location: StLouis
|
 Posted: Sun Dec 10, 2006 5:56 pm Post subject: Need list of Calc-specific functions |
 |
|
In order to write macros for OOo Calc, a list of available functions (and descriptions) is required. The basic functions, such as the math and text manipulation functions are well described in the OOo Basic help in the Calc program. What is not there is a list of Calc-specific functions such as getcellrangebyname(). There are several very good user guides available on the internet that describe how to use a number of the more common functions, but not a comprehensive list of the functions. At least that I have been able to find.
Does anyone know where one can be found? |
|
| Back to top |
|
 |
jeanweber
Moderator
Joined: 30 Dec 2005
Posts: 674
Location: Queensland, Australia
|
| Posted: Sun Dec 10, 2006 8:08 pm Post subject: |
|
|
What you need is "OpenOffice.org Macros Explained" by Andrew Pitonyak, Hentzenwerke, 2004, ISBN 1930919514. A variation of that book is available online, I think, though I can't find the link right now. I'll come back and edit this if I find it.
Andrew reads the forums, so he may see this note and give you the best answer.
_________________
Regards, Jean Hollis Weber
Get free PDFs of OOo user guides from http://wiki.services.openoffice.org/wiki/Documentation/
Printed copies http://www.lulu.com/opendocument |
|
| Back to top |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
|
| Back to top |
|
|
rebelxt
OOo Enthusiast
Joined: 10 Dec 2006
Posts: 114
Location: StLouis
|
| Posted: Mon Dec 11, 2006 5:16 am Post subject: |
|
|
OK, I'm whining now, I know, but this is basic information that should be included in the Calc program's help. It should not be necessary to buy a book to find it.
Which doesn't mean I won't buy the book if that's the only way. |
|
| Back to top |
|
|
jeanweber
Moderator
Joined: 30 Dec 2005
Posts: 674
Location: Queensland, Australia
|
| Posted: Mon Dec 11, 2006 2:55 pm Post subject: |
|
|
| rebelxt wrote: | | OK, I'm whining now, I know, but this is basic information that should be included in the Calc program's help. It should not be necessary to buy a book to find it. |
You definitely do NOT need to buy a book to get the info you want. It may not be in the help, but it's available free on the OOo website somewhere. I don't remember where, because I don't do macros, and because I'm more book-oriented than online-oriented. Also, Andrew's book has lots of other "value added" stuff in addition to the tables.
_________________
Regards, Jean Hollis Weber
Get free PDFs of OOo user guides from http://wiki.services.openoffice.org/wiki/Documentation/
Printed copies http://www.lulu.com/opendocument |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Mon Dec 11, 2006 3:01 pm Post subject: |
|
|
| jeanweber wrote: |
You definitely do NOT need to buy a book to get the info you want. It may not be in the help, but it's available free on the OOo website somewhere. I don't remember where, because I don't do macros, and because I'm more book-oriented than online-oriented. Also, Andrew's book has lots of other "value added" stuff in addition to the tables. |
I'm with you on the reference book preference, and don't follow the argument against it. It's there, it's handy, it's easier on the eyes, it's downright easier...... . If an online source was the only option available, I'd still print it out ...how many pages did you say?
David. |
|
| Back to top |
|
|
|
