کتابخانه مرکزی دانشگاه صنعتی شریف
    • [نمايش بزرگتر]
    • [نمايش کوچکتر]
  • صفحه 
    		 از  0
  • [صفحه قبل]
  • [صفحه بعد]
  • [نمایش تمام صفحه]
  • [بستن]
 
Learn OpenOffice.org spreadsheet macro programming : OOoBasic and Calc automation : a fast and friendly tutorial to writing macros and spreadsheet applications
Bain, Mark Alexander.

اطلاعات کتابشناختی

Learn OpenOffice.org spreadsheet macro programming : OOoBasic and Calc automation : a fast and friendly tutorial to writing macros and spreadsheet applications
Author :   Bain, Mark Alexander.
Publisher :   Packt Publishing Ltd.,
Pub. Year  :   2006
Subjects :   Integrated software. Electronic spreadsheets. Business -- Computer programs.
Call Number :   ‭HF 5548 .4 .O57 .B35 2006

جستجو در محتوا

ترتيب

فهرست مطالب

  • Learn OpenOffice.org Spreadsheet Macro Programming (1)
    • Table of Contents (8)
    • Preface (14)
    • Chapter 1: Working with OOo's Basic IDE (20)
      • Before We Start (20)
      • Accessing the OOo IDE (21)
        • Controls in IDE (24)
        • Navigating around the IDE (28)
          • The Object Catalog (28)
          • Select Macro (29)
          • The OpenOffice.org Basic Macro Organizer (31)
      • Designing Dialogs with the IDE (32)
      • Summary (37)
    • Chapter 2: Libraries, Modules, Subroutines, and Functions (38)
      • Using Libraries (38)
        • Managing Modules using Libraries (39)
        • Using Libraries in a Multi-User Environment (41)
        • Adding a Library to the OpenOffice.org Macros Area (46)
      • Using Modules (48)
      • Writing Macros (50)
        • Writing Subroutines (51)
          • Declare Variables (53)
          • Assign Values to the Variables (53)
          • Do the Work! (53)
          • Inputting Variables (53)
        • Writing Functions (54)
      • Getting more Information (54)
      • Subroutines and Functions in Different Libraries (55)
      • Summary (56)
    • Chapter 3: The OOo Object Model (58)
      • Why be Interested in UNOs? (59)
      • Overview of the OOo Object Model (59)
        • The Interface (60)
        • The Service (60)
        • The Module (61)
      • Starting to Work with UNOs (62)
        • Opening and Closing Spreadsheets Automatically (63)
      • Online Reference Material (67)
      • Services within Services (74)
        • Finding Included Services (75)
      • List of Everything You Want to Know About UNOs (76)
      • Summary (78)
    • Chapter 4: Using Macros with Spreadsheets (80)
      • Opening and Closing Spreadsheets (81)
      • Manipulating Spreadsheet Cells (82)
        • Using OOo's Built‑in Functions (84)
      • Named Worksheets and Cells (87)
        • Accessing Existing Named Worksheets and Cells (87)
        • Creating New Named Worksheets and Cells (88)
        • Deleting Worksheets (88)
      • Working with Multiple Spreadsheets (89)
      • Using Ranges of Cells (92)
      • Summary (92)
    • Chapter 5: Formatting your Spreadsheets (94)
      • The Most Basic Formatting—Column and Row Dimensions (95)
        • Optimizing Column Widths (96)
        • Optimizing Column Widths across a Whole Worksheet (96)
        • Setting Fixed Widths and Heights (97)
        • Hiding Columns (97)
      • Formatting the Printed Page (97)
        • Adding a Page Break (97)
        • Defining a Print Area (98)
        • Setting the Header and Footer (98)
        • Adding Page Numbers (99)
        • Setting the Page Size and Orientation (100)
      • Customizing Worksheet Names (102)
      • Updating the Document Information (102)
      • Formatting Cells and Ranges of Cells (104)
        • Changing Cell Styles (105)
        • Changing Cell Formats (106)
          • Cell Background Colors (106)
          • Text Colors (106)
          • Cell Fonts (107)
          • Character Heights (107)
          • The Underline (107)
          • Word Wrapping (108)
          • Number Formats (108)
      • Online Reference Material (110)
      • Summary (111)
    • Chapter 6: Working with Databases (112)
      • Accessing Databases (113)
        • Which Databases can We Use? (113)
        • Registering the Database as a OOo Data Source (114)
        • Viewing Registered Data Sources (115)
        • Connecting to a Database (116)
        • Accessing Database Tables (116)
          • Running Queries on the Tables (119)
      • Putting it All into a Spreadsheet (121)
        • Loading Data into Custom Worksheets (122)
      • Adding New Records to the Database (126)
      • Updating the Database (129)
      • Summary (131)
    • Chapter 7: Working with Other Documents (132)
      • The OpenOffice.org Chart (133)
        • Inserting a Simple Chart into a Spreadsheet (133)
        • Formatting OpenOffice.org Charts (135)
          • Chart size (136)
          • Chart Title (136)
          • Adding Chart Axis Labels (137)
          • Y Axis Text Orientation (137)
          • A fully Formatted Bar Chart (137)
          • Other Chart Types (139)
      • Using Documents from Other Sources (140)
        • Stock Market Analysis—Yahoo! Finance (141)
          • Importing an Historical CSV File from Yahoo! Finance (143)
          • Comparing Companies within Yahoo! Finance (147)
      • Processing Web Pages (149)
      • Summary (153)
    • Chapter 8: Developing Dialogs (156)
      • Using OpenOffice.org's Built-In Dialogs (156)
        • Customising Message Boxes (157)
        • Customising Input Boxes (158)
      • Developing your Own Dialogs (159)
        • Creating a Dialog (159)
        • Loading a Dialog (160)
        • Assigning Actions to a Dialog (161)
        • Using Information in a Dialog (165)
        • Populating Controls in a Dialog (166)
        • The Finished Dialog (168)
      • Finding Further Information (172)
      • Summary (172)
    • Chapter 9: Creating a Complete Application (174)
      • Making Macros and Dialogs Available to Everyone (174)
        • Creating a Global Library (176)
      • Using a Global Library to Automate OOo Calc (178)
        • Running Macros Automatically when Calc Opens (178)
      • Adding Macros to the OpenOffice.org Calc Menu (181)
        • Adding a Macro to the Menu Manually (181)
        • Distributing a Menu (185)
      • Keeping It All Hidden (187)
      • Running Macros from the Command Line (189)
        • Running Macros in Linux (189)
        • Running Macros in MS Windows (189)
      • Creating Background or Batch Processes (190)
        • Running Background Processes on Linux (190)
        • Running Background Processes on Windows (191)
      • Sending Emails (193)
      • Summary (195)
    • Chapter 10: Using Excel VBA (196)
      • The Current State (197)
        • OpenOffice.org's Excel VBA Support under MS Windows (197)
        • OpenOffice.org's Excel VBA Support under Linux (198)
      • Installing SUSE Linux 10.1 (199)
      • Building OpenOffice.org from Source (200)
        • Building on Linux (200)
        • Support your Local OpenOffice.org Issue (201)
      • Importing an Excel Spreadsheet that Contains Macros (202)
        • Opening Up an Excel Spreadsheet (203)
        • Viewing Code without VBA Support (203)
        • Viewing Code with VBA Support (203)
        • Closing your Spreadsheet (204)
      • Starting to Code with Excel VBA in Calc (205)
        • Combining VBA Code and OOo Basic Code (205)
      • Comparing VBA and OOo Basic Code (206)
        • Simplifying Code (206)
        • VBA—No Strings Attached (207)
        • Getting the Right Cell Position (208)
          • Using Named Cells and Ranges (209)
      • Further VBA Examples (210)
        • Using Active Cells and Cell Offsets (210)
        • Using the Workbooks Object (211)
        • Using the Worksheets Object (211)
      • Further Information (212)
      • Summary (212)
    • Index (214)
Loading...