Copies the direct styles from one specified range of cells to another.
Copies styles and pastes them at the specified location.
Syntax
Parameters
- fromRow
- Row index of cell from which to begin copying
- fromColumn
- Column index of cell from which to begin copying
- toRow
- Row index at which to paste cell styles
- toColumn
- Column index at which to paste cell styles
- rowCount
- Number of rows to copy
- columnCount
- Number of columns to copy
Remarks
Example
This example creates a new StyleInfo object and changes the background color of the first cell. In a button click event the DefaultSheetStyleModel is copied to the third cell in the first column.
C# | Copy Code |
---|
private void Page_Load(object sender,System.EventArgs e)
{
if(this.IsPostBack)return;
FarPoint.Web.Spread.Model.DefaultSheetStyleModel model=(FarPoint.Web.Spread.Model.DefaultSheetStyleModel)FpSpread1.Sheets[0].StyleModel;
FarPoint.Web.Spread.StyleInfostyle=NewFarPoint.Web.Spread.StyleInfo();
style.BackColor=Color.Yellow;
model.SetDirectInfo(0,0,style);
}
private void Button1_Click(object sender,System.EventArgs e)
{
FarPoint.Web.Spread.Model.DefaultSheetStyleModel model=(FarPoint.Web.Spread.Model.DefaultSheetStyleModel)FpSpread1.Sheets[0].StyleModel;
model.Copy(0,0,2,0,1,1);
} |
Visual Basic | Copy Code |
---|
Private Sub Page_Load(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles MyBase.Load
If(IsPostBack)Then Return
Dim model As FarPoint.Web.Spread.Model.DefaultSheetStyleModel=FpSpread1.Sheets(0).StyleModel
Dim style As New FarPoint.Web.Spread.StyleInfo()
style.BackColor=Color.Yellow
model.SetDirectInfo(0,0,style)
End Sub
Private Sub Button1_Click(ByVal sender As System.Object,ByVal e As System.EventArgs)Handles Button1.Click
Dim model As FarPoint.Web.Spread.Model.DefaultSheetStyleModel=FpSpread1.Sheets(0).StyleModel
model.Copy(0,0,2,0,1,1)
End Sub |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also