Imports System.Collections.Generic
Imports System.ComponentModel
Imports System.Drawing
Imports System.Data
Imports System.Linq
Imports System.Text
Imports System.Threading.Tasks
Imports System.Windows.Forms
Imports FarPoint.Win.Spread.Model
Imports Spread.Common.Features.Spread.Common.Features.Sample

Namespace Features
	Public Partial Class MergeAndSpanDemo
		Inherits BaseSampleControl
		Public Sub New()
			InitializeComponent()
			Name = "Cell Merging and Spanning"

			'Spanning Header
			fpSpread1_Sheet1.ColumnHeader.RowCount = 2
			fpSpread1_Sheet1.ColumnHeader.SetClip(0, 0, 2, 7, "ID" & vbTab & "Name" & vbTab & vbTab & "Department" & vbTab & "Email" & vbTab & "Address" & vbTab & vbLf & vbTab & "First Name" & vbTab & "Last Name" & vbTab & vbTab & vbTab & "Current" & vbTab & "Permanent" & vbLf)
			fpSpread1_Sheet1.ColumnHeader.Cells(0, 0).RowSpan = 2
			fpSpread1_Sheet1.ColumnHeader.Cells(0, 1).ColumnSpan = 2
			fpSpread1_Sheet1.ColumnHeader.Cells(0, 3).RowSpan = 2
			fpSpread1_Sheet1.ColumnHeader.Cells(0, 4).RowSpan = 2
			fpSpread1_Sheet1.ColumnHeader.Cells(0, 5).ColumnSpan = 2

			Dim data As Object(,) = New Object(,) {{1, "John", "Smith", "IT", "John.Smith@gmail.com", "Athens Place,Washington", _
				"Athens Place,Washington"}, {2, "Oliver", "Williams", "IT", "Oliver.Williams@gmail.com", "Quebec Place,Washington", _
				"Quebec Place,Washington"}, {3, "Robert", "Taylor", "IT", "Robert.Taylor@gmail.com", "Peshwar Place,Washington", _
				"Peshwar Place,Washington"}, {4, "Ellen", "Thomas", "IT", "Ellen.Thomas@gmail.com", "Quebec Place,Washington", _
				"Peshwar Place,Washington"}, {5, "Jane", "Roberts", "Development", "Jane.Roberts@gmail.com", "Pennsylvania", _
				"Maryland"}, {6, "Charles", "White", "Development", "Charles.White@gmail.com", "Maryland", _
				"Virginia"}, _
				{7, "Emma", "Jackson", "Development", "Emma.Jackson@gmail.com", "Pennsylvania", _
				"Delaware"}, {8, "Albert", "Green", "Development", "Albert.Green@gmail.com", "Maryland", _
				"Washington"}, {9, "Michael", "Robinson", "Development", "Michael.Robinson@gmail.com", "Virginia", _
				"Virginia"}, {10, "Leo", "Brown", "Development", "Leo.Brown@gmail.com", "Washington", _
				"Pennsylvania"}, {11, "Archie", "Wood", "Development", "Archie.Wood@gmail.com", "Virginia", _
				"Maryland"}, {12, "Henry", "Turner", "Development", "Henry.Turner@gmail.com", "Delaware", _
				"Delaware"}, _
				{13, "Susan", "Taylor", "Marketing", "Susan.Taylor@gmail.com", "Pennsylvania", _
				"Virginia"}, {14, "Florence", "Green", "Marketing", "Florence.Green@gmail.com", "Delaware", _
				"Delaware"}, {15, "Sophia", "Lewis", "Marketing", "Sophia.Lewis@gmail.com", "Maryland", _
				"Washington"}, {16, "George", "Harris", "Marketing", "George.Harris@gmail.com", "Delaware", _
				"Pennsylvania"}, {17, "Jacob", "Smith", "Marketing", "Jacob.Smith@gmail.com", "Pennsylvania", _
				"Virginia"}, {18, "Ruby", "Jones", "Marketing", "Ruby.Jones@gmail.com", "Maryland", _
				"Washington"}, _
				{19, "Thomas", "Evans", "Customer Support", "Thomas.Evans@gmail.com", "Delaware", _
				"Delaware"}, {20, "Jessica", "Robinson", "Customer Support", "Jessica.Robinson@gmail.com", "Washington", _
				"Maryland"}, {21, "Harry", "Brown", "Customer Support", "Harry.Brown@gmail.com", "Washington", _
				"Washington"}, {22, "Joseph", "Hall", "Customer Support", "Joseph.Hall@gmail.com", "Delaware", _
				"Delaware"}, {23, "Noah", "Walker", "Sales", "Noah.Walker@gmail.com", "Pennsylvania", _
				"Washington"}, {24, "Edward", "Smith", "Sales", "Edward.Smith@gmail.com", "Maryland", _
				"Delaware"}, _
				{25, "Ella", "Thomas", "Sales", "Ella.Thomas@gmail.com", "Virginia", _
				"Virginia"}}

			For r As Integer = 0 To data.GetUpperBound(0)
				For c As Integer = 0 To data.GetUpperBound(1)
					fpSpread1_Sheet1.Cells(r, c).Value = data(r, c)
				Next
			Next

			fpSpread1_Sheet1.SetColumnWidth(-1, 100)
			fpSpread1_Sheet1.SetRowHeight(-1, 21)
			fpSpread1_Sheet1.Columns(0).Width = 50
			fpSpread1_Sheet1.SetColumnMerge(-1, MergePolicy.Always)
		End Sub

		Private Sub RadioButton_CheckedChanged(sender As Object, e As EventArgs)
            Dim rb As RadioButton = TryCast(sender, RadioButton)
            If rb.Checked Then
				Select Case rb.Text
					Case "None"
						fpSpread1_Sheet1.SetColumnMerge(-1, MergePolicy.None)
						fpSpread1_Sheet1.SetRowMerge(-1, MergePolicy.None)
						Exit Select
					Case "Row"
						fpSpread1_Sheet1.SetColumnMerge(-1, MergePolicy.None)
						fpSpread1_Sheet1.SetRowMerge(-1, MergePolicy.Always)
						Exit Select
					Case "Column"
						fpSpread1_Sheet1.SetColumnMerge(-1, MergePolicy.Always)
						fpSpread1_Sheet1.SetRowMerge(-1, MergePolicy.None)
						Exit Select
					Case "Both"
						fpSpread1_Sheet1.SetColumnMerge(-1, MergePolicy.Always)
						fpSpread1_Sheet1.SetRowMerge(-1, MergePolicy.Always)
						Exit Select
				End Select
			End If
		End Sub

		Private Sub _bSpan_Click(sender As Object, e As EventArgs)
			Dim cr As CellRange = fpSpread1_Sheet1.GetSelection(0)
			If cr IsNot Nothing Then
				If cr.ColumnCount > 1 OrElse cr.RowCount > 1 Then
					fpSpread1_Sheet1.AddSpanCell(cr.Row, cr.Column, cr.RowCount, cr.ColumnCount)
				End If
			End If
		End Sub

		Private Sub _bURemoveSpan_Click(sender As Object, e As EventArgs)
			Dim cr As CellRange = fpSpread1_Sheet1.GetSelection(0)
			If cr IsNot Nothing Then
				If cr.Row <> -1 AndAlso cr.Column <> -1 Then
					fpSpread1_Sheet1.RemoveSpanCell(cr.Row, cr.Column)
				End If
			End If
		End Sub

		Private Sub _cbAllowOverFlow_CheckedChanged(sender As Object, e As EventArgs)
			fpSpread1.AllowCellOverflow = _cbAllowOverFlow.Checked
		End Sub

		Private Sub _cbEditOverflow_CheckedChanged(sender As Object, e As EventArgs)
			fpSpread1.AllowEditOverflow = _cbEditOverflow.Checked
		End Sub
	End Class
End Namespace

'
'MergeAndSpanDemo.Designer.vb
'

Namespace Features
	Partial Class MergeAndSpanDemo
		''' <summary> 
		''' Required designer variable.
		''' </summary>
		Private components As System.ComponentModel.IContainer = Nothing

        ''' <summary> 
        ''' Clean up any resources being used.
        ''' </summary>
        ''' <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        Protected Overloads Sub Dispose(disposing As Boolean)
            If disposing AndAlso (components IsNot Nothing) Then
                components.Dispose()
            End If
            MyBase.Dispose(disposing)
        End Sub

#Region "Component Designer generated code"

        ''' <summary> 
        ''' Required method for Designer support - do not modify 
        ''' the contents of this method with the code editor.
        ''' </summary>
        Private Sub InitializeComponent()
			Me.fpSpread1 = New FarPoint.Win.Spread.FpSpread()
			Me.fpSpread1_Sheet1 = New FarPoint.Win.Spread.SheetView()
			Me.groupBox1 = New System.Windows.Forms.GroupBox()
			Me._rbMergeCol = New System.Windows.Forms.RadioButton()
			Me._rbMergeRow = New System.Windows.Forms.RadioButton()
			Me._rbMergeNone = New System.Windows.Forms.RadioButton()
			Me._bSpan = New System.Windows.Forms.Button()
			Me._bRemoveSpan = New System.Windows.Forms.Button()
			Me._cbAllowOverFlow = New System.Windows.Forms.CheckBox()
			Me._cbEditOverflow = New System.Windows.Forms.CheckBox()
			Me.groupBox2 = New System.Windows.Forms.GroupBox()
			Me.groupBox3 = New System.Windows.Forms.GroupBox()
			Me._rbMergeBoth = New System.Windows.Forms.RadioButton()
			Me.pnlMain.SuspendLayout()
			Me.pnlControls.SuspendLayout()
			DirectCast(Me.fpSpread1, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.fpSpread1_Sheet1, System.ComponentModel.ISupportInitialize).BeginInit()
			Me.groupBox1.SuspendLayout()
			Me.groupBox2.SuspendLayout()
			Me.groupBox3.SuspendLayout()
			Me.SuspendLayout()
			' 
			' pnlMain
			' 
			Me.pnlMain.Controls.Add(Me.fpSpread1)
			' 
			' pnlControls
			' 
			Me.pnlControls.Controls.Add(Me.groupBox3)
			Me.pnlControls.Controls.Add(Me.groupBox2)
			Me.pnlControls.Controls.Add(Me.groupBox1)
			' 
			' fpSpread1
			' 
			Me.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill
			Me.fpSpread1.Location = New System.Drawing.Point(0, 0)
			Me.fpSpread1.Name = "fpSpread1"
			Me.fpSpread1.Sheets.AddRange(New FarPoint.Win.Spread.SheetView() {Me.fpSpread1_Sheet1})
			Me.fpSpread1.Size = New System.Drawing.Size(477, 487)
			Me.fpSpread1.TabIndex = 0
			' 
			' fpSpread1_Sheet1
			' 
			Me.fpSpread1_Sheet1.Reset()
			Me.fpSpread1_Sheet1.SheetName = "Sheet1"
			' Formulas and custom names must be loaded with R1C1 reference style
			Me.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
			Me.fpSpread1_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
			' 
			' groupBox1
			' 
			Me.groupBox1.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.groupBox1.Controls.Add(Me._rbMergeBoth)
			Me.groupBox1.Controls.Add(Me._rbMergeCol)
			Me.groupBox1.Controls.Add(Me._rbMergeRow)
			Me.groupBox1.Controls.Add(Me._rbMergeNone)
			Me.groupBox1.Location = New System.Drawing.Point(6, 20)
			Me.groupBox1.Name = "groupBox1"
			Me.groupBox1.Size = New System.Drawing.Size(140, 124)
			Me.groupBox1.TabIndex = 0
			Me.groupBox1.TabStop = False
			Me.groupBox1.Text = "Merging Options"
			' 
			' _rbMergeCol
			' 
			Me._rbMergeCol.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me._rbMergeCol.AutoSize = True
			Me._rbMergeCol.Checked = True
			Me._rbMergeCol.Location = New System.Drawing.Point(7, 66)
			Me._rbMergeCol.Name = "_rbMergeCol"
			Me._rbMergeCol.Size = New System.Drawing.Size(60, 17)
			Me._rbMergeCol.TabIndex = 2
			Me._rbMergeCol.TabStop = True
			Me._rbMergeCol.Text = "Column"
			Me._rbMergeCol.UseVisualStyleBackColor = True
			AddHandler Me._rbMergeCol.CheckedChanged, New System.EventHandler(AddressOf Me.RadioButton_CheckedChanged)
			' 
			' _rbMergeRow
			' 
			Me._rbMergeRow.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me._rbMergeRow.AutoSize = True
			Me._rbMergeRow.Location = New System.Drawing.Point(7, 43)
			Me._rbMergeRow.Name = "_rbMergeRow"
			Me._rbMergeRow.Size = New System.Drawing.Size(47, 17)
			Me._rbMergeRow.TabIndex = 1
			Me._rbMergeRow.Text = "Row"
			Me._rbMergeRow.UseVisualStyleBackColor = True
			AddHandler Me._rbMergeRow.CheckedChanged, New System.EventHandler(AddressOf Me.RadioButton_CheckedChanged)
			' 
			' _rbMergeNone
			' 
			Me._rbMergeNone.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me._rbMergeNone.AutoSize = True
			Me._rbMergeNone.Location = New System.Drawing.Point(7, 20)
			Me._rbMergeNone.Name = "_rbMergeNone"
			Me._rbMergeNone.Size = New System.Drawing.Size(51, 17)
			Me._rbMergeNone.TabIndex = 0
			Me._rbMergeNone.Text = "None"
			Me._rbMergeNone.UseVisualStyleBackColor = True
			AddHandler Me._rbMergeNone.CheckedChanged, New System.EventHandler(AddressOf Me.RadioButton_CheckedChanged)
			' 
			' _bSpan
			' 
			Me._bSpan.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me._bSpan.Location = New System.Drawing.Point(8, 28)
			Me._bSpan.Name = "_bSpan"
			Me._bSpan.Size = New System.Drawing.Size(118, 23)
			Me._bSpan.TabIndex = 1
			Me._bSpan.Text = "Add Span"
			Me._bSpan.UseVisualStyleBackColor = True
			AddHandler Me._bSpan.Click, New System.EventHandler(AddressOf Me._bSpan_Click)
			' 
			' _bRemoveSpan
			' 
			Me._bRemoveSpan.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me._bRemoveSpan.Location = New System.Drawing.Point(8, 72)
			Me._bRemoveSpan.Name = "_bRemoveSpan"
			Me._bRemoveSpan.Size = New System.Drawing.Size(119, 23)
			Me._bRemoveSpan.TabIndex = 2
			Me._bRemoveSpan.Text = "Remove Span"
			Me._bRemoveSpan.UseVisualStyleBackColor = True
			AddHandler Me._bRemoveSpan.Click, New System.EventHandler(AddressOf Me._bURemoveSpan_Click)
			' 
			' _cbAllowOverFlow
			' 
			Me._cbAllowOverFlow.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me._cbAllowOverFlow.AutoSize = True
			Me._cbAllowOverFlow.Location = New System.Drawing.Point(8, 28)
			Me._cbAllowOverFlow.Name = "_cbAllowOverFlow"
			Me._cbAllowOverFlow.Size = New System.Drawing.Size(119, 17)
			Me._cbAllowOverFlow.TabIndex = 3
			Me._cbAllowOverFlow.Text = "Allow Cell OverFlow"
			Me._cbAllowOverFlow.UseVisualStyleBackColor = True
			AddHandler Me._cbAllowOverFlow.CheckedChanged, New System.EventHandler(AddressOf Me._cbAllowOverFlow_CheckedChanged)
			' 
			' _cbEditOverflow
			' 
			Me._cbEditOverflow.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me._cbEditOverflow.AutoSize = True
			Me._cbEditOverflow.Location = New System.Drawing.Point(7, 68)
			Me._cbEditOverflow.Name = "_cbEditOverflow"
			Me._cbEditOverflow.Size = New System.Drawing.Size(120, 17)
			Me._cbEditOverflow.TabIndex = 4
			Me._cbEditOverflow.Text = "Allow Edit OverFlow"
			Me._cbEditOverflow.UseVisualStyleBackColor = True
			AddHandler Me._cbEditOverflow.CheckedChanged, New System.EventHandler(AddressOf Me._cbEditOverflow_CheckedChanged)
			' 
			' groupBox2
			' 
			Me.groupBox2.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.groupBox2.Controls.Add(Me._cbEditOverflow)
			Me.groupBox2.Controls.Add(Me._cbAllowOverFlow)
			Me.groupBox2.Location = New System.Drawing.Point(6, 284)
			Me.groupBox2.Name = "groupBox2"
			Me.groupBox2.Size = New System.Drawing.Size(140, 105)
			Me.groupBox2.TabIndex = 5
			Me.groupBox2.TabStop = False
			Me.groupBox2.Text = "Cell OverFlow"
			' 
			' groupBox3
			' 
			Me.groupBox3.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.groupBox3.Controls.Add(Me._bSpan)
			Me.groupBox3.Controls.Add(Me._bRemoveSpan)
			Me.groupBox3.Location = New System.Drawing.Point(6, 151)
			Me.groupBox3.Name = "groupBox3"
			Me.groupBox3.Size = New System.Drawing.Size(140, 118)
			Me.groupBox3.TabIndex = 6
			Me.groupBox3.TabStop = False
			Me.groupBox3.Text = "Cell Span"
			' 
			' _rbMergeBoth
			' 
			Me._rbMergeBoth.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me._rbMergeBoth.AutoSize = True
			Me._rbMergeBoth.Location = New System.Drawing.Point(7, 89)
			Me._rbMergeBoth.Name = "_rbMergeBoth"
			Me._rbMergeBoth.Size = New System.Drawing.Size(47, 17)
			Me._rbMergeBoth.TabIndex = 3
			Me._rbMergeBoth.TabStop = True
			Me._rbMergeBoth.Text = "Both"
			Me._rbMergeBoth.UseVisualStyleBackColor = True
			AddHandler Me._rbMergeBoth.CheckedChanged, New System.EventHandler(AddressOf Me.RadioButton_CheckedChanged)
			' 
			' MergeAndSpanDemo
			' 
			Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
			Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
			Me.Name = "MergeAndSpanDemo"
			Me.pnlMain.ResumeLayout(False)
			Me.pnlControls.ResumeLayout(False)
			DirectCast(Me.fpSpread1, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.fpSpread1_Sheet1, System.ComponentModel.ISupportInitialize).EndInit()
			Me.groupBox1.ResumeLayout(False)
			Me.groupBox1.PerformLayout()
			Me.groupBox2.ResumeLayout(False)
			Me.groupBox2.PerformLayout()
			Me.groupBox3.ResumeLayout(False)
			Me.ResumeLayout(False)

		End Sub

		#End Region

		Private fpSpread1 As FarPoint.Win.Spread.FpSpread
		Private fpSpread1_Sheet1 As FarPoint.Win.Spread.SheetView
		Private groupBox1 As System.Windows.Forms.GroupBox
		Private _rbMergeCol As System.Windows.Forms.RadioButton
		Private _rbMergeRow As System.Windows.Forms.RadioButton
		Private _rbMergeNone As System.Windows.Forms.RadioButton
		Private _bRemoveSpan As System.Windows.Forms.Button
		Private _bSpan As System.Windows.Forms.Button
		Private _cbAllowOverFlow As System.Windows.Forms.CheckBox
		Private _cbEditOverflow As System.Windows.Forms.CheckBox
		Private groupBox3 As System.Windows.Forms.GroupBox
		Private groupBox2 As System.Windows.Forms.GroupBox
		Private _rbMergeBoth As System.Windows.Forms.RadioButton
	End Class
End Namespace
