Imports System.Collections.Generic
Imports System.Windows.Forms
Imports FarPoint.Win.Spread
Imports FarPoint.Win.Spread.Model
Imports Spread.Common.DataStore
Imports Spread.Common.DataStore.Models
Imports Spread.Common.Features.Spread.Common.Features.Sample

Namespace Features
    Partial Public Class RangeGroupDemo
        Inherits BaseSampleControl
        Private _dataSource As JsonDataSource

        Public Sub New()
            InitializeComponent()
            Name = "Outlines, Row and Column Range Groups"

            _dataSource = New DataService().JsonDataSource

            InitSpreadSheet(fpSpread.ActiveSheet)

            AddHandler btnGroup.Click, AddressOf BtnGroup_Click
            AddHandler btnUngroup.Click, AddressOf BtnUngroup_Click
            AddHandler btnShowDetail.Click, AddressOf BtnShowDetail_Click
            AddHandler btnHideDetail.Click, AddressOf BtnHideDetail_Click
            AddHandler chkSummaryBelow.CheckedChanged, AddressOf ChkSummaryBelow_CheckedChanged
            AddHandler chkSummaryRight.CheckedChanged, AddressOf ChkSummaryRight_CheckedChanged
        End Sub

        Private Sub InitSpreadSheet(sheet As SheetView)
            Dim movieRecords As List(Of MovieRecord) = _dataSource.GetMovieRecords()
            sheet.DataSource = movieRecords

            sheet.AddRangeGroup(1, 10, True)
            sheet.AddRangeGroup(1, 4, True)
            sheet.AddRangeGroup(6, 4, True)
            sheet.AddRangeGroup(1, 3, False)
            sheet.AddRangeGroup(1, 2, False)

            For col As Integer = 0 To sheet.ColumnCount - 1
                sheet.Columns(col).Width = sheet.GetPreferredColumnWidth(col, PreferredSizeColumnOptions.IncludeAll)
            Next
        End Sub

#Region "Event handlers"
        Private Sub BtnGroup_Click(sender As Object, e As EventArgs)
            Try
                Dim sheet As SheetView = fpSpread.ActiveSheet
                Dim cr As CellRange = sheet.GetSelection(0)
                If cr.Column = -1 AndAlso cr.Row = -1 Then

                    ' sheet selection
                ElseIf cr.Column = -1 Then
                    ' row selection
                    sheet.AddRangeGroup(cr.Row, cr.RowCount, True)
                ElseIf cr.Row = -1 Then
                    ' column selection
                    sheet.AddRangeGroup(cr.Column, cr.ColumnCount, False)
                Else
                    ' cell range selection

                    MessageBox.Show("Please select row or column for group")
                End If
            Catch ex As System.Exception
                MessageBox.Show(ex.Message, "Error")
            End Try

        End Sub

        Private Sub BtnUngroup_Click(sender As Object, e As EventArgs)
            Try
                Dim sheet As SheetView = fpSpread.ActiveSheet
                Dim cr As CellRange = sheet.GetSelection(0)
                If cr.Column = -1 AndAlso cr.Row = -1 Then

                    ' sheet selection
                ElseIf cr.Column = -1 Then
                    ' row selection
                    sheet.RemoveRangeGroup(cr.Row, cr.RowCount, True)
                ElseIf cr.Row = -1 Then
                    ' column selection
                    sheet.RemoveRangeGroup(cr.Column, cr.ColumnCount, False)
                Else
                    ' cell range selection

                    MessageBox.Show("Please select row or column which are in a group")
                End If
            Catch ex As System.Exception
                MessageBox.Show(ex.Message, "Error")
            End Try
        End Sub

        Private Sub BtnShowDetail_Click(sender As Object, e As EventArgs)
            Try
                Dim sheet As SheetView = fpSpread.Sheets(0)
                Dim cr As CellRange = sheet.GetSelection(0)
                If cr.Column = -1 AndAlso cr.Row = -1 Then

                    ' sheet selection
                ElseIf cr.Column = -1 Then
                    ' row selection
                    For i As Integer = cr.Row To cr.Row + (cr.RowCount - 1)
                        Dim level As Integer = sheet.GetRangeGroupLevels(True)
                        For j As Integer = 0 To level - 1
                            Dim groupInfo As RangeGroupInfo() = sheet.GetRangeGroupInfo(j, True)
                            If groupInfo IsNot Nothing Then
                                For Each rgi As RangeGroupInfo In groupInfo
                                    If i >= rgi.Start AndAlso i <= rgi.[End] Then
                                        sheet.ExpandRangeGroup(rgi, True, True)
                                    End If
                                Next
                            End If
                        Next
                    Next
                ElseIf cr.Row = -1 Then
                    ' column selection
                    For i As Integer = cr.Column To cr.Column + (cr.ColumnCount - 1)
                        Dim level As Integer = sheet.GetRangeGroupLevels(True)
                        For j As Integer = 0 To level - 1
                            Dim groupInfo As RangeGroupInfo() = sheet.GetRangeGroupInfo(j, False)
                            If groupInfo IsNot Nothing Then
                                For Each rgi As RangeGroupInfo In groupInfo
                                    If i >= rgi.Start AndAlso i <= rgi.[End] Then
                                        sheet.ExpandRangeGroup(rgi, False, True)
                                    End If
                                Next
                            End If
                        Next
                    Next
                Else
                    ' cell range selection

                    MessageBox.Show("Please select row or column which are in a group")
                End If
            Catch ex As System.Exception
                MessageBox.Show(ex.Message, "Error")
            End Try

        End Sub

        Private Sub BtnHideDetail_Click(sender As Object, e As EventArgs)
            Try
                Dim sheet As SheetView = fpSpread.Sheets(0)
                Dim cr As CellRange = sheet.GetSelection(0)
                If cr.Column = -1 AndAlso cr.Row = -1 Then

                    ' sheet selection
                ElseIf cr.Column = -1 Then
                    ' row selection
                    For i As Integer = cr.Row To cr.Row + (cr.RowCount - 1)
                        Dim level As Integer = sheet.GetRangeGroupLevels(True)
                        For j As Integer = 0 To level - 1
                            Dim groupInfo As RangeGroupInfo() = sheet.GetRangeGroupInfo(j, True)
                            If groupInfo IsNot Nothing Then
                                For Each rgi As RangeGroupInfo In groupInfo
                                    If i >= rgi.Start AndAlso i <= rgi.[End] Then
                                        sheet.ExpandRangeGroup(rgi, True, False)
                                    End If
                                Next
                            End If
                        Next
                    Next
                ElseIf cr.Row = -1 Then
                    ' column selection
                    For i As Integer = cr.Column To cr.Column + (cr.ColumnCount - 1)
                        Dim level As Integer = sheet.GetRangeGroupLevels(True)
                        For j As Integer = 0 To level - 1
                            Dim groupInfo As RangeGroupInfo() = sheet.GetRangeGroupInfo(j, False)
                            If groupInfo IsNot Nothing Then
                                For Each rgi As RangeGroupInfo In groupInfo
                                    If i >= rgi.Start AndAlso i <= rgi.[End] Then
                                        sheet.ExpandRangeGroup(rgi, False, False)
                                    End If
                                Next
                            End If
                        Next
                    Next
                Else
                    ' cell range selection
                    MessageBox.Show("Please select row or column which are in a group")
                End If
            Catch ex As System.Exception
                MessageBox.Show(ex.Message, "Error")
            End Try

        End Sub

        Private Sub ChkSummaryBelow_CheckedChanged(sender As Object, e As EventArgs)
            fpSpread.ActiveSheet.RangeGroupSummaryRowBelow = chkSummaryBelow.Checked
        End Sub

        Private Sub ChkSummaryRight_CheckedChanged(sender As Object, e As EventArgs)
            fpSpread.ActiveSheet.RangeGroupSummaryColumnRight = chkSummaryRight.Checked
        End Sub
#End Region
    End Class
End Namespace

'
'RangeGroupDemo.Designer.vb
'

Namespace Features
	Partial Class RangeGroupDemo
		''' <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 Shadows 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.fpSpread = New FarPoint.Win.Spread.FpSpread()
			Me.fpSpread_Sheet1 = New FarPoint.Win.Spread.SheetView()
			Me.groupBox1 = New System.Windows.Forms.GroupBox()
			Me.tableLayoutPanel1 = New System.Windows.Forms.TableLayoutPanel()
			Me.btnGroup = New System.Windows.Forms.Button()
			Me.btnUngroup = New System.Windows.Forms.Button()
			Me.btnShowDetail = New System.Windows.Forms.Button()
			Me.btnHideDetail = New System.Windows.Forms.Button()
			Me.groupBox2 = New System.Windows.Forms.GroupBox()
			Me.chkSummaryBelow = New System.Windows.Forms.CheckBox()
			Me.chkSummaryRight = New System.Windows.Forms.CheckBox()
			Me.pnlMain.SuspendLayout()
			Me.pnlControls.SuspendLayout()
			DirectCast(Me.fpSpread, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.fpSpread_Sheet1, System.ComponentModel.ISupportInitialize).BeginInit()
			Me.groupBox1.SuspendLayout()
			Me.tableLayoutPanel1.SuspendLayout()
			Me.groupBox2.SuspendLayout()
			Me.SuspendLayout()
			' 
			' pnlMain
			' 
			Me.pnlMain.Controls.Add(Me.fpSpread)
			' 
			' pnlControls
			' 
			Me.pnlControls.Controls.Add(Me.groupBox2)
			Me.pnlControls.Controls.Add(Me.groupBox1)
			' 
			' fpSpread
			' 
			Me.fpSpread.Dock = System.Windows.Forms.DockStyle.Fill
			Me.fpSpread.Location = New System.Drawing.Point(0, 0)
			Me.fpSpread.Name = "fpSpread"
			Me.fpSpread.Sheets.AddRange(New FarPoint.Win.Spread.SheetView() {Me.fpSpread_Sheet1})
			Me.fpSpread.Size = New System.Drawing.Size(477, 487)
			Me.fpSpread.Skin = FarPoint.Win.Spread.DefaultSpreadSkins.Office2016White
			Me.fpSpread.StatusBarVisible = True
			Me.fpSpread.TabIndex = 0
			' 
			' fpSpread_Sheet1
			' 
			Me.fpSpread_Sheet1.Reset()
			Me.fpSpread_Sheet1.SheetName = "Sheet1"
			' Formulas and custom names must be loaded with R1C1 reference style
			Me.fpSpread_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
			' 
			' groupBox1
			' 
			Me.groupBox1.Controls.Add(Me.tableLayoutPanel1)
			Me.groupBox1.Dock = System.Windows.Forms.DockStyle.Top
			Me.groupBox1.Location = New System.Drawing.Point(0, 0)
			Me.groupBox1.Name = "groupBox1"
			Me.groupBox1.Size = New System.Drawing.Size(157, 89)
			Me.groupBox1.TabIndex = 0
			Me.groupBox1.TabStop = False
			Me.groupBox1.Text = "Actions and Settings"
			' 
			' tableLayoutPanel1
			' 
			Me.tableLayoutPanel1.ColumnCount = 2
			Me.tableLayoutPanel1.ColumnStyles.Add(New System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 50F))
			Me.tableLayoutPanel1.ColumnStyles.Add(New System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 50F))
			Me.tableLayoutPanel1.Controls.Add(Me.btnUngroup, 1, 0)
			Me.tableLayoutPanel1.Controls.Add(Me.btnGroup, 0, 0)
			Me.tableLayoutPanel1.Controls.Add(Me.btnShowDetail, 0, 2)
			Me.tableLayoutPanel1.Controls.Add(Me.btnHideDetail, 1, 2)
			Me.tableLayoutPanel1.Dock = System.Windows.Forms.DockStyle.Fill
			Me.tableLayoutPanel1.Location = New System.Drawing.Point(3, 16)
			Me.tableLayoutPanel1.Name = "tableLayoutPanel1"
			Me.tableLayoutPanel1.RowCount = 3
			Me.tableLayoutPanel1.RowStyles.Add(New System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 30F))
			Me.tableLayoutPanel1.RowStyles.Add(New System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 10F))
			Me.tableLayoutPanel1.RowStyles.Add(New System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 30F))
			Me.tableLayoutPanel1.Size = New System.Drawing.Size(151, 70)
			Me.tableLayoutPanel1.TabIndex = 0
			' 
			' btnGroup
			' 
			Me.btnGroup.Dock = System.Windows.Forms.DockStyle.Fill
			Me.btnGroup.Location = New System.Drawing.Point(3, 3)
			Me.btnGroup.Name = "btnGroup"
			Me.btnGroup.Size = New System.Drawing.Size(69, 24)
			Me.btnGroup.TabIndex = 0
			Me.btnGroup.Text = "Group"
			Me.btnGroup.UseVisualStyleBackColor = True
			' 
			' btnUngroup
			' 
			Me.btnUngroup.Dock = System.Windows.Forms.DockStyle.Fill
			Me.btnUngroup.Location = New System.Drawing.Point(78, 3)
			Me.btnUngroup.Name = "btnUngroup"
			Me.btnUngroup.Size = New System.Drawing.Size(70, 24)
			Me.btnUngroup.TabIndex = 1
			Me.btnUngroup.Text = "Ungroup"
			Me.btnUngroup.UseVisualStyleBackColor = True
			' 
			' btnShowDetail
			' 
			Me.btnShowDetail.Dock = System.Windows.Forms.DockStyle.Fill
			Me.btnShowDetail.Location = New System.Drawing.Point(3, 43)
			Me.btnShowDetail.Name = "btnShowDetail"
			Me.btnShowDetail.Size = New System.Drawing.Size(69, 24)
			Me.btnShowDetail.TabIndex = 2
			Me.btnShowDetail.Text = "Show Detail"
			Me.btnShowDetail.UseVisualStyleBackColor = True
			' 
			' btnHideDetail
			' 
			Me.btnHideDetail.Dock = System.Windows.Forms.DockStyle.Fill
			Me.btnHideDetail.Location = New System.Drawing.Point(78, 43)
			Me.btnHideDetail.Name = "btnHideDetail"
			Me.btnHideDetail.Size = New System.Drawing.Size(70, 24)
			Me.btnHideDetail.TabIndex = 3
			Me.btnHideDetail.Text = "Hide Detail"
			Me.btnHideDetail.UseVisualStyleBackColor = True
			' 
			' 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.chkSummaryRight)
			Me.groupBox2.Controls.Add(Me.chkSummaryBelow)
			Me.groupBox2.Location = New System.Drawing.Point(0, 107)
			Me.groupBox2.Name = "groupBox2"
			Me.groupBox2.Size = New System.Drawing.Size(157, 89)
			Me.groupBox2.TabIndex = 1
			Me.groupBox2.TabStop = False
			Me.groupBox2.Text = "Direction"
			' 
			' chkSummaryBelow
			' 
			Me.chkSummaryBelow.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.chkSummaryBelow.Location = New System.Drawing.Point(6, 19)
			Me.chkSummaryBelow.Name = "chkSummaryBelow"
			Me.chkSummaryBelow.Size = New System.Drawing.Size(148, 30)
			Me.chkSummaryBelow.TabIndex = 0
			Me.chkSummaryBelow.Text = "Summary rows below detail"
			Me.chkSummaryBelow.UseVisualStyleBackColor = True
			' 
			' chkSummaryRight
			' 
			Me.chkSummaryRight.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.chkSummaryRight.Location = New System.Drawing.Point(6, 47)
			Me.chkSummaryRight.Name = "chkSummaryRight"
			Me.chkSummaryRight.Size = New System.Drawing.Size(153, 31)
			Me.chkSummaryRight.TabIndex = 1
			Me.chkSummaryRight.Text = "Summary columns to right of detail"
			Me.chkSummaryRight.UseVisualStyleBackColor = True
			' 
			' RangeGroupDemo
			' 
			Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
			Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
			Me.Name = "RangeGroupDemo"
			Me.pnlMain.ResumeLayout(False)
			Me.pnlControls.ResumeLayout(False)
			DirectCast(Me.fpSpread, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.fpSpread_Sheet1, System.ComponentModel.ISupportInitialize).EndInit()
			Me.groupBox1.ResumeLayout(False)
			Me.tableLayoutPanel1.ResumeLayout(False)
			Me.groupBox2.ResumeLayout(False)
			Me.ResumeLayout(False)

		End Sub

		#End Region

		Private fpSpread As FarPoint.Win.Spread.FpSpread
		Private fpSpread_Sheet1 As FarPoint.Win.Spread.SheetView
		Private groupBox1 As System.Windows.Forms.GroupBox
		Private tableLayoutPanel1 As System.Windows.Forms.TableLayoutPanel
		Private btnUngroup As System.Windows.Forms.Button
		Private btnGroup As System.Windows.Forms.Button
		Private btnShowDetail As System.Windows.Forms.Button
		Private btnHideDetail As System.Windows.Forms.Button
		Private groupBox2 As System.Windows.Forms.GroupBox
		Private chkSummaryRight As System.Windows.Forms.CheckBox
		Private chkSummaryBelow As System.Windows.Forms.CheckBox
	End Class
End Namespace
