Visual Basic (Declaration) | |
---|---|
Public Overrides Sub SetMergePolicy( _ ByVal index As Integer, _ ByVal value As MergePolicy _ ) |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As DefaultSheetAxisModel Dim index As Integer Dim value As MergePolicy instance.SetMergePolicy(index, value) |
C# | |
---|---|
public override void SetMergePolicy( int index, MergePolicy value ) |
Parameters
- index
- Row or column index
- value
- Value with merge policy
The MergePolicy setting specifies if and how cells in this column are automatically merged.
This example merges all cells that contain the same data.
C# | Copy Code |
---|---|
FarPoint.Web.Spread.Model.ISheetAxisModel dsa;
dsa = FpSpread1.ActiveSheetView.ColumnAxisModel;
dsa.SetMergePolicy(1, FarPoint.Web.Spread.Model.MergePolicy.Always);
FpSpread1.ActiveSheetView.Cells[0, 1, 2, 1].Text = "Test";
Response.Write(dsa.GetMergePolicy(1));
|
Visual Basic | Copy Code |
---|---|
Dim dsa As FarPoint.Web.Spread.Model.ISheetAxisModel dsa = FpSpread1.ActiveSheetView.ColumnAxisModel dsa.SetMergePolicy(1, FarPoint.Web.Spread.Model.MergePolicy.Always) FpSpread1.ActiveSheetView.Cells(0, 1, 2, 1).Text = "Test" Response.Write(dsa.GetMergePolicy(1)) |
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
Reference
DefaultSheetAxisModel ClassDefaultSheetAxisModel Members