Cargando…

Learn OpenOffice.org spreadsheet macro programming : OOoBasic and Calc automation : a fast and friendly tutorial to writing macros and spreadsheet applications /

"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,...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Bain, Mark Alexander
Otros Autores: Pitonyak, Andrew (Revisador), Menon, Divya (Editor ), Singh, Saurabh (Editor )
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham, U.K. : Packt Pub., 2006.
Colección:From technologies to solutions.
Temas:
Acceso en línea:Texto completo

MARC

LEADER 00000cam a2200000 a 4500
001 EBSCO_ocn251947166
003 OCoLC
005 20231017213018.0
006 m o d
007 cr zn|||||||||
008 080802s2006 enka o 001 0 eng d
040 |a NUI  |b eng  |e pn  |c NUI  |d N$T  |d IDEBK  |d UMI  |d OCLCQ  |d E7B  |d OCLCQ  |d B24X7  |d HEBIS  |d OCLCQ  |d DEBSZ  |d OCLCO  |d OCLCF  |d OCLCQ  |d COO  |d OCLCQ  |d AGLDB  |d LIV  |d OCLCQ  |d OCLCO  |d VNS  |d VTS  |d CEF  |d NLE  |d AU@  |d UKMGB  |d OCLCQ  |d STF  |d M8D  |d OCLCO  |d UKAHL  |d RDF  |d OCLCQ  |d VT2  |d BRF  |d OCLCO  |d OCLCQ  |d OCLCO 
015 |a GBB6G3675  |2 bnb 
016 7 |a 018011470  |2 Uk 
019 |a 302345724  |a 688507164  |a 765143025  |a 1058369706  |a 1097091817  |a 1129375955 
020 |a 9781847190994  |q (electronic bk.) 
020 |a 1847190995  |q (electronic bk.) 
020 |z 9781847190970 
020 |z 1847190979 
029 1 |a AU@  |b 000053250975 
029 1 |a DEBBG  |b BV042962907 
029 1 |a DEBSZ  |b 368476693 
029 1 |a DEBSZ  |b 422042749 
029 1 |a HEBIS  |b 291543693 
029 1 |a UKMGB  |b 018011470 
035 |a (OCoLC)251947166  |z (OCoLC)302345724  |z (OCoLC)688507164  |z (OCoLC)765143025  |z (OCoLC)1058369706  |z (OCoLC)1097091817  |z (OCoLC)1129375955 
037 |a CL0500000078  |b Safari Books Online 
050 4 |a HF5548.4.O57  |b B35 2006eb 
072 7 |a COM  |x 084000  |2 bisacsh 
082 0 4 |a 005.36  |2 22 
049 |a UAMI 
100 1 |a Bain, Mark Alexander. 
245 1 0 |a Learn OpenOffice.org spreadsheet macro programming :  |b OOoBasic and Calc automation : a fast and friendly tutorial to writing macros and spreadsheet applications /  |c Mark Alexander Bain ; reviewer, Andrew Pitonyak ; technical editors, Divya Menon, Saurabh Singh. 
260 |a Birmingham, U.K. :  |b Packt Pub.,  |c 2006. 
300 |a 1 online resource (v, 203 pages) :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
490 1 |a From technologies to solutions 
520 |a "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 
505 0 |a 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! 
505 8 |a 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 
505 8 |a 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 
505 8 |a 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 
590 |a eBooks on EBSCOhost  |b EBSCO eBook Subscription Academic Collection - Worldwide 
630 0 0 |a OpenOffice.org (Electronic resource) 
630 0 7 |a OpenOffice.org (Electronic resource)  |2 blmlsh 
630 0 7 |a OpenOffice.org (Electronic resource)  |2 fast 
650 0 |a Integrated software. 
650 0 |a Electronic spreadsheets. 
650 0 |a Business  |x Computer programs. 
650 6 |a Logiciels intégrés. 
650 6 |a Tableurs. 
650 7 |a COMPUTERS  |x Desktop Applications  |x General.  |2 bisacsh 
650 7 |a Business  |x Computer programs  |2 fast 
650 7 |a Electronic spreadsheets  |2 fast 
650 7 |a Integrated software  |2 fast 
700 1 |a Pitonyak, Andrew.  |4 rev 
700 1 |a Menon, Divya.  |4 edt 
700 1 |a Singh, Saurabh.  |4 edt 
776 0 8 |i Print version:  |a Bain, Mark Alexander.  |t Learn OpenOffice.org spreadsheet macro programming.  |d Birmingham, UK : Pakt, ©2006  |z 1847190979  |z 9781847190970  |w (OCoLC)162106945 
830 0 |a From technologies to solutions. 
856 4 0 |u https://ebsco.uam.elogim.com/login.aspx?direct=true&scope=site&db=nlebk&AN=258001  |z Texto completo 
936 |a BATCHLOAD 
938 |a Askews and Holts Library Services  |b ASKH  |n AH20274427 
938 |a Books 24x7  |b B247  |n bks00025592 
938 |a EBSCOhost  |b EBSC  |n 258001 
994 |a 92  |b IZTAP