1stGrid - Step 4

Objective Grid for Microsoft .NET User's Guide
Rogue Wave web site: Home Page | Main Documentation Page

8.5 1stGrid - Step 4

This section gives the steps required to complete Step 4 of the 1stGrid tutorial. Step 4 enables the Objective Grid for Microsoft .NET formula engine, and configures the grid documents to sum numbers in column two, from row 2 through row 11.

If you don't want to keep Step 3, then skip to Section 8.5.2 to continue adding the Step 4 features to Step 3.

8.5.1 Create a New Project

Right click Solution '1stGrid' in Solution Explorer.
From the context menu that appears, select Add | New Project.

Click Visual C# Projects.
Select Windows Application.
Set Name to "Step 4".
Click OK.

Right click and delete AssemblyInfo.cs and Form1.cs.
From the command prompt or from the Windows Explorer:

Delete all of the remaining Step 4 project and source files.
Copy all of the Step 3 source and project files into the Step 4 directory.
Rename Step 3.* to Step 4.*.

Visual Studio will indicate that the project has changed. Select Discard to discard any cached Step 4 project files.
Right click Step 4.
From the context menu that appears, select Set As Startup Project.

8.5.2 Enable the Formula Engine

The following steps enable the formula engine.

Open Form1.cs in design mode.
Select the form. Change the following form properties for Form1:

Set Text to "1stGrid Tutorial Step 4".

Open the Design View for the GridDocument class.
Select the grid control in the GridDocument form.
Select the properties for the Grid Control.
Expand the Features property (in the Configurations category).

Set EnableFormulaEngine to true.
Set EnableWorkSheetFunctions to true.

8.5.3 Add Event Handlers

The following steps add event-handling code for the GridInitialized and EndEditing events. You handle the GridInitialize event by adding some simple titles and a formula to the grid. The formula sums the numbers in column 2, rows 2 through 11. You handle the EndEditing event by validating any user input, which should be empty text or numeric data.

Select the events for the Grid Control in the property grid (click on the lightning bolt in the property grid).

Double click the GridInitialized method, and add the following implementation for the GridInitialized method:

gridControl1[1,2].Style.Value = "Values";
gridControl1[12,1].Style.Value = "Sum:";
gridControl1[12,2].Formula = "=SUM(B2:B11)";

Select the events for the Grid Control in the property grid (click the lightning bolt).

Double click the EndEditing event, and add the following validation code:

Cell cell = gridControl1.CurrentCell;
if (cell.Col == 2 && cell.Row >= 2 && cell.Row <= 11)
{
  bool isDigits = true;
  for (int i = 0; isDigits && i < cell.Style.Value.Length; ++i)
  {
    isDigits = Char.IsDigit(cell.Style.Value, i);
  }

  if (!isDigits)
  {
    MessageBox.Show("Invalid Numeric Value");
    e.IsValid = false;
  }
}

Add the following using declaration at the top of the file GridDocument.cs:
Build and run the completed application.

Congratulations! You've completed the final step of the 1stGrid tutorial.

Figure 43: Completed 1stGrid Step 4

The Rogue Wave name and logo, and Stingray, are registered trademarks of Rogue Wave Software. All other trademarks are the property of their respective owners.
Provide feedback to Rogue Wave about its documentation.