Adding an Unbound Column to a Bound Sheet

Once you bind a sheet to a data set you might want to add an unbound column to contain additional data.

The following figure shows a sheet in a Spread component that contains data from a data set and an unbound row at the bottom that calculates the averages.

Sheet with unbound row

You can add an unbound column to the Spread control by increasing the ColumnCount property after the control is bound. Another option is to use the DataField property to bind specific columns and leave DataField unset for the columns you do not want to bind.

Using Code

Create your data set.
Set the FpSpread or Sheet DataSource property equal to the data set.
Set the ColumnCount property for the sheet.

Example

This example code binds the Spread component to a data set and then sets the column count.

C#	Copy Code
// Bind the component to the data set. fpSpread1.DataSource = dbDataSet; // If this datasource has 19 columns, set the count to 20. fpSpread1.Sheets[0].ColumnCount=20;

VB	Copy Code
' Bind the component to the data set. FpSpread1.DataSource = dbDataSet ' If this datasource has 19 columns, set the count to 20. FpSpread1.Sheets(0).ColumnCount=20