Solution Books Table of Contents

- Just to give you an idea of what kinds of solutions and design topics I've explained and documented in my Solution Books, The Table of Contents for each book is listed below:

OpenOffice Calc Macro Solutions Book

OpenOffice Writer Macro Solutions Book

OpenOffice Draw Macro Solutions Book

Appendix A talks about dialog components and is a common appendix to all the books

Calc Solutions Table of Contents

My OpenOffice CookBooks

How did the series come about?

    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 B – Cell Formatting Fonts, Bolding, and Color Effects

Using the Debugger to find cell values

Left, Right, and Center Justify Cell text:

Setting Cell Font

Cell Font Height

Setting Font Color

Setting Background Color

Bolding Cell Text

Setting Line Wrapping

Underlining Cell Text

Two Underlining methods

Table Borders

Appendix C – Client Search and Birthday Search Tools

Client search Dialog box

Birthday search Dialog box

Back to top of Page

Writer Solutions Table of Contents

My OpenOffice CookBooks

How did the series come about?

This OpenOffifce Writer Macro CookBook 

Macro code to access writer files

ThisComponent method

Creating a Writer document method

Opening an Existing Write document method

Writer Document's collection paradigm

writer Tables - Mailing Labels Macro

Enumeration objects

Manipulating Documents with Cursors

Using text cursors

MoveCursorToText Example

MoveCursorToText

Automating Documentation

Module Mailer

LoadMailerOptionsDialog

Interactive Dialog Control routines

Basic MoveClient2MailList operation

Accessing Tables within Writer

Globals and main routine setup

Testing for Paragraphs and Tables

Retrieving Table Cell strings

Macro Book Construction

OpenOffice API calls to build writer documents

Using text cursors

BuildNewDoc code

LoadTempltFile

LoadContentAnHdrs

WriteContentLines

InsertingTableOfContent

Working with Frames – The Writer portion of the two listbox label making example

SOAP Example Extended

Dialog SoapSetup

Module Create Soaps

CopySheetToNewDoc(TempltType as Integer)

Appendix A - Dialog Controls Overview

Appendix B – Contract Automation Example and Code 59

Scrubbed Contract Document 61

Back to top of Page

Draw Solutions Table of Contents

My OpenOffice CookBooks 4

How did the series come about? 4

This OpenOffice Draw Macro CookBook 5

What is OpenOffice Draw 5

Vector versus Bitmap drawing systems 6

Draw and Impress Applications 6

Macro code to access draw files 6

ThisComponent method 7

Creating a New Draw document method 7

Opening an Existing Draw document method 7

Drawpages and Masterpages 8

DrawPages linked to MasterPage 8

Pages can have the same name 8

Draw Macro Basics 9

Portrait orientation and dimensions 9

Basic draw macro Routines 10

Adding Shapes to a page 10

Creating shapes routine 11

Erasing Shapes from the drawpage 15

Drawing Metadata 16

ConnectorShapes 16

Scanning a drawing for Metadata 18

Which Gluepoint? 21

How About Drawing Objects with Property Supports 23

Object Description Field 2

Appendix A - Dialog Controls Overview 28

Back to top of Page
 

Appendix A - Dialog Controls Overview

X-Ray or Debugger

Setting the Date in DateField

DateField Options

NumericField Control

CurrencyField Control

TimeField Control

ListBox Control

Aligned Columns in a ListBox

The Global Dialog reference

ComboBox Control

CheckBoxes and Option Controls

OptionButton Control

CheckBox Control

PatternField Control

ImageControl Controls

FixedLine Controls

ScrollBar Controls

ListBox and value list storage decisions

Dynamic ListBox item loading

Back to top of Page