عنوان
پدید آورنده
موضوع
رده
HF5548.4.O57 B35 2006eb
HF5548
.
4
.
O57
B35
2006eb
کتابخانه
محل استقرار
INTERNATIONAL STANDARD BOOK NUMBER
(Number (ISBN
1847190995
(Number (ISBN
9781847190994
Erroneous ISBN
1847190979
Erroneous ISBN
9781847190970
NATIONAL BIBLIOGRAPHY NUMBER
Number
b740985
TITLE AND STATEMENT OF RESPONSIBILITY
Title Proper
Learn OpenOffice.org spreadsheet macro programming :
General Material Designation
[Book]
Other Title Information
OOoBasic and Calc automation : a fast and friendly tutorial to writing macros and spreadsheet applications /
First Statement of Responsibility
Mark Alexander Bain ; reviewer, Andrew Pitonyak ; technical editors, Divya Menon, Saurabh Singh.
.PUBLICATION, DISTRIBUTION, ETC
Place of Publication, Distribution, etc.
Birmingham, U.K. :
Name of Publisher, Distributor, etc.
Packt Pub.,
Date of Publication, Distribution, etc.
2006.
PHYSICAL DESCRIPTION
Specific Material Designation and Extent of Item
1 online resource (v, 203 pages) :
Other Physical Details
illustrations
SERIES
Series Title
From technologies to solutions
CONTENTS NOTE
Text of Note
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!
Text of Note
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
Text of Note
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
Text of Note
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
SUMMARY OR ABSTRACT
Text of Note
"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.
ACQUISITION INFORMATION NOTE
Source for Acquisition/Subscription Address
Safari Books Online
Stock Number
CL0500000078
OTHER EDITION IN ANOTHER MEDIUM
Title
Learn OpenOffice.org spreadsheet macro programming.
International Standard Book Number
9781847190970
TITLE USED AS SUBJECT
OpenOffice.org (Electronic resource)
OpenOffice.org (Electronic resource)
OpenOffice.org (Electronic resource)
TOPICAL NAME USED AS SUBJECT
Business-- Computer programs.
Electronic spreadsheets.
Integrated software.
Business-- Computer programs.
COMPUTERS-- Desktop Applications-- General.
Electronic spreadsheets.
Integrated software.
(SUBJECT CATEGORY (Provisional
COM-- 084000
DEWEY DECIMAL CLASSIFICATION
Number
005
.
36
Edition
22
LIBRARY OF CONGRESS CLASSIFICATION
Class number
HF5548
.
4
.
O57
Book number
B35
2006eb
PERSONAL NAME - PRIMARY RESPONSIBILITY
Bain, Mark Alexander.
PERSONAL NAME - ALTERNATIVE RESPONSIBILITY
Menon, Divya.
Pitonyak, Andrew.
Singh, Saurabh.
ORIGINATING SOURCE
Date of Transaction
20201204015657.0
Cataloguing Rules (Descriptive Conventions))
pn
ELECTRONIC LOCATION AND ACCESS
Electronic name
مطالعه متن کتاب [Book]
Y
