Learn OpenOffice.org spreadsheet macro programming : OOoBasic and Calc automation : a fast and friendly tutorial to writing macros and spreadsheet applications / Mark Alexander Bain ; reviewer, Andrew Pitonyak ; technical editors, Divya Menon, Saurabh Singh.

"This book teaches the OOoBasic language and the Calc object model, so that you can manipulate spreadsheets and data from within your programs. You will also see how to create dialog boxes and windows for friendly user interfaces, and how to integrate your spreadsheets with other applications, for example writing spreadsheet data to a document, or capturing data from a database, and using the spreadsheet for generating advanced calculations and reports"--Resource description page.

Cover; Table of Contents; Preface; Chapter 1: Working with OOo's Basic IDE; Before We Start; Accessing the OOo IDE; Controls in IDE; Navigating around the IDE; The Object Catalog; Select Macro; The OpenOffice.org Basic Macro Organizer; Designing Dialogs with the IDE; Summary; Chapter 2: Libraries, Modules, Subroutines, and Functions; Using Libraries; Managing Modules using Libraries; Using Libraries in a Multi-User Environment; Adding a Library to the OpenOffice.org Macros Area; Using Modules; Writing Macros; Writing Subroutines; Declare Variables; Assign Values to the Variables; Do the Work!

Inputting VariablesWriting Functions; Getting more Information; Subroutines and Functions in Different Libraries; Summary; Chapter 3: The OOo Object Model; Why be Interested in UNOs?; Overview of the OOo Object Model; The Interface; The Service; The Module; Starting to Work with UNOs; Opening and Closing Spreadsheets Automatically; Online Reference Material; Services within Services; Finding Included Services; List of Everything You Want to Know About UNOs; Summary; Chapter 4: Using Macros with Spreadsheets; Opening and Closing Spreadsheets; Manipulating Spreadsheet Cells

Setting the Page Size and OrientationCustomizing Worksheet Names; Updating the Document Information; Formatting Cells and Ranges of Cells; Changing Cell Styles; Changing Cell Formats; Cell Background Colors; Text Colors; Cell Fonts; Character Heights; The Underline; Word Wrapping; Number Formats; Online Reference Material; Summary; Chapter 6: Working with Databases; Accessing Databases; Which Databases can We Use?; Registering the Database as a OOo Data Source; Viewing Registered Data Sources; Connecting to a Database; Accessing Database Tables; Running Queries on the Tables

Putting it All into a SpreadsheetLoading Data into Custom Worksheets; Adding New Records to the Database; Updating the Database; Summary; Chapter 7: Working with Other Documents; The OpenOffice.org Chart; Inserting a Simple Chart into a Spreadsheet; Formatting OpenOffice.org Charts; Chart size; Chart Title; Adding Chart Axis Labels; Y Axis Text Orientation; A fully Formatted Bar Chart; Other Chart Types; Using Documents from Other Sources; Stock Market Analysis-Yahoo! Finance; Importing an Historical CSV File from Yahoo! Finance; Comparing Companies within Yahoo! Finance; Processing Web Pages

eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - Worldwide