Copies a cell span and pastes it at the specified location.
Copies a cell span and pastes it at the specified location.
Syntax
Parameters
- fromRow
- Row index from which to begin copying
- fromColumn
- Column index from which to begin copying
- toRow
- Row index at which to paste the cell span
- toColumn
- Column index at which to paste the cell span
- rowCount
- Number of rows to copy
- columnCount
- Number of columns to copy
Example
This example adds a span to the SpanModel of the active sheet. In the click event of a button, the span is copied to another location.
C# | Copy Code |
---|
private void Page_Load(object sender,System.EventArgs e)
{
if(this.IsPostBack)return;
FpSpread1.ActiveSheetView.ColumnCount=10;
FpSpread1.ActiveSheetView.RowCount=10;
FarPoint.Web.Spread.Model.ISheetSpanModel model=FpSpread1.ActiveSheetView.SpanModel;
model.Add(0,0,3,3);
}
private void Button1_Click(object sender,System.EventArgs e)
{
FarPoint.Web.Spread.Model.IRangeSupport model=(FarPoint.Web.Spread.Model.IRangeSupport)FpSpread1.ActiveSheetView.SpanModel;
model.Copy(0,0,0,5,3,3);
} |
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
FpSpread1.ActiveSheetView.ColumnCount=10
FpSpread1.ActiveSheetView.RowCount=10
Dim model As FarPoint.Web.Spread.Model.ISheetSpanModel=FpSpread1.ActiveSheetView.SpanModel
model.Add(0,0,3,3)
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.IRangeSupport=FpSpread1.ActiveSheetView.SpanModel
model.Copy(0,0,0,5,3,3)
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