Flylib.com
OpenOffice.org Macros Explained
OpenOffice.org Macros Explained
ISBN: 1930919514
EAN: 2147483647
Year: 2004
Pages: 203
Authors:
Andrew Pitonyak
BUY ON AMAZON
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
Year: 2004
Pages: 203
Authors:
Andrew Pitonyak
BUY ON AMAZON
MySQL Stored Procedure Programming
Introduction to MySQL Stored Programs
Using Triggers
Review of Perl DBD::mysql Basics
Conclusion
Stored Programs as an Alternative to Expensive SQL
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
Basic SWT Widgets
Dialogs
SWT Graphics and Image Handling
Drag and Drop and the Clipboard
Drawing Diagrams with Draw2D
Programming Microsoft ASP.NET 3.5
Creating Bindable Grids of Data
Paging Through Data Sources
The HTTP Request Context
Working with Web Services
Working with Images in ASP.NET
InDesign Type: Professional Typography with Adobe InDesign CS2
A Blank Sheet: Typing on Your Page
Ligatures
Using Tab Leaders
Working with Table Cells
Wrapping Type Around Irregularly Shaped Graphics
HTI+ Home Technology Integrator & CEDIA Installer I All-In-One Exam Guide
Computer Network Basics
Designing and Installing Distributed Audio Systems
Home Lighting Devices
Security System Basics
Appendix E CEDIA Installer Level I Classification System
Telecommunications Essentials, Second Edition: The Complete Global Source (2nd Edition)
Packet-Switched Networks
The Internet and IP Infrastructures
IP Services
IPTV
A Brief History of Wireless Telecommunications
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies