Syntax
| Visual Basic (Declaration) | |
|---|---|
Sub SetMergePolicy( _ ByVal index As Integer, _ ByVal value As MergePolicy _ ) | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As ISheetAxisModel Dim index As Integer Dim value As MergePolicy instance.SetMergePolicy(index, value) | |
| C# | |
|---|---|
void SetMergePolicy( int index, MergePolicy value ) | |
Parameters
- index
- Row or column index
- value
- Value with the 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 isa;
isa = FpSpread1.ActiveSheetView.columnAxisModel;
isa.SetMergePolicy(1, FarPoint.Web.Spread.Model.MergePolicy.Always);
FpSpread1.ActiveSheetView.Cells[0, 1, 2, 1].Text = "Test";
Response.Write(isa.GetMergePolicy(1));
| |
| Visual Basic | Copy Code |
|---|---|
Dim isa As FarPoint.Web.Spread.Model.ISheetAxisModel isa = FpSpread1.ActiveSheetView.columnAxisModel isa.SetMergePolicy(1, FarPoint.Web.Spread.Model.MergePolicy.Always) FpSpread1.ActiveSheetView.Cells(0, 1, 2, 1).Text = "Test" Response.Write(isa.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
See Also
Reference
ISheetAxisModel InterfaceISheetAxisModel Members