Moves the specified range of direct styles from one location to another.
Syntax
Parameters
- fromRow
- Row index from which to begin the move
- fromColumn
- Column index from which to begin the move
- toRow
- Row index at which to paste cell style
- toColumn
- Column index at which to paste cell style
- rowCount
- Number of rows to move
- columnCount
- Number of columns to move
Example
This example creates a new StyleInfo object. The StyleInfo is set to cell A1. In a button click event the StyleInfo is moved to another cell.
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);
boolb=model.IsEmpty();
ListBox1.Items.Add(b.ToString());
}
PrivatevoidButton1_Clicked(objectsender,System.EventArgse)
{
FarPoint.Web.Spread.Model.DefaultSheetStyleModelmodel=(FarPoint.Web.Spread.Model.DefaultSheetStyleModel)FpSpread1.Sheets[0].StyleModel;
model.Move(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)
DimbAsBoolean=model.IsEmpty()
ListBox1.Items.Add(b.ToString())
EndSub
PrivateSubButton1_Click(ByValsenderAsSystem.Object,ByValeAsSystem.EventArgs)HandlesButton1.Click
DimmodelAsFarPoint.Web.Spread.Model.DefaultSheetStyleModel=FpSpread1.Sheets(0).StyleModel
model.Move(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
See Also