Limit search to available items
Book Cover
E-book
Author Pitonyak, Andrew (Andrew Douglas)

Title OpenOffice.org macros explained / by Andrew Pitonyak ; edited by C. Pearsall, Jean Weber, Amy Boyer
Published Whitefish Bay, WI : Hentzenwerke Pub., ©2004

Copies

Description 1 online resource (xxii, 476 pages) : illustrations
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
Summary 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 OpenOffice objects, facilitating the use of returned objects in the absence of sufficient documentation
Notes Includes index
English
Print version record
SUBJECT OpenOffice.org (Electronic resource) http://id.loc.gov/authorities/names/n2003091540
OpenOffice.org (Electronic resource) fast
Subject Integrated software.
Business -- Computer programs.
Business -- Computer programs
Integrated software
Form Electronic book
Author Pearsall, C.
Weber, Jean Hollis.
Boyer, Amy.
ISBN 9781930919518
1930919514
1930919522
9781930919525
1280544287
9781280544286
9786610544288
661054428X