Objective Grid for .NET® User’s Guide
Chapter 1 Introduction to Objective Grid for .NET®
Welcome to Objective Grid for .NET
Product Features
Supported Platforms
Distributing Objective Grid for .NET Applications
Naming Conventions
Getting started with Objective Grid for .NET
Prerequisites
Building the assemblies
Running the examples
Deploying your application
Using This Manual
Common Terms
Getting Help
Documentation
Tutorials and Samples
Knowledge Base
Professional Services
Technical Support
Chapter 2 Design Overview
Introduction
Description of the Core Classes
The Cell Class
Public Methods
Public Properties
The Range Class
Public Methods
Public Properties
The Style Class
Public Methods
Public Properties
Using the Style Class Efficiently
The Param Class
The GridControl Class
Code Generated by the Windows Forms Designer
Events
Public Methods
Public Properties
Public Events
Predefined Controls
Formula Engine Support
Enabling Formula Support
Mathematical Functions
Statistical Functions
Conditional Statistical Functions
String Functions
Logic Functions
Financial Functions
Date and Time Functions
Miscellaneous Functions
Embedded Tools
Choosing a Grid Type
Chapter 3 Using Objective Grid for .NET
Introduction
Basic Grid Tasks
Task 1: Changing the Number of Rows and Columns in the Grid
Task 2: Changing the Number of Rows and Columns after Initialization
Task 3: Storing Data in the Grid
Task 4: Reading Data from the Grid
Cell Types
Task 1: Modify the Attribute of a Cell by Embedding a Control
Task 2: Disabling Cells
Task 3: Making a Cell Readonly
Task 4: Covering Cells
Task 5: Merging Cells
Columns and Rows
Task 1: Inserting New Rows and Columns
Task 2: Removing Rows and Columns
Task 3: Hiding Rows and Columns
Task 4: Freezing Rows and Columns
Cell and Window Coordinates
Sorting a Grid
Chapter 4 Virtual Grids
Background
Reasons for Using Virtual Grids
Using Virtual Grids
Advanced Virtual Grid Topics
Chapter 5 .NET Cell Controls
Introduction
Overview
Features
.NET Controls Can Be Used as Cell Editors
Memory Resources Are Conserved
Style Manipulation Code Is Usually Not Needed
Cell Control Behavior Can Be Monitored and Customized
Cell Editing Events Can Be Monitored
Limitations
Some Controls Cannot Be Sized Vertically
CellControl Behavior Must Be Customized Using Delegates
The .NET Control Can Be Drawn in Only One Cell at a Time
Supports Registration of a Maximum of 32 .NET Controls
Using .NET Cell Controls
Chapter 6 GridTabControl Control
Introduction
Overview
Structure and Design
Design Time Support
Using GridTabControl
Chapter 7 1stGrid Tutorial
Introduction
1stGrid - Step 1
Create a New Solution and Project
Add a GridControl
1stGrid - Step 2
Create a New Project
Add a Menu
Add the GridDocument Class
Add an “About” Box
Add MDI Support
Add OGL Loading
Add Event Handlers
1stGrid - Step 3
Create a New Project
Add a Property Grid
1stGrid - Step 4
Create a New Project
Enable the Formula Engine
Add Event Handlers
Chapter 8 Samples
Introduction
SimpleSpreadSheet
ExcelLike
Running the Sample
Formula Support
Copying and Pasting Data and Formulas
Undo and Redo Changes
Find, Find and Replace
Saving a Grid in HTML Format
Design-time Features
Setting Grid Properties
Setting Cell Properties
Virtual Grid
Create a Solution for the Virtual Grid Project
Place a GridControl on Form1.cs.
Create a Data Structure for Storing Grid Cell Values
Add Virtual Grid Support to the Project
Add Event Handlers for the Menu Commands and Virtual Grid Events
RaceAttendance
Connecting the Property Grid to the Grid
Adding Data to the Grid
Formulas
Controls and Event Handling
Miscellaneous
Chapter 9 Working with the Office Open XML 2.5 SDK
Office Open XML SDK for Excel
OOXML Excel Library Addition
OOXML Excel Library Example
Stingray Objective Grid for .NET
OOXML Excel Library Example