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