.

OpenOffice Calc Macro Cookbook (Table of Contents)

TABLE OF CONTENTS
This OpenOffice Calc Macro CookBook
What is Calc
   Cell functions in Calc versus Excel   
   Calc API calls you need to know about   
      Macro code to access calc files
     ThisComponent method
     Creating a New Calc document method
     Opening an Existing Calc document method
Accessing sheets and Cells
   Accessing Cells
      Examples of Access Cells by CellName or by Column/Row
          Labeling Columns Example - By .getCellByPosition
          Labeling Columns Example - By .getCellRangeByName
          Labeling Columns Example – Adjusting Column Widths
          Labels with Fixed width Font
   Hiding Columns
   Incrementing column names – nxtcolLtr function
Dynamic Test Indicators in Calc   
   A Calc Cell Style Workaround

Custom Cell Functions
    Findnth (item within a) cell function
    Personhours cell function
       Array or cell reference?   
   Converting values with labels to standard Units   
   StatRollUp Cell Function    
      The formulaLocal Property – accessing the cell range string within the cell function call   
      AbsoluteName = changing functionality by cell function's location   

Writing Calc Subroutines with Dialogs   
   A Sheet Group Navigator
      Sheet Navigator Macro Example
      Our first Dialog
      Openoffice Bug or Feature   

  Custom Search Routines
     Client Search
         ClientSearch dialog and code
         Access to Dialog and calc sheet
         Basic Search Loop
            Aligned columns in a listbox
            Adding wildcards to the Search
     Birthday Search
        Access to Dialog and calc sheet
        Search Setup and Preload
        BirthDate Search Loop
           Adding a search option

Using desktop functions to cut and paste sheets
   dispatchURL
   CopySheetToNewDoc

The Classic MS Office Example – an interactive two listbox Dialog
   Finding an online solution and an API bug
   Loading ListBox1 (AddItem and AddItems methods)
   The => CommandButton(getSelectedItemPos method)
   The <= CommandButton
   Iterating Items within a ListBox

Appendix A - Dialog Controls Overview    

Appendix C – Client Search and Birthday Search Tools
   Client search Dialog box
   Birthday search Dialog box