Cells Property (FpSpread)

In This Topic

Gets the cells in the client area of the active sheet in the Spread component.

Syntax

Visual Basic
C#

'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.

C#
Visual Basic

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()

Reference

FpSpread Class
FpSpread Members
Cells Class

User-Task Documentation

Customizing the Colors of a Cell