List of Tables

Chapter 1: Getting Started

Table 1: Files and some directories in my user /basic directory.

Table 2: Files in the PitonyakDialogs library directory.

Chapter 2: Language Constructs

Table 1: Supported variable types and their initial values.

Table 2: Declaring simple variables .

Table 3: Examples of supported Def statements in OpenOffice.org.

Table 4: Numbers in different bases.

Table 5: A few guidelines for entering numbers in OOo Basic.

Table 6: Visual Basic-compatible string constants scheduled to be supported in OOo 2.0.

Table 7: Functions and subroutines related to dates and times.

Table 8: Defining an array is easy!

Table 9: Summary of subroutines and functions related to arrays.

Table 10: Life cycle of a variable defined in a module header.

Table 11: The scope of a Public variable depends on where it is declared.

Table 12: Operators supported by OpenOffice.org Basic.

Table 13: Truth table for logical and bitwise operators; 0 and 1 represent bit values, and True and False represent logical values.

Table 14: Case statements are frequently written incorrectly.

Table 15: Simple Case varieties.

Table 16: Incorrect examples from Table 14-now corrected.

Table 17: While and Until loops are very similar.

Table 18: Supported On Error forms.

Table 19: Error-related variables and functions.

Chapter 3: Numerical Routines

Table 1: Subroutines and functions related to numbers and numerical operations.

Table 2: Trigonometric functions supported by OOo Basic.

Table 3: Mathematical functions supported by OOo Basic.

Table 4: Convert to a numerical type.

Table 5: Output from Listing 12 with explanatory text.

Table 6: Output from Listing 14 with explanatory text.

Table 7: Remove the decimal portion of a floating-point number.

Table 8: String conversion functions.

Table 9: Arguments to Rnd, as they are supposed to work, but don't. The argument is always ignored.

Chapter 4: Array Routines

Table 1: Summary of subroutines and functions related to arrays.

Table 2: A Variant can contain an array, so these accomplish the same thing.

Chapter 5: Date Routines

Table 1: Functions and subroutines related to dates and times.

Table 2: Date and time functions in OOo Basic.

Table 3: Date and string conversion functions

Table 4: Locale affects the date.

Table 5: Date component extraction functions in OOo Basic.

Table 6: Elapsed time functions in OOo Basic.

Table 7: Numbers divisible by 6 and 9.

Chapter 6: String Routines

Table 1: These string-related functions are covered in this section.

Table 2: These string-related functions are covered in other chapters.

Table 3: The original 127 ASCII characters .

Table 4: Non-printable ASCII characters.

Table 5: Format specifiers for the Format function.

Table 6: Unsupported format specifiers.

Table 7: Converting data types with CStr.

Chapter 7: File Routines

Table 1: File functions in OOo Basic.

Table 2: URL examples.

Table 3: File and directory attributes.

Table 4: Arguments to FileCopy.

Table 5: File and directory attributes.

Table 6: Check attribute value 33 (100001) for each file property.

Table 7: Valid "For Mode" values and the resulting configuration if Access is not used.

Table 8: Valid Access ioModes.

Table 9: Valid protected keywords.

Table 10: Valid protected keywords.

Table 11: Summary of what the Put statement writes .

Chapter 8: Miscellaneous Routines

Table 1: Display- and color -related functions in OOo Basic.

Table 2: Return values from GetGuiType.

Table 3: Color representation in OpenOffice.org.

Table 4: OOo Basic functions related to flow control.

Table 5: Window styles for the Shell statement.

Table 6: DDE commands supported by OOo Basic.

Table 7: User input and output functions.

Table 8: Valid values for DialogType.

Table 9: Return values from MsgBox.

Table 10: Miscellaneous functions in OOo Basic.

Table 11: Miscellaneous functions in OOo Basic.

Table 12: Variable inspection functions in OOo Basic.

Table 13: Variable types and names .

Table 14: Deprecated and not-yet-implemented routines.

Chapter 9: Universal Network Objects

Table 1: Functions related to Universal Network Objects in OOo Basic.

Table 2: Methods defined by the com.sun.star.text.XTextRange interface.

Table 3: Initial inspection routines.

Table 4: XServicelnfo methods.

Table 5: Unique service names based on document type.

Table 6: UNO "dbg_"properties.

Chapter 10: UNO and the Dispatcher

Table 1: Arguments to executeDispatch.

Table 2: Global dispatch commands.

Table 3: Calc-specific dispatch commands.

Table 4: Chart-specific dispatch commands.

Table 5: Draw-specific dispatch commands.

Table 6: Math-specific dispatch commands.

Table 7: Writer-specific dispatch commands.

Chapter 11: StarDesktop

Table 1: com.sun.star.frame.FrameSearchFlag constants.

Table 2: Some useful properties in the com.sun.star.document.Documentlnfo service.

Table 3: URLS for creating new documents.

Table 4: Special frame names.

Table 5: Valid named parameters for loading and storing documents.

Table 6: com.sun.star.document.MacroExecutionMode constants.

Table 7: CSV field format values.

Table 8: Writer import and export filter names.

Table 9: Writer Web import and export filter names.

Table 10: Writer Global import and export filter names.

Table 11: Calc import and export filter names.

Table 12: Draw import and export filter names.

Table 13: Impress import and export filter names.

Table 14: Chart import and export filter names.

Table 15: Math import and export filter names.

Table 16: Graphics import and export filter names.

Chapter 12: Generic Document Methods

Table 1: Unique services that identify the document's type.

Table 2: Interfaces supported by more than one document type.

Table 3: Object methods defined by the interface XPropertySet.

Table 4: Object methods defined by the interface XDocumentlnfo.

Table 5: Object methods defined by the interface XCloseBroadcaster.

Table 6: Object methods defined by the interface XDrawPages.

Table 7: Object methods defined by the interface com.sun.star.frame.XModel.

Table 8: Object properties defined by the service MediaDescriptor.

Table 9: Object methods defined by the service com.sun.star. frame.XStorable.

Table 10: Difference between storeToURL and storeAsURL.

Table 11: Object methods defined in the com.sun. star.style.Style service.

Table 12: Locale language codes, alphabetized by code.

Table 13: Locale country codes, capitalized by country.

Table 14: Object methods defined by com.sun.star.view.XPrintable.

Table 15: Properties defined by the service com.sun.star.view.PrinterDescriptor.

Table 16: Properties defined by the com.sun.star.view.PrintOptions service.

Table 17: Methods defined by the com.sun.star.text.XPagePrintable interface.

Table 18: Properties used by the com.sun.star.text.XPagePrintable interface.

Table 19: Properties used by the com.sun.star.sheet.XPrintAreas interface.

Table 20: Common document properties in com.sun.star.document.Settings.

Table 21: Specific document settings service types.

Table 22: Properties defined by the com.sun.star.text.PrintSettings service.

Chapter 13: Writer Documents

Table 1: Interfaces supported by text documents.

Table 2: Methods defined by the com.sun.text.XText interface.

Table 3: Methods defined by the com.sun.text.XTextRange interface.

Table 4: Properties supported by the com.sun.star.text. TextContent service.

Table 5: Properties supported by the com.sun.style.ParagraphProperties service.

Table 6: Paragraph styles used for formatting code examples in this book.

Table 7: Properties supported by the com. sun. style. CharacterProperties service.

Table 8: Properties supported by the com.sun.text.TextPortion service.

Table 9: In general, view cursors are not related to text ranges or XTextCursor.

Table 10: Object methods related to view cursors.

Table 11: Text cursor interfaces all implement the XTextCursor interface.

Table 12: Object methods related to text cursors.

Table 13: Methods defined by the com.sun.star.text.XTextRangeCompare interface.

Table 14: Properties of the com.sun.star.util.SearchDescriptor service.

Table 15: Methods defined by the com.sun.star.util.XSearchable interface.

Table 16: Supported regular expression characters.

Table 17: Content contained in a text document.

Table 18: Object methods supported by text tables.

Table 19: Properties supported by the com.sun.star.text.TextTable service.

Table 20: Rows are labeled numerically ; columns are labeled alphabetically .

Table 21: When a row or column is split or merged, cell names become more complicated.

Table 22: Methods defined by the com.sun.star.table.XCell interface.

Table 23: Methods defined by the com.sun.star.text.XTextTableCursor interface.

Table 24: Text field interfaces starting with com.sun.star.text.TextField.

Table 25: Constants defined by com.sun.star.style.NumberingType.

Table 26: Text field interfaces starting with com.sun.star.text.FieldMaster.

Table 27: Properties defined by the service com.sun.star.text.FieldMaster.

Chapter 14: Calc Documents

Table 1: Some interfaces supported by Calc documents.

Table 2: Methods implemented by the com.sun.star.sheet.Spreadsheets service.

Table 3: Properties of the com.sun.star.table.CellAddress structure.

Table 4: Properties of the com.sun.star.table.BorderLine structure.

Table 5: Properties of the com.sun.star.table.TableBorder structure.

Table 6: Properties supported by the com.sun.star.table.CellProperties service.

Table 7: Properties supported by the com.sun.star.sheet.SheetCell service.

Table 8: Methods implemented by the com.sun.star.sheet.CellAnnotation service.

Table 9: Properties of the com.sun.star.table.CellRangeAddress structure.

Table 10: Methods defined by the com.sun.star.table.XSheetCellRanges interface.

Table 11: Validation types defined by the com.sun.star.sheet.ValidationType enum.

Table 12: Validation alerts defined by the com.sun.star.sheet.ValidationAlertStyle enum.

Table 13: Conditions defined by the com.sun.star.sheet.ConditionOperator enum.

Table 14: Properties supported by the com.sun.star.sheet.TableValidation service.

Table 15: Methods supported by the com.sun.star.sheet.TableValidation service.

Table 16: Methods supported by the com.sun.star.table.XCellRange interface.

Table 17: Values in the com.sun.star.sheet.CellFlags constant group .

Table 18: Methods to query a cell range.

Table 19: The formulas and values set by Listing 14.

Table 20: Individual row and column properties.

Table 21: The com.sun.star.sheet.GeneralFunction enumeration.

Table 22: The com.sun.star.sheet.FHIDirection enumeration.

Table 23: The com.sun.star.sheet.FillMode enumeration.

Table 24: The com.sun.star.sheetFillDateMode enumeration.

Table 25: A simple formula in column I.

Table 26: The com.sun.star.sheet.TableOperationMode enumeration

Table 27: The com.sun.star.table. TableSortFieldType enumeration.

Table 28: The com.sun.star.table.TableSortField structure.

Table 29: The old way to specify a sort using a SortDescriptor.

Table 30: The new way to specify a sort using a SortDescriptor2.

Table 31: Interfaces implemented by the com.sun.star.sheet.Spreadsheet service.

Table 32: Values supported by the com.sun.star.sheet.SheetLinkMode enumeration.

Table 33: Values supported by the com.sun.star.sheet.SheetLinkMode enumeration.

Table 34: Methods supported by the com.sun.star.sheet.XSheetAuditing interface.

Table 35: Values defined by the com.sun.star.table.TableOrientation enumeration.

Table 36: Methods supported by the com.sun.star.sheet.XSheetOutline interface.

Table 37: Values defined by the com.sun.star.sheet.CellInsertMode enumeration.

Table 38: Methods defined by the com.sun.star.sheet.XDataPilotTables interface.

Table 39: Values defined by the com.sun.star.sheet.DataPilotFieldOrientation enumeration.

Table 40: Values defined by the com.sun.star.sheet.FilterOperator enumeration.

Table 41: Values defined by the com.sun.star.sheet.FilterConnection enumeration.

Table 42: Properties in the com.sun.star.sheet.TableFilterField structure.

Table 43: Properties defined by the com.sun.star.sheet.SheetFilterDescriptor service.

Table 44: Methods defined by the com.sun.star.sheet.XDataPilotDescriptor interface.

Table 45: Primary components supported by the com.sun.star.sheet.SheetCellCursor service.

Table 46: Primary methods supported by the com.sun.star.sheet.SheetCellCursor service.

Table 47: Constants defined by the com.sun.star.sheet.NamedRangeFlag constant group.

Table 48: Methods implemented by the com. sun. star.sheet.NamedRange service.

Table 49: Enumerated values defined by the com.sun.star.sheet.Border enumeration.

Table 50: Methods defined by the com.sun.star.sheet.XCalculatable interface.

Table 51: Return values for different arguments to WahooFunc (assume cell E9 contains 2).

Table 52: Methods supported by the current controller not already discussed.

Table 53: Properties supported by the current controller not already discussed.

Chapter 15: Draw and Impress Documents

Table 1: Methods supported by the com.sun.star.drawing.XDrawPages interface.

Table 2: Properties defined by the com.sun.star.drawing.GenericDrawPage service.

Table 3: Shape types supported by OOo.

Table 4: Methods supported by Shape objects.

Table 5: Properties defined by the com.sun.star.drawing.Shape service.

Table 6: Which shapes support which service.

Table 7: Properties defined by the com.sun.star.drawing.TextProperties service.

Table 8: Properties defined by the com.sun.star.drawing.LineProperties service.

Table 9: Properties defined by the com.sun.star.drawing.FillProperties service.

Table 10: Properties defined by the com.sun.star.drawing.ShadowProperties service.

Table 11: Properties in the com.sun.star.drawing.PolyPolygonDescriptor service.

Table 12: Values defined by the com.sun.star.drawing.PolygonKind enumeration.

Table 13: Values defined by the com.sun.star.drawing.CircleKind enumeration.

Table 14: Properties in the com.sun.star.drawing.PolyPolygonBezierDescriptor service.

Table 15: Values in the com.sun.star.drawing.PolygonFlags enumeration.

Table 16: Properties in the com.sun.star.drawing.GluePoint2 structure.

Table 17: Properties in the com.sun.star.drawing.ConnectorShape service.

Table 18: Properties in the com.sun.star.drawing.ConnectorType enumeraiton.

Table 19: Some methods supported by the com. sun. star. form. Forms service.

Table 20: Control components that can be added to forms.

Table 21: Properties defined by the the com.sun. star.presentation. Presentation service.

Table 22: Some methods supported by the XCustomPresentationSupplier interface.

Table 23: Properties defined by the com.sun.star.presentation.DrawPage service.

Table 24: Values defined by the com.sun.star.presentation.FadeEffect enumeration.

Table 25: Properties defined by the com.sun.star.presentation.Shape service.

Table 26: Values defined by the com.sun.star.presentation.AnimationEffect enumeration.

Table 27: Values defined by the com.sun.star.presentation.ClickAction enumeration.

Chapter 16: Library Management

Table 1: Methods supported by library container objects.

Table 2: Methods supported by library objects.

Table 3: Obtain the module aMod from the library TestLib contained in a document.

Chapter 17: Dialogs and Controls

Table 1: Methods defined by the com.sun.star.lang.XComponent interface.

Table 2: Methods defined by the com.sun.star.awt.XControl interface.

Table 3: Constants defined by the com.sun.star.awt.PosSize constant group.

Table 4: Methods defined by the com.sun.star.awt.XWindow interface.

Table 5: Methods defined by the com.sun.star.awt.XView interface.

Table 6: Methods defined by the com.sun.star.awt.XDialog interface.

Table 7: Methods defined by the com.sun.star.awt.XTopWindow interface.

Table 8: Methods defined by the com.sun.star.awt.XControlContainer interface.

Table 9: Properties defined by the com.sun.star.awt.UnoControlDialogModel service.

Table 10: Properties in the com.sun.star.awt.UnoControlDialogElement service.

Table 11: Controls and their models defined in the com.sun.star.awt module.

Table 12: Values defined by the com.sun.star.awt.PushButtonType enumeration.

Table 13: Constants defined by the com.sun.star.awt.ImageAlign constant group.

Table 14: Properties defined by the com.sun.star.awt.UnoControlButtonModel service.

Table 15: Properties defined by com.sun.star.awt.UnoControlCheckBoxModel.

Table 16: Properties in the com.sun.star.awt.UnoControlRadioButtonModel.

Table 17: Properties defined by com.sun.star.awt.UnoControlComboBoxModel.

Table 18: Extra utility methods supported by the combo box control.

Table 19: Properties defined by the com.sun.star.awt.UnoControlEditModel service.

Table 20: Properties in the com.sun.star.awt.Selection structure.

Table 21: Methods defined by the com.sun.star.awt.XTextComponent interface.

Table 22: Properties in the com.sun.star.awt.UnoControlCurrencyFieldModel service.

Table 23: Methods defined by the the com.sun.star.awt.XSpinField interface.

Table 24: Date input formats supported by a Date control.

Table 25: Properties in the com.sun.star.awt.UnoControlDateFieldModel service.

Table 26: Methods in the com.sun.star.awt.UnoControlDateField interface.

Table 27: Time input formats supported by a time control.

Table 28: Properties in the com.sun.star.awt.UnoControlTimeFieldModel service.

Table 29: Properties in the com.sun.star.awt.UnoControlFormattedFieldModel service.

Table 30: Constants in the com.sun.star.util.NumberFormat constant group.

Table 31: Properties in the com.sun.star.awt.UnoControlFormattedFieldModel service.

Table 32: Edit mask characters supported by the pattern control.

Table 33: Properties in the com.sun.star.awt.UnoControlPatternFieldModel service.

Table 34: Properties in the com.sun.star.awt.UnoControlFixedTextFieldModel service.

Table 35: Properties in the com.sun.star.awt.UnoControlFileControlModel service.

Table 36: Properties in the com.sun.star.awt.UnoControllmageControlModel service.

Table 37: Properties in the com.sun.star.awt.UnoControlProgressBarModel service.

Table 38: Properties in the com.sun.star.awt.UnoControlListBoxModel service.

Table 39: Methods defined by the com.sun.star.awt.XListBox interface.

Table 40: Properties in the com.sun.star.awt.UnoControlScrollBarModel service.