Swaps the specified range of direct styles from with another range of direct styles.
Syntax
Parameters
- fromRow
- Row index of first cell from which to begin swap
- fromColumn
- Column index of first cell from which to begin swap
- toRow
- Row index of first cell of destination of the swap
- toColumn
- Column index of first cell of destination of the swap
- rowCount
- Number of rows to swap
- columnCount
- Number of columns to swap
Example
This example creates two StyleInfo objects and sets the style for four cells. In a button click event the styles for the cells are swapped.
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.StyleInfo style=new FarPoint.Web.Spread.StyleInfo();
FarPoint.Web.Spread.StyleInfo style1=new FarPoint.Web.Spread.StyleInfo();
style.BackColor=Color.Yellow;
style1.BackColor=Color.Red;
model.SetDirectInfo(0,0,style);
model.SetDirectInfo(1,0,style);
model.SetDirectInfo(0,2,style1);
model.SetDirectInfo(1,2,style1);
}
private void Button1_Clicked(object sender,System.EventArgs e)
{
FarPoint.Web.Spread.Model.DefaultSheetStyleModel model=(FarPoint.Web.Spread.Model.DefaultSheetStyleModel)FpSpread1.Sheets[0].StyleModel;
model.Swap(0,0,0,2,2,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()
Dim style1 As New FarPoint.Web.Spread.StyleInfo()
style.BackColor=Color.Yellow
style1.BackColor=Color.Red
model.SetDirectInfo(0,0,style)
model.SetDirectInfo(1,0,style)
model.SetDirectInfo(0,2,style1)
model.SetDirectInfo(1,2,style1)
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.Swap(0,0,0,2,2,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