List of Figures

Chapter 1: Getting Started

Figure 1: Use the Macro dialog to create new macros and organize libraries.

Figure 2: Use the Macro Organizer dialog to organize modules.

Figure 3: Use the Macro Organizer dialog to organize libraries.

Figure 4: Choose a meaningful name for the library.

Figure 5: The document now contains the library named TestLibrary.

Figure 6: The TestLibrary contains one module named Module 1.

Figure 7: Choose a meaningful module name.

Figure 8: Select a specific macro.

Figure 9: Develop macros in the IDE.

Figure 10: Click the Compile icon to find syntax errors such as a missing double quotation mark.

Figure 11: Click OK to close the dialog.

Figure 12: You just opened an OpenOffice.org document that contains a macro.

Figure 13: The IDE included with OpenOffice.org is very capable.

Figure 14: Manually edit and configure breakpoints.

Figure 15: You can browse the available libraries and modules in the Objects window.

Figure 16: The Macro dialog and the Macro Organizer dialog show available libraries and modules.

Figure 17: Use the Macro Organizer to create, add, and delete libraries.

Figure 18: Use the Append Libraries dialog to select the libraries to add.

Figure 19: It doesn't matter which file you choose; both are appended.

Chapter 2: Language Constructs

Figure 1: Why is line 4 an Integer and line 7 a Double rather than a Long?

Figure 2: There are different variable types in the same array.

Figure 3: Assigning an array assigns a reference.

Figure 4: Assigning an array assigns a reference.

Figure 5: Assigning an array assigns a reference.

Figure 6: Passing by reference allows changes to be passed back to the caller.

Figure 7: In rare cases, non-Variant optional arguments fail.

Figure 8: Static variables maintain their values between calls in Listing 29.

Figure 9: Using the MOD operator.

Figure 10: Using the AND operator.

Figure 11: Using the OR operator.

Figure 12: The XOR operator.

Figure 13: Using the EQV operator.

Figure 14: Using the IMP operator.

Figure 15: The computed GoSub jumps to Sub2 and the GoTo jumps to Line1.

Figure 16: The random array is sorted by using a modified bubble sort .

Figure 17: Walk the call stack to find a handler.

Figure 18: The last error handler declared is used.

Figure 19: The last error handler declared is used.

Chapter 3: Numerical Routines

Figure 1: A right triangle has one angle at 90 degrees.

Figure 2: Use the trigonometric functions to solve problems with triangles .

Figure 3: Convert a whole number to hexadecimal, octal, and binary.

Chapter 4: Array Routines

Figure 1: Use ReDim to change the dimensions of an array.

Figure 2: Use proper error handling to determine the dimension of the array.

Chapter 5: Date Routines

Figure 1: What appear to be invalid times are valid.

Figure 2: Use WeekDay to determine the day of the week.

Figure 3: GetSystemTicks has better resolution than Now.

Figure 4: The improvement is about 10 percent.

Chapter 6: String Routines

Figure 1: A string followed by its corresponding ASCII values- A=65, B=66, C=34, and so on ...

Figure 2: RSet and LSet justify strings.

Chapter 7: File Routines

Figure 1: CurDir returns the current directory.

Figure 2: You can learn a lot about a file by using the file-inspection functions.

Figure 3: Directory listing of the current directory.

Figure 4: Information based on a file number.

Figure 5: Input cannot read time delimited with "#".

Figure 6: Use Get and Put to read and write binary files.

Chapter 8: Miscellaneous Routines

Figure 1: Number of pixels per inch on my computer.

Figure 2: The Spc function returns a string with spaces.

Figure 3: This simple MsgBox dialog contains only an OK button.

Figure 4: Fancy MsgBox with an icon and multiple buttons .

Figure 5: InputBox with default text selected.

Figure 6: Error information must be saved if it is used after resetting the error handler.

Figure 7: Variable types, lengths, and names .

Figure 8: Types, lengths, and names for array variables.

Chapter 9: Universal Network Objects

Figure 1: A few properties in a Writer document; one dialog of many displayed.

Figure 2: Eight character styles used in the current document.

Figure 3: All the currently open documents.

Figure 4: Dialog and Basic libraries in the current document.

Figure 5: Ignore the queryInterface method.

Figure 6: The variable is an array of strings

Figure 7: The variable is a Writer document.

Chapter 11: StarDesktop

Figure 1: Titles of top-level frames .

Figure 2: File names of currently open documents.

Chapter 12: Generic Document Methods

Figure 1: The first 10 properties of ThisComponent.

Figure 2: The user -information fields in the current document.

Figure 3: Events supported by ThisComponent.

Figure 4: Jump (link) targets in ThisComponent.

Figure 5: View data for a document.

Figure 6: These lines drawn in a Draw document overlap.

Figure 7: These lines drawn in a Writer document are treated as characters .

Figure 8: Properties returned by the getArgs() object method.

Figure 9: The style families in one of my Writer documents.

Figure 10: Paragraph styles used in a Writer document.

Figure 11: Information from the page style.

Figure 12: Properties of the default printer.

Figure 13: Page print properties of a Writer document.

Figure 14: Some Writer document settings.

Chapter 13: Writer Documents

Figure 1: Tables contained in a document, by index and named access.

Figure 2: Text fields in the current document.

Figure 3: Text fields in the current document.

Chapter 14: Calc Documents

Figure 1: Values returned by getType(), getString(), getValue(), and getFormula() for different types of content.

Figure 2: Query a range of cells to find references, dependencies, and similarities.

Figure 3: Output from Listing 14 with "column differences" highlighted.

Figure 4: Merging cells causes the top-left cell to use the entire merged area.

Figure 5: The nonempty cells are displayed from rows 6 through 8.

Figure 6: The two methods group the data differently.

Figure 7: Sort descriptor attributes.

Figure 8: One level of precedents .

Figure 9: Two levels of precedents.

Figure 10: Data used in the data pilot example.

Figure 11: The macro in Listing 35 inserts the data pilot table immediately after the source data.

Chapter 15: Draw and Impress Documents

Figure 1: Twenty lines in an Impress document.

Figure 2: Twenty lines bound together are connected with a line.

Figure 3: By default, measure shapes show the actual size -you can override this.

Figure 4: Bezier shape using a gradient fill.

Figure 5: Notice the different shadows and that box 2 has rounded corners.

Figure 6: The rectangles with dashed lines are the original rectangles.

Figure 7: A single PolyLineShape produces two shapes that are not connected.

Figure 8: The PolyPolygonShape produces a closed-shape version of the PolyLineShape.

Figure 9: Two shapes that are drawn in the same way-but with different, nearly identical shape types that have different default values-produce different output.

Figure 10: The size parameters determine shape; other parameters set position and orientation.

Figure 11: Each supported CircleKind drawn in order.

Figure 12: Notice how the control points influence the curve.

Figure 13: Notice the different connector types.

Figure 14: Custom glue points- Connectors start in the middle of the rectangles.

Figure 15: Graphics styles supported by presentation documents.

Figure 16: The default arrow style draws an arrow from the end shape to the start shape.

Chapter 16: Library Management

Figure 1: Creating a new library in the "soffice" aplication library container.

Figure 2: Module1 is automatically created by the dialog organizer.

Figure 3: Although the dialog library exists, it contains no dialogs.

Chapter 17: Dialogs and Controls

Figure 1: Right-click the module tab and select Insert BASIC Dialog.

Figure 2: Click the Controls button in the toolbar to open the design tools window.

Figure 3: Set the properties for the dialog.

Figure 4: Events for a command button.

Figure 5: Assign macros to event handlers.

Figure 6: Services that the dialog model can create.

Figure 7: OOMESample dialog referred to throughout this chapter.

Figure 8: The Object Inspector dialog.

Chapter 18: Sources of Information

Figure 1: The included help is very good.