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.