Copies the direct styles from one specified range of cells to another. Copies styles and pastes them at the specified location.

Syntax

Visual Basic (Declaration)
Public Overridable Sub Copy( _ ByVal fromRow As Integer, _ ByVal fromColumn As Integer, _ ByVal toRow As Integer, _ ByVal toColumn As Integer, _ ByVal rowCount As Integer, _ ByVal columnCount As Integer _ )

Visual Basic (Declaration)

Public Overridable Sub Copy( _
   ByVal fromRow As Integer, _
   ByVal fromColumn As Integer, _
   ByVal toRow As Integer, _
   ByVal toColumn As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer _
)

Visual Basic (Usage)	Copy Code
Dim instance As DefaultSheetStyleModel Dim fromRow As Integer Dim fromColumn As Integer Dim toRow As Integer Dim toColumn As Integer Dim rowCount As Integer Dim columnCount As Integer instance.Copy(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount)

Visual Basic (Usage)

Copy Code

Dim instance As DefaultSheetStyleModel
Dim fromRow As Integer
Dim fromColumn As Integer
Dim toRow As Integer
Dim toColumn As Integer
Dim rowCount As Integer
Dim columnCount As Integer
 
instance.Copy(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount)

C#
public virtual void Copy( int fromRow, int fromColumn, int toRow, int toColumn, int rowCount, int columnCount )

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 style
toColumn: Column index at which to paste cell style
rowCount: Number of rows to copy
columnCount: Number of columns to copy

Remarks

The Copy method copies and pastes direct styles. For example, if you copy cells' styles, the styles set for those cells, and not their columns or rows, are copied and pasted.

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
PrivatevoidPage_Load(objectsender,System.EventArgse) { If(this.IsPostBack)Return; FarPoint.Web.Spread.Model.DefaultSheetStyleModelmodel=(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); } PrivatevoidButton1_Click(objectsender,System.EventArgse) { FarPoint.Web.Spread.Model.DefaultSheetStyleModelmodel=(FarPoint.Web.Spread.Model.DefaultSheetStyleModel)FpSpread1.Sheets[0].StyleModel; model.Copy(0,0,2,0,1,1); }

Copy Code

PrivatevoidPage_Load(objectsender,System.EventArgse)
{
If(this.IsPostBack)Return;

FarPoint.Web.Spread.Model.DefaultSheetStyleModelmodel=(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);
}

PrivatevoidButton1_Click(objectsender,System.EventArgse)
{
FarPoint.Web.Spread.Model.DefaultSheetStyleModelmodel=(FarPoint.Web.Spread.Model.DefaultSheetStyleModel)FpSpread1.Sheets[0].StyleModel;
model.Copy(0,0,2,0,1,1);
}

Visual Basic	Copy Code
PrivateSubPage_Load(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesMyBase.Load If(IsPostBack)ThenReturn DimmodelAsFarPoint.Web.Spread.Model.DefaultSheetStyleModel=FpSpread1.Sheets(0).StyleModel DimstyleAsNewFarPoint.Web.Spread.StyleInfo() style.BackColor=Color.Yellow model.SetDirectInfo(0,0,style) EndSub PrivateSubButton1_Click(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesButton1.Click DimmodelAsFarPoint.Web.Spread.Model.DefaultSheetStyleModel=FpSpread1.Sheets(0).StyleModel model.Copy(0,0,2,0,1,1) EndSub

Visual Basic

Copy Code

PrivateSubPage_Load(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesMyBase.Load
If(IsPostBack)ThenReturn

DimmodelAsFarPoint.Web.Spread.Model.DefaultSheetStyleModel=FpSpread1.Sheets(0).StyleModel
DimstyleAsNewFarPoint.Web.Spread.StyleInfo()
style.BackColor=Color.Yellow
model.SetDirectInfo(0,0,style)
EndSub

PrivateSubButton1_Click(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesButton1.Click
DimmodelAsFarPoint.Web.Spread.Model.DefaultSheetStyleModel=FpSpread1.Sheets(0).StyleModel
model.Copy(0,0,2,0,1,1)
EndSub

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

Syntax

Parameters

Remarks

Example

Requirements

See Also

Reference

Spread ASP.NET 6.0 Product Documentation
Copy Method
See Also Example Send Feedback