Working with the Control

Adding Data

• Adding Data
• Loading a Spread File
• Loading a Text File
• Loading an Excel-Formatted File
• Loading Data from a Buffer

Binding to Databases

• Connecting to a Database Using Default Settings
• Displaying Selected Fields in Columns
• Customizing Headers for Bound Sheets
• Sizing Columns in Bound Sheets
• Assigning Cell Types for Bound Sheets
• Specifying Sheet and Database Interaction
• Using Virtual Mode with Bound Sheets

Saving Data

• Overview of Saving Data
• Saving to a Spread File
• Saving to a Text File
• Saving to a Buffer
• Exporting to an Excel-Formatted File
• Exporting to an HTML File
• Exporting to an XML File
• Saving Data to an Array

Working with Data

• Copying Data
• Moving Data
• Swapping Data
• Deleting Data
• Sorting Data
• Searching for Data
• Entering Formulas
• Returning Data

Printing a Sheet

• Understanding Printing Features
• Printing from the Spread Designer
• Sending a Sheet to a Printer
• Calculating the Number of Pages to Print
• Specifying Print Options
• Printing the Portion of the Sheet with Data
• Specifying a Print Range
• Specifying Print Page Breaks
• Adding Header and Footer Text to Printed Pages
• Printing to an Owner-Defined Area on a Page

Previewing a Printed Sheet

• Previewing a Sheet
• Customizing the Page View
• Scaling the Preview Page
• Displaying Scroll Bars
• Customizing the Appearance of the Preview Area