Spread Windows Forms 12.0 Product Documentation
SetMergePolicy Method (DefaultSheetAxisModel)

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetAxisModel Class : SetMergePolicy Method
Row or column index
Value with merge policy
Sets the cell merge policy for the row or column.
Public Overrides Sub SetMergePolicy( _
   ByVal index As Integer, _
   ByVal value As MergePolicy _
Dim instance As DefaultSheetAxisModel
Dim index As Integer
Dim value As MergePolicy
instance.SetMergePolicy(index, value)
public override void SetMergePolicy( 
   int index,
   MergePolicy value


Row or column index
Value with merge policy
This example returns the merge policy for the specified column.
FarPoint.Win.Spread.Model.DefaultSheetAxisModel dsam = new FarPoint.Win.Spread.Model.DefaultSheetAxisModel(3, FarPoint.Win.Spread.Model.SheetAxisOrientation.Horizontal);
dsam = (FarPoint.Win.Spread.Model.DefaultSheetAxisModel)fpSpread1.ActiveSheet.Models.ColumnAxis;
dsam.SetMergePolicy(0, FarPoint.Win.Spread.Model.MergePolicy.Always);
FarPoint.Win.Spread.Model.MergePolicy p;
p = dsam.GetMergePolicy(0);
MessageBox.Show("The merge policy is " + p.ToString());

fpSpread1.ActiveSheet.SetText(0, 0, "Test");
fpSpread1.ActiveSheet.SetText(1, 0, "Test");
fpSpread1.ActiveSheet.SetText(2, 0, "Test");

Dim dsam As New FarPoint.Win.Spread.Model.DefaultSheetAxisModel(3, FarPoint.Win.Spread.Model.SheetAxisOrientation.Horizontal)
dsam = fpSpread1.ActiveSheet.Models.ColumnAxis
dsam.SetMergePolicy(0, FarPoint.Win.Spread.Model.MergePolicy.Always)
Dim p As FarPoint.Win.Spread.Model.MergePolicy
p = dsam.GetMergePolicy(0)
MessageBox.Show("The merge policy is " & p.ToString())

fpSpread1.ActiveSheet.SetText(0, 0, "Test")
fpSpread1.ActiveSheet.SetText(1, 0, "Test")
fpSpread1.ActiveSheet.SetText(2, 0, "Test")
See Also


DefaultSheetAxisModel Class
DefaultSheetAxisModel Members
GetMergePolicy Method

User-Task Documentation

Allowing Cells to Merge Automatically