Difference between revisions of "Documentation/OOo3 User Guides/Getting Started/Finding more information"

From Apache OpenOffice Wiki
Jump to: navigation, search
(New page: {{DISPLAYTITLE:Finding more information}} {{Documentation/GS3MacroTOC |ShowPrevNext=block |PrevPage=Documentation/OOo3 User Guides/Getting Started/Writing macros without the recorder |Next...)
 
(Removed out of date references.)
 
(2 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
|ShowPrevNext=block
 
|ShowPrevNext=block
 
|PrevPage=Documentation/OOo3 User Guides/Getting Started/Writing macros without the recorder
 
|PrevPage=Documentation/OOo3 User Guides/Getting Started/Writing macros without the recorder
|NextPage=Documentation/OOo3 User Guides/Getting Started/Keyboard Shortcuts
+
|NextPage=Documentation/OOo3 User Guides/Getting Started/Customizing OpenOffice.org
 
}}__NOTOC__
 
}}__NOTOC__
Numerous resources are available that provide help with writing macros. Use '''Help > OpenOffice.org Help''' to open the OOo help pages. 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''.
+
Numerous resources are available that provide help with writing macros. Use '''Help > OpenOffice.org Help''' to open the OOo help pages. 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, choose ''OpenOffice.org Basic'' from this list.
  
 
==Included material==
 
==Included material==
Line 15: Line 15:
 
The following links and references contain information regarding macro programming:
 
The following links and references contain information regarding macro programming:
  
* [http://www.openoffice.org/ http://www.openoffice.org] (the main link)
+
* [http://user.services.openoffice.org/ http://user.services.openoffice.org] (OOo forums, well supported)
* [http://codesnippets.services.openoffice.org/ http://codesnippets.services.openoffice.org/] (categorized examples)
+
* [http://www.oooforum.org/ http://www.oooforum.org] (if you need help with your macros this is a good place to ask, probably one of the best supported OOo forums on the web)
+
 
* [http://api.openoffice.org/docs/common/ref/com/sun/star/module-ix.html http://api.openoffice.org/docs/common/ref/com/sun/star/module-ix.html] (official IDL reference, here you'll find almost every command with a description)
 
* [http://api.openoffice.org/docs/common/ref/com/sun/star/module-ix.html http://api.openoffice.org/docs/common/ref/com/sun/star/module-ix.html] (official IDL reference, here you'll find almost every command with a description)
* [http://api.openoffice.org/DevelopersGuide/DevelopersGuide.html http://api.openoffice.org/DevelopersGuide/DevelopersGuide.html] (official documentation that contains a detailed explanation)
+
* [http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide] (official OpenOffice.org BASIC Programming Guide)
 +
* [http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/OpenOffice.org_Developers_Guide http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/OpenOffice.org_Developers_Guide] (official OpenOffice.org Developers Guide; contains a detailed explanation)
 
* [http://www.pitonyak.org/oo.php http://www.pitonyak.org/oo.php] (Andrew Pitonyak's macro page)
 
* [http://www.pitonyak.org/oo.php http://www.pitonyak.org/oo.php] (Andrew Pitonyak's macro page)
 
* [http://www.pitonyak.org/AndrewMacro.odt http://www.pitonyak.org/AndrewMacro.odt] (numerous examples of working macros)
 
* [http://www.pitonyak.org/AndrewMacro.odt http://www.pitonyak.org/AndrewMacro.odt] (numerous examples of working macros)
 
* [http://www.pitonyak.org/book/ http://www.pitonyak.org/book/] (Andrew Pitonyak wrote a book on macros)
 
* [http://www.pitonyak.org/book/ http://www.pitonyak.org/book/] (Andrew Pitonyak wrote a book on macros)
 
* [http://www.pitonyak.org/database/ http://www.pitonyak.org/database/] (numerous macro examples using Base)
 
* [http://www.pitonyak.org/database/ http://www.pitonyak.org/database/] (numerous macro examples using Base)
* [http://docs.sun.com/app/docs http://docs.sun.com/app/docs] (Sun wrote a book on macro programming—very well written and laid out)
+
* [http://docs.sun.com/app/docs/doc/819-0439 http://docs.sun.com/app/docs/doc/819-0439] (Sun’s book on macro programming—very well written and laid out; the OOo BASIC Programming Guide and the OOo Developers Guide are derived from this book)
* [http://documentation.openoffice.org/ http://documentation.openoffice.org] (contains content related to macros)
+
* [http://ooextras.sourceforge.net/ http://ooextras.sourceforge.net/] (examples)
+
* [http://sourceforge.net/project/showfiles.php?group_id=43716 http://sourceforge.net/project/showfiles.php?group_id=43716] (examples)
+
* [http://homepages.paradise.net.nz/hillview/OOo/ http://homepages.paradise.net.nz/hillview/OOo/] (numerous excellent macros, including reveal codes macros, key macros, and information on converting from MS Office)
+
  
==Published material==
+
==Printed and eBook materials==
  
The following published sources contain macro examples. The most obvious example is the documentation from Sun. Start from Sun's documentation site [http://docs.sun.com/app/docs http://docs.sun.com/app/docs] and search for StarOffice documentation.
+
The following books are available for purchase in both printed and eBook form from their publishers.
  
Andrew Pitonyak wrote a book called ''OpenOffice.org Macros Explained''. Two chapters are available as direct downloads from the publisher. See [http://www.pitonyak.org/book/ http://www.pitonyak.org/book/.]
+
Andrew Pitonyak's ''OpenOffice.org Macros Explained''. See [http://www.hentzenwerke.com/catalog/oome.htm http://www.hentzenwerke.com/catalog/oome.htm].
  
Dr. Mark Alexander Bain wrote ''Learn OpenOffice.org Spreadsheet Macro Programming'' (see [http://www.packtpub.com/openoffice-ooobasic-calc-automation/book http://www.packtpub.com/openoffice-ooobasic-calc-automation/book]).
+
Dr. Mark Alexander Bain's ''Learn OpenOffice.org Spreadsheet Macro Programming''. See [http://www.packtpub.com/openoffice-ooobasic-calc-automation/book http://www.packtpub.com/openoffice-ooobasic-calc-automation/book].
  
 
{{CCBY}}
 
{{CCBY}}
 
[[Category:Getting Started (Documentation)]]
 
[[Category:Getting Started (Documentation)]]

Latest revision as of 02:52, 3 January 2010



Numerous resources are available that provide help with writing macros. Use Help > OpenOffice.org Help to open the OOo help pages. 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, choose OpenOffice.org Basic from this list.

Included material

Many excellent macros are included with OOo. Use Tools > Macros > Organize Macros > OpenOffice.org Basic 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).

Online resources

The following links and references contain information regarding macro programming:

Printed and eBook materials

The following books are available for purchase in both printed and eBook form from their publishers.

Andrew Pitonyak's OpenOffice.org Macros Explained. See http://www.hentzenwerke.com/catalog/oome.htm.

Dr. Mark Alexander Bain's Learn OpenOffice.org Spreadsheet Macro Programming. See http://www.packtpub.com/openoffice-ooobasic-calc-automation/book.

Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools