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
Beginners Guide to DarkBASIC Game Programming (Premier Press Game Development)
Introduction to Computer Programming
More Power to the Numbers Data Sequences and Arrays
Programming the Keyboard, Mouse, and Joystick
Adding Sound Effects to Your Game
Loading and Saving Information Using Files
OpenSSH: A Survival Guide for Secure Shell Handling (Version 1.0)
Step 1.2 Install SSH Windows Clients to Access Remote Machines Securely
Step 3.4 Use PuTTYs Tools to Transfer Files from the Windows Command Line
Step 4.3 How to Generate a Key Pair Using OpenSSH
Step 4.4 How to Generate a Key Using PuTTY
Step 4.6 How to use PuTTY Passphrase Agents
Secure Programming Cookbook for C and C++: Recipes for Cryptography, Authentication, Input Validation & More
Parsing a String Containing a Number in Scientific Notation
Managing Data with Containers
Writing and Reading Currency
Transforming an XML Document with XSLT
Introduction
C & Data Structures (Charles River Media Computer Engineering)
The printf Function
Storage of Variables
Union
Arrays, Searching, and Sorting
Problems in Arrays, Searching, Sorting, Hashing
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
The Internationalization of the Retail Supply Chain
Market Orientation and Supply Chain Management in the Fashion Industry
Fashion Logistics and Quick Response
Temperature-Controlled Supply Chains
Enterprise Resource Planning (ERP) Systems: Issues in Implementation
DNS & BIND Cookbook
Getting BIND
Configuring a Name Server to Work with ndc
Finding an Offsite Slave Name Server for Your Zone
Testing a Name Servers Configuration
Running a Name Server in a chroot( ) Jail
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