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


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

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

FpSpread Class
FpSpread Members
Cells Class

User-Task Documentation

Customizing the Colors of a Cell

 

 


Copyright © GrapeCity, inc. All rights reserved.