maxweber wrote:
On Mon, Jan 16, 2006 at 06:56:59AM +1000, Jean Hollis Weber wrote:
Darren Forster wrote,
Just wondering if anyone knows where I can find a list of properties and
functions that can be applied to various items in OpenOffice basic. Is
there a book or website available?
e.g. I'm guessing that a table in OpenOffice must have loads of
properties such as Visible, ReadOnly, Text, SelectedText, etc and
functions to return information what are they and how do I find them out?
"OpenOffice.org Macros Explained" by Andrew Pitonyak, published
by Hentzenwerke, July 2004, ISBN 1930919514. Very little has
changed from OOo1.1.x to 2.0, so this book is still current.
I strongly disagree with posting commercial sources only.
Max
Hi Max,
Although you may disagree with posting ONLY a commercial source, did you
notice that the free sources have already been posted. I will temper the
recommendation of OOo Macros explained, which contains numerous
excellent examples shown below:
Included Material
Use Help | OpenOffice.org Help to open the OOo help pages. OOo contains
help for Writer, Calc, Base, Basic, Draw, Math, and Impress. The upper
left corner of the OOo help system contains a drop down list that
determines which help set is displayed. To view the help for Basic, the
drop down must display “Help about OpenOffice.org Basic”.
Many excellent macros are included with OOo. For example, I found a
macro that prints the property and method names for an object. I used
these methods before I wrote my own object inspector. Use Tools | Macros
| Organize Macros | OpenOffice.org Basic (Prior to verion 2.0, use Tools
| Macros | Macro) to open the Macro dialog. Expand the Tools library in
the OpenOffice.org library container. Inspect the Debug module – some
good examples include WritedbgInfo(document) and printdbgInfo(sheet).
TIP
Before running a macro, the library that contains the macro must be
loaded. The first chapter of my book, which discusses libraries in
depth, is available as a free download (see
http://www.pitonyak.org/book/”). This is a great introduction for a
beginner and it is free.
On line Resources
The following links and references help decrypt the initially difficult
paradigm:
http://www.openoffice.org (the main link)
http://www.oooforum.org (if you need help with your macros this is the
perfect place to ask, probably one of the best supported forums on the web)
http://api.openoffice.org/docs/common/ref/com/sun/star/module-ix.html
(this is the official IDL reference, here you'll find almost every
command with a description)
http://api.openoffice.org/DevelopersGuide/DevelopersGuide.html (The
second official Documentation, explains everything in detail on almost
1000 pages!)
http://www.pitonyak.org/AndrewMacro.odt (Latest copy of this document)
http://www.pitonyak.org/book/ (buy a copy of my book)
http://docs.sun.com/db/doc/817-1826-10 (Sun wrote a book on macro
programming. This contains the same errors as the included help files,
but it is still an excellent place to start. Very well written and laid out)
http://api.openoffice.org/basic/man/tutorial/tutorial.pdf (Excellent)
http://docs.sun.com/db/coll/999.2?q=star+office (original Sun documentation)
http://api.openoffice.org (This site takes some getting used to but it
is very complete)
http://documentation.openoffice.org Download the “How To” document
referenced below.
http://documentation.openoffice.org/HOW_TO/various_topics/How_to_use_basic_macros.sxw
http://udk.openoffice.org (Here you will find advanced information about
UNO)
http://udk.openoffice.org/common/man/tutorial/office_automation.html (OLE)
http://ooextras.sourceforge.net/ (Examples)
http://disemia.com/software/openoffice/ (Examples, mainly for the
Calculator)
http://kienlein.com/pages/oo.html (Examples)
http://www.darwinwars.com/lunatic/bugs/oo_macros.html (Examples)
http://sourceforge.net/project/showfiles.php?group_id=43716 (Examples)
http://www.kargs.net/openoffice.html (Examples)
http://www.8daysaweek.co.uk/ (Examples and Documentation)
http://ooo.ximian.com/lxr/ (you can dig through the source code online here)
http://homepages.paradise.net.nz/hillview/OOo/ (numerous excellent
macros here including reveal codes macros, key macros, and, information
on converting from MS Office)
To find detailed specific information, search the Developer's Guide or
perform a web search such as “cursor OpenOffice”. To limit the search,
use the following search: “site:api.openoffice.org cursor”.
If I know the package name, I can usually guess the web location. I
inspect the API web site at least as often as I inspect objects.
http://api.openoffice.org/docs/common/ref/com/sun/module-ix.html
Translations of this document
Table 2.1. Translations of this document.
Link
Language
http://www.pitonyak.org/AndrewMacro.odt
English
http://fr.openoffice.org/Documentation/Guides/Indexguide.html*
French
http://www.pitonyak.org/AndrewMacroGerman.sxw*
German
* The translations are not up to date, especially the German version.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
