OpenOffice.org macros explained

OpenOffice.org macros explained /

Annotation This book provides an introduction to the creation and management of macros in OpenOffice. Numerous examples and explanations demonstrate proper techniques and discuss known problems and solutions. The underlying data structure is discussed and techniques are introduced to evaluate OpenOf...

Full description

Saved in:
Bibliographic Details
Online Access: Full text (MCPHS users only)
Main Author: Pitonyak, Andrew (Andrew Douglas)
Other Authors: Pearsall, C. (Editor), Weber, Jean Hollis (Editor), Boyer, Amy (Editor)
Format: Electronic eBook
Language:English
Published: Whitefish Bay, WI : Hentzenwerke Pub., 2004
Subjects:
OpenOffice.org (Electronic resource)
Integrated software.
Business > Computer programs.
Local Note:ProQuest Ebook Central
Table of Contents:
  • Our Contract with You, the Reader
  • List of Chapters
  • Table of Contents
  • Acknowledgments
  • About the Authors
  • How to Download the Files
  • Icons Used in this Book
  • Chapter 1: Getting Started
  • Storing a macro in a document library
  • Step 1. Create a library
  • Step 2. Create a module
  • Step 3. Enter your first macro
  • Storing a macro in the application library
  • The Integrated Development Environment
  • Using breakpoints
  • Library management
  • How libraries are stored
  • Application libraries
  • Document libraries
  • Using the Macro Organizer
  • Renaming modules and libraries.
  • Adding libraries
  • Conclusion
  • Chapter 2: Language Constructs
  • Compatibility with Visual Basic
  • Variables
  • Constant, subroutine, function, label, and variable names
  • Declaring variables
  • Assigning values to variables
  • Boolean variables are True or False
  • Numeric variables
  • Integer variables
  • Long Integer variables
  • Currency variables
  • Single variables
  • Double variables
  • String variables contain text
  • Date variables
  • A new way to declare variables
  • Create your own data types
  • Object variables
  • Variant variables
  • Constants
  • The With statement
  • Arrays.
  • Changing the dimension of an array
  • The unexpected behavior of arrays
  • Subroutines and functions
  • Arguments
  • Pass by reference or by value
  • Optional arguments
  • Recursive routines
  • Scope of variables, subroutines, and functions
  • Local variables defined in a subroutine or function
  • Variables defined in a module
  • Global
  • Public and Dim
  • Private
  • Operators
  • Mathematical and string operators
  • Unary plus (+) and minus (
  • )
  • Exponentiation ()̂
  • Multiplication (*) and Division (/)
  • Remainder after division (MOD)
  • Integer division ( ).
  • Addition (+), subtraction (
  • ), and string concatenation (& and +)
  • Logical and bitwise operators
  • AND
  • OR
  • XOR
  • EQV
  • IMP
  • NOT
  • Comparison operators
  • Flow control
  • Define a label as a jump target
  • GoSub
  • GoTo
  • On GoTo and On GoSub
  • If Then Else
  • IIf
  • Choose
  • Select Case
  • Case expressions
  • If Case statements are easy, why are they frequently incorrect?
  • Writing correct Case expressions
  • While ... Wend
  • Do ... Loop
  • Exit the Do Loop
  • Which Do Loop should I use?
  • For ... Next
  • Exit Sub and Exit Function
  • Error handling using On Error.
  • Ignore errors with On Error Resume Next
  • Clear an error handler with On Error GoTo 0
  • Specify your own error handler with On Error GoTo Label
  • Error handlers-why use them?
  • 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.

Similar Items