عنوان
پدید آورنده
موضوع
رده
HF5548.4.O57 B35 2006eb
HF5548
.
4
.
O57
B35
2006eb
کتابخانه
محل استقرار
1847190995
9781847190994
1847190979
9781847190970
b740985
Learn OpenOffice.org spreadsheet macro programming :
[Book]
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.
Birmingham, U.K. :
Packt Pub.,
2006.
1 online resource (v, 203 pages) :
illustrations
From technologies to solutions
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
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
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
0
8
8
8
"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.
Safari Books Online
CL0500000078
Learn OpenOffice.org spreadsheet macro programming.
9781847190970
OpenOffice.org (Electronic resource)
OpenOffice.org (Electronic resource)
OpenOffice.org (Electronic resource)
Business-- Computer programs.
Electronic spreadsheets.
Integrated software.
Business-- Computer programs.
COMPUTERS-- Desktop Applications-- General.
Electronic spreadsheets.
Integrated software.
COM-- 084000
005
.
36
22
HF5548
.
4
.
O57
B35
2006eb
Bain, Mark Alexander.
Menon, Divya.
Pitonyak, Andrew.
Singh, Saurabh.
20201204015657.0
pn
مطالعه متن کتاب [Book]
Y
