| Document Type
|
:
|
BL
|
| Record Number
|
:
|
1021805
|
| Doc. No
|
:
|
b776175
|
| Main Entry
|
:
|
Pitonyak, Andrew, (Andrew Douglas)
|
| Title & Author
|
:
|
OpenOffice.org macros explained /\ by Andrew Pitonyak ; edited by C. Pearsall, Jean Weber, Amy Boyer.
|
| Publication Statement
|
:
|
Whitefish Bay, WI :: Hentzenwerke Pub.,, ©2004.
|
| Page. NO
|
:
|
1 online resource (xxii, 476 pages) :: illustrations
|
| ISBN
|
:
|
1280544287
|
|
|
:
|
: 1930919514
|
|
|
:
|
: 1930919522
|
|
|
:
|
: 9781280544286
|
|
|
:
|
: 9781930919518
|
|
|
:
|
: 9781930919525
|
|
|
:
|
1930919514
|
| Notes
|
:
|
Includes index.
|
| 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.
|
|
|
:
|
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.
|
|
|
:
|
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 (\).
|
|
|
:
|
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.
|
| Abstract
|
:
|
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.
|
| Subject
|
:
|
Business-- Computer programs.
|
| Subject
|
:
|
Integrated software.
|
| Subject
|
:
|
Business-- Computer programs.
|
| Subject
|
:
|
Integrated software.
|
| Subject
|
:
|
OpenOffice.org (Electronic resource)
|
|
|
:
|
OpenOffice.org (Electronic resource)
|
| Dewey Classification
|
:
|
005.5
|
| LC Classification
|
:
|
HF5548.4.O57P586 2004eb
|
| Added Entry
|
:
|
Boyer, Amy.
|
|
|
:
|
Pearsall, C.
|
|
|
:
|
Weber, Jean Hollis.
|