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 -- 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 -- Display and color -- Determine the GUI type -- Determine pixel size (in twips) -- Use color functions -- Flow control -- Return an argument -- Pause or end the macro -- Dynamic Link Libraries -- Calling external applications -- Dynamic Data Exchange -- User input and output -- Simple output -- Multi-line output -- Prompting for input -- 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 -- Your first listener -- A complete listener: selection change listener -- Creating a UNO dialog -- Conclusion -- Chapter 10: UNO and the Dispatcher -- The environment -- Two different methods to control OOo -- Finding dispatch commands -- 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 XIndexAccess interface -- Find frames with FrameSearchFlag constants -- The XEventBroadcaster interface -- The XDesktop interface -- Closing the desktop and contained components -- Enumerating components using XEnumerationAccess -- Current component -- Current frame.

The XComponentLoader interface -- Named parameters -- Loading a template -- Enabling macros while loading a document -- Importing and exporting non-OpenOffice.org documents -- Module Writer -- Module Writer Web -- Module Writer Global -- Module Calc -- Module Draw -- Module Impress -- Module Chart -- Module Math -- Module Graphics -- Error handling while loading a document -- 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 -- Printing Writer documents -- Printing Calc documents -- Creating services: XMultiServiceFactory -- Document settings -- Conclusion -- Chapter 13: Writer Documents -- Basic building blocks -- Primary text content: the XText interface -- Text ranges: the XTextRange interface -- Inserting simple text -- Text content: the TextContent service -- Enumerating paragraphs -- Paragraph properties -- Insert a page break -- Set the paragraph style -- Character properties -- Enumerating text sections (paragraph portions) -- Cursors -- View cursors -- Text (non-view) cursors -- Using cursors to traverse text -- Accessing content using cursors -- Selected text -- Is text selected? -- Selected text: Which end is which? -- Selected text framework -- Remove empty spaces and lines: A larger example -- What is white space? -- Rank characters for deletion -- Use the standard framework -- The worker macro -- Selected text, closing thoughts -- Search and replace.

Searching selected text or a specified range -- Searching for all occurrences -- Searching and replacing -- Advanced search and replace -- Text content -- Text tables -- Using the correct text object -- Methods and properties -- Simple and complex tables -- Tables contain cells -- Using a table cursor -- Text fields -- Text master fields -- Creating and adding text fields -- Bookmarks -- Conclusion -- Chapter 14: Calc Documents -- Accessing sheets -- Sheet cells contain the data -- Cell address -- Cell data -- Cell properties -- Cell annotations -- Sheet cell ranges -- Sheet cell range properties -- Validation settings -- Conditional formatting -- Sheet cell range services -- Retrieving cells and ranges -- Querying cells -- Finding non-empty cells in a range -- Using complex queries -- Searching and replacing -- Merging cells -- Retrieving, inserting, and deleting columns and rows -- Retrieving and setting data as an array -- Computing functions on a range -- Clearing cells and cell ranges -- Automatic data fill -- Array formulas -- Computing multiple functions on a range -- Cells with the same formatting -- Sorting -- Sheets -- Linking to an external spreadsheet -- Finding dependencies by using auditing functions -- Outlines -- Copying, moving, and inserting cells -- Data pilot tables -- A data pilot example -- Generating the data -- Creating the data pilot table -- Manipulating data pilot tables -- Data pilot fields -- Filtering data pilot fields -- Tables -- Sheet cursors -- Calc documents -- Named ranges -- Protecting documents and sheets -- Controlling recalculation -- Using Goal Seek -- Writing your own spreadsheet functions -- Using the current controller -- Selected cells -- Enumerating the selected cells -- Selecting text -- The active cell -- General functionality -- Converting Excel macros -- Control Calc from Microsoft Office.

A better macro recorder.