Spread for ASP.NET 11 Product Documentation
Cells Property (FpSpread)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FpSpread Class : Cells Property
Gets the cells in the client area of the active sheet in the Spread component.
Syntax
'Declaration
 
Public ReadOnly Property Cells As Cells
'Usage
 
Dim instance As FpSpread
Dim value As Cells
 
value = instance.Cells
public Cells Cells {get;}

Property Value

Cells object that contains the cells in the data area of the currently selected sheet
Remarks

This property is available at run time only.

Use the Cells, Columns, Rows, and Sheets properties to work with individual cells, columns, rows, or sheets by specifying indices, then setting properties for the specified object.

Example
This example creates a spreadsheet with three sheets, sets the second sheet to be the active sheet, changes the BackColor of the AlternatingRows, and makes the cells in the first column button cells.
FpSpread1.Sheets.Count=3;
FpSpread1.ActiveSheetViewIndex=1;
FpSpread1.ActiveSheetView.AlternatingRows[0].BackColor=Color.Yellow;
FpSpread1.ActiveSheetView.AlternatingRows[1].BackColor=Color.YellowGreen;
FpSpread1.ActiveSheetView.Cells[0,0].CellType=newFarPoint.Web.Spread.ButtonCellType();
FpSpread1.ActiveSheetView.Cells[1,0].CellType=newFarPoint.Web.Spread.ButtonCellType();
FpSpread1.ActiveSheetView.Cells[2,0].CellType=newFarPoint.Web.Spread.ButtonCellType();
FpSpread1.Sheets.Count=3
FpSpread1.ActiveSheetViewIndex=1
FpSpread1.ActiveSheetView.AlternatingRows(0).BackColor=Color.Yellow
FpSpread1.ActiveSheetView.AlternatingRows(1).BackColor=Color.YellowGreen
FpSpread1.ActiveSheetView.Cells(0,0).CellType=NewFarPoint.Web.Spread.ButtonCellType()
FpSpread1.ActiveSheetView.Cells(1,0).CellType=NewFarPoint.Web.Spread.ButtonCellType()
FpSpread1.ActiveSheetView.Cells(2,0).CellType=NewFarPoint.Web.Spread.ButtonCellType()
See Also

Reference

FpSpread Class
FpSpread Members
Cells Class

User-Task Documentation

Customizing the Colors of a Cell