Welcome to the Spread Developer Tour!

Adding Data | Saving Data | Working with Data | Working with Spreadsheets | Printing Spreadsheets | Customizing Columns and Rows | Working with Cells | Working with Cell Types | Binding to Databases | Customizing the Spreadsheet Display | Customizing User Interaction | Spread Designer Overview | 50 Spread Events | Rate Tour

Adding Data
	Add Formatted Data			Load a Text File
	Add Unformatted Data			Load an Excel-Formatted File
	Load a Spread File

Saving Data
	Save to a Spread File			Export to an aspx File
	Save to a Text File			Export to an XML File
	Save to a Buffer			Export to an Excel-Formatted File
	Save Data to an Array

Working with Data
	Return Formatted Data			Add Formulas to a Spreadsheet
	Return Unformatted Data			Allow Users to Enter Formulas
	Copy, Move, Swap, Delete Data			Create and Use Custom Functions
	Sort Data			Search for Data

Working with Spreadsheets
	Specify Which Elements Users Can Select			Use Virtual Mode
	Specify the Operation Mode

Printing Spreadsheets
	Preview Your Spreadsheet			Specify a Range of Pages
	Calculate the Number of Pages to Print			Specify Print Page Breaks
	Print the Portion with Data			Add Header and Footer Text
	Specify a Block of Cells as a Print Range			Print Multiple Items on the Same Page

Customizing Columns and Rows
	Insert/Delete Columns and Rows			Hide Columns and Rows
	Set the Width of Columns			Freeze Columns and Rows from Scrolling
	Set the Height of Rows			Set Odd/Even Row and Selection Colors
	Resize a Column to Fit the Widest Text			Specify Header Text
	Resize a Row to Fit the Tallest Text			Hide the Column and Row Headers
	Prevent Resizing of Columns and Rows			Display a Specified Number of Columns and Rows
	Set the Max. Number of Columns and Rows			Designate the Leftmost Column to Display
	Set the Number of Columns and Rows to the Last Column or Rows that Contains Data			Designate the Topmost Row to Display
				Providing Column IDs

Working with Cells
	Specify the Active Cell			Set Cell Background and Text Colors
	Display a Specified cell in the Specified Position			Set the Font
	Work with a Range of Cells			Specify the Color of Selected Cells
	Select Multiple Blocks using Code			Keep Edit Mode Permanently On
	Lock Cells from being Edited			Replace Text as You Edit
	Allow Cell Text to Overflow			Spanning Cells
	Display Ellipsis Points			Merging Cells
	Customize Cell Borders

Working with Cell Types
	Button Cells			Number Cells
	Checkbox Cells			Owner Drawn Cells
	Combobox Cells			Percent Cells
	Currency Cells			Picture Cells
	Date Cells			Static Text Cells
	Edit Cells			Time Cells
	Formatted PIC Cells

Binding to Databases
	Bind using ADO			Custom Headers
				Size Columns
	Display Selected Fields			Assign Cell Types

Customizing the Spreadsheet Display
	Customize Grid Lines			Hide Selections When the Spreadsheet Does Not Have the Focus
	Set the Grid Line / Gray Area Color			Prevent Flickering
	Change the 3D Appearance

Customizing User Interaction
	Allow Users to Drag and Drop Cells			Display Text Tips
	Allow Users To Sort Columns			Provide Cell Notes
	Display Scroll Bars Only When Needed			Customize the Enter Key Action
	Display Scroll Tips			Turn Off the Clipboard Shortcut Keys
	Specify the Pointer			Specify When Buttons Appear