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