OpenOffice.org Macros Explained
OpenOffice.org Macros Explained
ISBN: 1930919514
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 203
Pages: 203
Authors: Andrew Pitonyak
- Table of Contents
- BackCover
- OpenOffice.org Macros Explained
- How to Download the Files
- Icons Used in this Book
- Chapter 1: Getting Started
- Storing a Macro in a Document Library
- Storing a Macro in the Application Library
- The Integrated Development Environment
- Library Management
- Renaming Modules and Libraries
- Adding Libraries
- Conclusion
- Chapter 2: Language Constructs
- Compatibility with Visual Basic
- Variables
- The With Statement
- Arrays
- Subroutines and Functions
- Scope of Variables, Subroutines, and Functions
- Operators
- Flow Control
- Error Handling using On Error
- Conclusion
- Chapter 3: Numerical Routines
- Trigonometric Functions
- Rounding Errors and Precision
- Mathematical Functions
- Numeric Conversions
- Number to String Conversions
- Simple Formatting
- Other Number Bases, Hexadecimal, Octal, and Binary
- Random Numbers
- Conclusion
- Chapter 4: Array Routines
- Array() Quickly Builds a one-Dimensional Array with Data
- DimArray Creates Empty Multi-Dimensional Arrays
- Change the Dimension of an Array
- Array to String and Back Again
- Array Inspection Functions
- Conclusion
- Chapter 5: Date Routines
- Retrieve the Current Date and Time
- Dates, Numbers, and Strings
- Locale Formatted Dates
- ISO 8601 Dates
- Extract Each Part of a Date
- Assembling Dates From Components
- Measuring Elapsed Time over Short Intervals
- How Fast Does this Run? A Real-World Example
- Long Time Intervals and Special Dates
- Conclusion
- Chapter 6: String Routines
- ASCII and Unicode Values
- Standard String Functions
- Substrings
- Aligning Strings with LSet and RSet
- Fancy Formatting with Format
- Converting Data to a String
- Conclusion
- Chapter 7: File Routines
- Using URL Notation to Specify a File
- Directory Manipulation Functions
- File Manipulation Functions
- File Attributes, Bitmasks, and Binary Numbers
- Obtaining a Directory Listing
- Open a File
- Information about Open Files
- Reading and Writing Data
- Conclusion
- Chapter 8: Miscellaneous Routines
- Flow Control
- User Input and Output
- Error-Related Routines
- Miscellaneous Routines
- Inspection and Identification of Variables
- Routines You Should Not Use and Other Curiosities
- Conclusion
- Chapter 9: Universal Network Objects
- Base Types and Structures
- UNO Interface
- UNO Service
- Context
- Inspecting Universal Network Objects
- A Few Considerations with UNO Variables
- Built-In Global UNO Variables
- Creating UNO Values for OOo Internals
- Finding Objects and Properties
- UNO Listeners
- Creating a UNO Dialog
- Conclusion
- Chapter 10: UNO and the Dispatcher
- The Environment
- Two Different Methods to Control OOo
- Global Dispatch Commands
- Calc Dispatch Commands
- Chart Dispatch Commands
- Draw Dispatch Commands
- Math Dispatch Commands
- Writer Dispatch Commands
- Writing a Macro using the Dispatcher
- Conclusion
- Chapter 11: StarDesktop
- The Frame Service
- The XEventBroadcaster Interface
- The XDesktop Interface
- The XComponentLoader Interface
- Conclusion
- Chapter 12: Generic Document Methods
- Services and Interfaces
- Getting and Setting Properties: XPropertySet
- Document User Fields: XDocumentInfoSupplier
- List Event Listeners: XEventsSupplier
- Link Targets: XLinkTargetSupplier
- Accessing View Data: XViewDataSupplier
- Close a Document: XCloseable
- Draw Pages: XDrawPagesSupplier
- The Model: XModel
- Saving a Document: XStorable
- Manipulating Styles: XStyleFamiliesSupplier
- Dealing with Locale
- Printing a Document: XPrintable
- Creating Services: XMultiServiceFactory
- Document Settings
- Conclusion
- Chapter 13: Writer Documents
- Basic Building Blocks
- Enumerating Paragraphs
- Cursors
- Selected Text
- Search and Replace
- Text Content
- Text Tables
- Text Fields
- Conclusion
- Chapter 14: Calc Documents
- Accessing Sheets
- Sheet Cells Contain the Data
- Sheet Cell Ranges
- Sheets
- Calc Documents
- Writing Your Own Spreadsheet Functions
- Using the Current Controller
- Converting Excel Macros
- Control Calc From Microsoft Office
- A Better Macro Recorder
- Conclusion
- Chapter 15: Draw and Impress Documents
- Draw Pages
- Shapes
- Forms
- Presentations
- Conclusion
- Chapter 16: Library Management
- Accessing Libraries using OOo Basic
- Libraries Contained in a Document
- Writing an Installer
- Conclusion
- Chapter 17: Dialogs and Controls
- My First Dialog
- Dialog and Control Paradigm
- Controls
- Using the Step Property for Multi-Page AutoPilot Dialogs
- The Object Inspector-A Final Example
- Conclusion
- Chapter 18: Sources of Information
- Help Pages Included with OpenOffice.org
- Macros Included with OpenOffice.org
- Web Sites
- http:api.openoffice.org
- Mailing Lists and Newsgroups
- How to Find Answers
- Conclusion
- Index
- Index_B
- Index_C
- Index_D
- Index_E
- Index_F
- Index_G
- Index_H
- Index_I
- Index_J
- Index_K
- Index_L
- Index_M
- Index_N
- Index_O
- Index_P
- Index_Q
- Index_R
- Index_S
- Index_T
- Index_U
- Index_V
- Index_W
- Index_X
- Index_Y
- Index_Z
- List of Figures
- List of Tables
- List of Listings
OpenOffice.org Macros Explained
ISBN: 1930919514
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 203
Pages: 203
Authors: Andrew Pitonyak