Registration: Click here to register for this class.

Duration: 2 days

Prerequisites: Attendees should have professional development experience creating Windows applications with Visual Studio 2005 or Visual Studio 2008.

Hardware and Software Required: While we suggest attendees bring their laptops to class to work with, computers can be provided if necessary. Evaluation copies of FarPoint Spread for Windows Forms 4 will be provided for attendees to install.

Overview and Course Content: In this two-day, hands-on training class, software developers will learn how to fully leverage the capabilities of Spread for Windows Forms 4 by adding powerful, Excel-like spreadsheet functionality into their Windows applications. You will learn how to customize the look and feel of the spreadsheet, bind it to your data, code event handlers, import and export data with a variety of formats, and much more. Code examples and hands-on labs will be provided in both VB.NET and C#.

All of our classes are taught by industry expert software development professionals. Class sizes are limited to insure you receive the one-on-one attention needed to successfully learn the concepts presented.

Spread for Windows Introduction
Latest Version
New Features of 4.0
Product History
Distribution Issues
Where to Find Information & Help

Using A Spreadsheet Instead of a Grid
Differences in Functionality
When to Use Each
Application Ideas
Customer Showcase

Working With Spread 4.0 For Windows
Installation
Adding to a Project
Adding to a Form
Setting Properties
Overview of Spread Designer
Smart Tags Options
Working With Formulas
Coding Events

Working With Spread Designer
User Interface
Editors
Data Area
Design Features
Shapes

Capabilities of Spread for Windows
Import/Export
Databinding
Cell Types
Interactivity
Printing
Styles & Skins

Spread Object Model
Namespaces
Shortcut Objects
Sheets
Named Styles
Columns
Rows
Cells
Underlying Models

Spreadsheet Appearance
Overall Component
Sheet, Headers, Rows, Columns
Cells
Focus Indicators
Sheet Skins/Spread Skins
XP Themes

Cell Types
Editable Cell Types (from Currency to Text Cells)
Graphical Cell Types (from Buttons to Slider Cells)
Custom Cell Types
Best Practices in Using Cell Types

Working With Cell Data
Assigning Data to Cells
Validating Input
Copy/Move/Delete/Clear Cells

Working With Formulas
Cell References
Sheet References
Operators
Calling Functions
Using the Built-In Functions
Writing Custom Functions

Databinding
Binding to DataSets
Unbound Rows / Columns
Binding Controls to DataReaders
Custom Headers
Custom Cell Types
Custom Column Binding
Working with Hierarchical Data

File Operations
Saving Data to XML
Saving Data to Excel
Saving Data to HTML Tables
Saving Data to Text
Opening & Loading Files

Interactivity Features
Component Level
Rows & Columns
Cells
Cell Types

Adding Code to Respond to Events
Click Actions
Select Actions
Data Entry Actions
Sheet-level Actions
Interactivity Actions

Printing
Print Preview
Exporting PDFs
Adding Watermarks
Custom Headers & Footers

Performance Tips & Tricks From The FarPoint Development Team
Suspend Layout
Suspend Notification
AutoUpdateNotes
AllowCellOverflow