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
Similar book on Amazon
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
The CISSP and CAP Prep Guide: Platinum Edition
Inside Network Security Assessment: Guarding Your IT Infrastructure
The Policy Framework
Encryption
Laws, Mandates, and Regulations
Post-Assessment Activities
Typical RFP Procurement Steps
MySQL Cookbook
Recording a Rows Last Modification Time
Sorting by Variable-Length Substrings
Sorting ENUM Values
The Effect of ALTER TABLE on Null and Default Value Attributes
Determining Presence or Absence of a Result Set
Competency-Based Human Resource Management
The Transformation to Competency-Based HR Management
Competency-Based HR Management The Next Steps
Appendix B Further Suggestions on Employee Development
Appendix C Examples of Life-Career Assessment Exercises
Appendix D Employee Development and Succession Management
HTI+ Home Technology Integrator & CEDIA Installer I All-In-One Exam Guide
Planning a Structured Wiring Installation
Distributed Audio System Basics
Designing and Installing Distributed Video Systems
Troubleshooting and Maintaining a Home Security System
Defining Users Needs and Desires
.NET-A Complete Development Cycle
The .NET Framework
Conclusion
Design of the Photo Editor Application
Analysis of the Editor Optimization Requirement
Multithreading and Optimization Implementation
DNS & BIND Cookbook
Adding a Mail Destination
Filtering a Host Table into Zone Data Files
Restarting a Name Server with the Same Arguments
Measuring a Name Servers Performance
Defining a TSIG Key
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