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
Imports FarPoint.Win.Spread
Imports FarPoint.Win.Spread.CellType
Imports FarPoint.Win.Spread.Design
Imports FarPoint.Win.Spread.Model
Imports Spread.Common.Features.Spread.Common.Features.Sample

Namespace Features
    Partial Public Class BordersDemo
        Inherits BaseSampleControl
        Private LineStyleArray As ComplexBorderSideStyle() = New ComplexBorderSideStyle() {ComplexBorderSideStyle.DashDotDot, ComplexBorderSideStyle.MediumLine, ComplexBorderSideStyle.ThinLine, ComplexBorderSideStyle.DoubleLine}
        Private ColorArray As Color() = New Color() {Color.Red, Color.Green, Color.Blue, Color.Black}
        Public Sub New()
            InitializeComponent()
            InitializeControls()
            SetupSpreadSheet()
        End Sub
        Private Sub InitializeControls()
            Name = "Borders and GridLines"
            borderStyleComboBox.DataSource = [Enum].GetValues(GetType(ComplexBorderSideStyle))

            Dim _properties As System.Reflection.PropertyInfo() = GetType(Color).GetProperties(System.Reflection.BindingFlags.[Public] Or System.Reflection.BindingFlags.[Static])
            For Each _property As System.Reflection.PropertyInfo In _properties
                borderColorComboBox.Items.Add(_property.Name)
                gridLineColorComboBox.Items.Add(_property.Name)
            Next
            borderColorComboBox.SelectedIndex = 0
            gridLineColorComboBox.SelectedItem = spread.ActiveSheet.VerticalGridLine.Color.ToKnownColor().ToString()

            Dim _textRotationArray As Integer() = {0, 30, 45, 60, 90}
            textRotationComboBox.DataSource = _textRotationArray
            textRotationComboBox.SelectedIndex = -1
            textRotationComboBox.DropDownStyle = ComboBoxStyle.DropDownList

            diagonalLineCKB.Checked = True
            gridLineCKB.Checked = True
        End Sub
        Private Sub SetupSpreadSheet()
            spread.ActiveSheet = spread.Sheets(0)
            Dim index As Integer = 0
            Dim count As Integer = 0
            Dim row As Integer = 1
            While row <= 10
                count = 0
                For _row As Integer = row To row + 1
                    For _column As Integer = 1 To 2
                        SetBorder(sheetView.Cells(_row, _column), New ComplexBorderSide(GetBorderLineStyle(index), GetColor(index + count)))
                        count += 1
                    Next
                Next
                index += 1
                row = row + 3
            End While
            SetCellsBorder(New Cell() {sheetView.Cells(1, 4), sheetView.Cells(1, 5), sheetView.Cells(2, 4), sheetView.Cells(2, 5)}, 0)
            SetCellsBorder(New Cell() {sheetView.Cells(4, 4), sheetView.Cells(4, 5), sheetView.Cells(5, 4), sheetView.Cells(5, 5)}, 1)
            SetCellsBorder(New Cell() {sheetView.Cells(7, 4), sheetView.Cells(7, 5), sheetView.Cells(8, 4), sheetView.Cells(8, 5)}, 2)
            SetCellsBorder(New Cell() {sheetView.Cells(10, 4), sheetView.Cells(10, 5), sheetView.Cells(11, 4), sheetView.Cells(11, 5)}, 3)

            index = 0
            Dim row1 As Integer = 1
            While row1 <= 10
                count = 0
                For _row As Integer = row1 To row1 + 1
                    For _column As Integer = 7 To 8
                        SetCellBorder(sheetView.Cells(_row, _column), index + count)
                        count += 1
                    Next
                Next
                index += 1
                row1 = row1 + 3
            End While

            Dim rowIndex As Integer = 14
            sheetView.Cells(rowIndex, 2).RowSpan = 5
            sheetView.Cells(rowIndex, 2).ColumnSpan = 6
            sheetView.Cells(rowIndex, 2).Border = New ComplexBorder(New ComplexBorderSide(ComplexBorderSideStyle.DashDot, Color.Purple))
            SetMergeCellBorder(rowIndex)

            rowIndex += 8
            sheetView.Cells(rowIndex, 2).RowSpan = 5
            sheetView.Cells(rowIndex, 2).ColumnSpan = 6
            sheetView.Cells(rowIndex, 2).Border = New ComplexBorder(New ComplexBorderSide(ComplexBorderSideStyle.DoubleLine, Color.Purple))
            SetMergeCellBorder(rowIndex)

            rowIndex += 8
            sheetView.Cells(rowIndex, 2).RowSpan = 5
            sheetView.Cells(rowIndex, 2).ColumnSpan = 6
            sheetView.Cells(rowIndex, 2).Border = New ComplexBorder(New ComplexBorderSide(ComplexBorderSideStyle.ThickLine, Color.Purple))
            SetMergeCellBorder(rowIndex)

            rowIndex += 8
            sheetView.Cells(rowIndex, 2).RowSpan = 5
            sheetView.Cells(rowIndex, 2).ColumnSpan = 6
            sheetView.Cells(rowIndex, 2).Border = New ComplexBorder(New ComplexBorderSide(ComplexBorderSideStyle.MediumLine, Color.Purple))
            SetMergeCellBorder(rowIndex)

            SetBorder(sheetView.Cells(3, 3), New ComplexBorderSide(ComplexBorderSideStyle.MediumLine, Color.Black), True)
            SetBorder(sheetView.Cells(6, 3), New ComplexBorderSide(ComplexBorderSideStyle.MediumLine, Color.Black), True)
            SetBorder(sheetView.Cells(9, 3), New ComplexBorderSide(ComplexBorderSideStyle.MediumLine, Color.Black), True)
            SetBorder(sheetView.Cells(3, 6), New ComplexBorderSide(ComplexBorderSideStyle.MediumDashDot, Color.Black), True)
            SetBorder(sheetView.Cells(6, 6), New ComplexBorderSide(ComplexBorderSideStyle.MediumDashDotDot, Color.Black), True)
            SetBorder(sheetView.Cells(9, 6), New ComplexBorderSide(ComplexBorderSideStyle.MediumDashDot, Color.Black), True)

            Dim _count As Integer = LineStyleArray.Length
            For _left As Integer = 0 To _count - 1
                Dim _rows As Integer = 0
                For _top As Integer = 0 To _count - 1
                    For _right As Integer = 0 To _count - 1
                        For _bottom As Integer = 0 To _count - 1
                            sheetView.Cells(_rows, _left * 2 + 10).Border = If(_left = _count, Nothing, New ComplexBorder(New ComplexBorderSide(GetBorderLineStyle(_left), GetColor(_left))))
                            sheetView.Cells(_rows, _left * 2 + 11).Border = If(_top = _count, Nothing, New ComplexBorder(New ComplexBorderSide(GetBorderLineStyle(_top), GetColor(_top))))
                            sheetView.Cells(_rows, _left * 2 + 11).Border = If(_right = _count, Nothing, New ComplexBorder(New ComplexBorderSide(GetBorderLineStyle(_right), GetColor(_right))))
                            sheetView.Cells(_rows + 1, _left * 2 + 10).Border = If(_bottom = _count, Nothing, New ComplexBorder(New ComplexBorderSide(GetBorderLineStyle(_bottom), GetColor(_bottom))))
                            _rows += 2
                        Next
                    Next
                Next
            Next

            secondSheetView.Rows(4).Height = 50
            SetRotateText(secondSheetView.Cells(4, 2), "First Name", 45)
            SetRotateText(secondSheetView.Cells(4, 3), "Last Name", 45)
            SetRotateText(secondSheetView.Cells(4, 4), "Age", 45)
            SetRotateText(secondSheetView.Cells(4, 5), "Gender", 45)
            SetRotateText(secondSheetView.Cells(4, 6), "Score", 45)

            For _column As Integer = 2 To 6
                SetBorder(secondSheetView.Cells(4, _column), New ComplexBorderSide(ComplexBorderSideStyle.MediumLine, Color.Black), True)
            Next


            secondSheetView.Cells(5, 2).Text = "John"
            secondSheetView.Cells(5, 3).Text = "Smith"
            secondSheetView.Cells(5, 4).Text = "18"
            secondSheetView.Cells(5, 5).Text = "Male"
            secondSheetView.Cells(5, 6).Text = "80"

            secondSheetView.Cells(6, 2).Text = "Micheal"
            secondSheetView.Cells(6, 3).Text = "Chang"
            secondSheetView.Cells(6, 4).Text = "21"
            secondSheetView.Cells(6, 5).Text = "Male"
            secondSheetView.Cells(6, 6).Text = "85"

            secondSheetView.Cells(7, 2).Text = "Jessica"
            secondSheetView.Cells(7, 3).Text = "Alba"
            secondSheetView.Cells(7, 4).Text = "23"
            secondSheetView.Cells(7, 5).Text = "Female"
            secondSheetView.Cells(7, 6).Text = "90"
        End Sub
        Private Sub DiagonalLineCKB_CheckedChanged(sender As Object, e As EventArgs)
            spread.ActiveSheet.EnableDiagonalLine = diagonalLineCKB.Checked
        End Sub

        Private Sub SetGridLineButton_Click(sender As Object, e As EventArgs)
            If gridLineCKB.Checked Then
                spread.ActiveSheet.VerticalGridLine = New GridLine(GridLineType.Flat, GetColor(gridLineColorComboBox.SelectedItem.ToString()))
                spread.ActiveSheet.HorizontalGridLine = New GridLine(GridLineType.Flat, GetColor(gridLineColorComboBox.SelectedItem.ToString()))
            Else
                spread.ActiveSheet.VerticalGridLine = New GridLine(GridLineType.None, GetColor(gridLineColorComboBox.SelectedItem.ToString()))
                spread.ActiveSheet.HorizontalGridLine = New GridLine(GridLineType.None, GetColor(gridLineColorComboBox.SelectedItem.ToString()))
            End If
            Console.WriteLine(gridLineColorComboBox.SelectedItem)
        End Sub

        Private Sub Spread_ActiveSheetChanged(sender As Object, e As EventArgs)
            gridLineCKB.Checked = spread.ActiveSheet.VerticalGridLine.Type <> GridLineType.None
            gridLineColorComboBox.SelectedItem = spread.ActiveSheet.VerticalGridLine.Color.ToKnownColor().ToString()
            diagonalLineCKB.Checked = spread.ActiveSheet.EnableDiagonalLine
        End Sub

        Private Sub SetButton_Click(sender As Object, e As EventArgs)
            Dim cellRanges As CellRange() = spread.ActiveSheet.GetSelections()
            For Each cellRange As CellRange In cellRanges
                Dim range As CellRange = GetActualCellRange(cellRange, spread.ActiveSheet.RowCount, spread.ActiveSheet.ColumnCount)
                For _row As Integer = range.Row To range.Row + (range.RowCount - 1)
                    For _column As Integer = range.Column To range.Column + (range.ColumnCount - 1)
                        spread.ActiveSheet.Cells(_row, _column).Border = New ComplexBorder(New ComplexBorderSide(CType(borderStyleComboBox.SelectedItem, ComplexBorderSideStyle), GetColor(borderColorComboBox.SelectedItem.ToString())))
                    Next
                Next
            Next
        End Sub
        Private Sub TextRotationComboBox_SelectedIndexChanged(sender As Object, e As EventArgs)
            Dim cellRanges As CellRange() = spread.ActiveSheet.GetSelections()
            For Each cellRange As CellRange In cellRanges
                Dim range As CellRange = GetActualCellRange(cellRange, spread.ActiveSheet.RowCount, spread.ActiveSheet.ColumnCount)
                For _row As Integer = range.Row To range.Row + (range.RowCount - 1)
                    For _column As Integer = range.Column To range.Column + (range.ColumnCount - 1)
                        Dim _textCell As New TextCellType()
                        _textCell.TextOrientation = TextOrientation.TextRotateCustom
                        _textCell.TextRotationAngle = Integer.Parse(textRotationComboBox.SelectedItem.ToString())
                        spread.ActiveSheet.Cells(_row, _column).CellType = _textCell
                    Next
                Next
            Next
        End Sub
        Private Sub SetBorderButton_Click(sender As Object, e As EventArgs)
            ExternalDialogs.BorderEditor(spread)
        End Sub

        Private Sub _borderEditor_ApplyChanged(sender As Object, e As ApplyBorderEventArgs)
            Dim cellRanges As CellRange() = spread.ActiveSheet.GetSelections()
            For Each cellRange As CellRange In cellRanges
                Dim range As CellRange = GetActualCellRange(cellRange, spread.ActiveSheet.RowCount, spread.ActiveSheet.ColumnCount)
                For _row As Integer = range.Row To range.Row + (range.RowCount - 1)
                    For _column As Integer = range.Column To range.Column + (range.ColumnCount - 1)
                        spread.ActiveSheet.Cells(_row, _column).Border = e.Border
                    Next
                Next
            Next
        End Sub

        Private Sub ClearBorderButton_Click(sender As Object, e As EventArgs)
            Dim _activeSheet As SheetView = spread.ActiveSheet
            Dim _cellRanges As CellRange() = _activeSheet.GetSelections()
            For Each _cellRange As CellRange In _cellRanges
                Dim _range As CellRange = GetActualCellRange(_cellRange, _activeSheet.RowCount, _activeSheet.ColumnCount)
                For i As Integer = 0 To _range.RowCount - 1
                    For j As Integer = 0 To _range.ColumnCount - 1
                        SetBorder(_activeSheet.Cells(i + _range.Row, j + _range.Column), Nothing)
                    Next
                Next
            Next
        End Sub

        Private Sub SetRotateText(_cell As Cell, _text As String, _angle As Integer)
            Dim _textCellType As New TextCellType()
            _textCellType.TextOrientation = TextOrientation.TextRotateCustom
            _textCellType.TextRotationAngle = _angle
            _cell.CellType = _textCellType
            _cell.Text = _text
        End Sub
        Private Sub SetMergeCellBorder(rowIndex As Integer)
            SetBorder(sheetView.Cells(rowIndex - 1, 3), New ComplexBorderSide(ComplexBorderSideStyle.DashDotDot, Color.Red))
            SetBorder(sheetView.Cells(rowIndex - 1, 6), New ComplexBorderSide(ComplexBorderSideStyle.DoubleLine, Color.Green))
            SetBorder(sheetView.Cells(rowIndex + 1, 8), New ComplexBorderSide(ComplexBorderSideStyle.ThickLine, Color.Blue))
            SetBorder(sheetView.Cells(rowIndex + 3, 8), New ComplexBorderSide(ComplexBorderSideStyle.MediumLine, Color.Black))
            SetBorder(sheetView.Cells(rowIndex + 5, 6), New ComplexBorderSide(ComplexBorderSideStyle.MediumLine, Color.Red))
            SetBorder(sheetView.Cells(rowIndex + 5, 3), New ComplexBorderSide(ComplexBorderSideStyle.ThickLine, Color.Green))
            SetBorder(sheetView.Cells(rowIndex + 3, 1), New ComplexBorderSide(ComplexBorderSideStyle.DoubleLine, Color.Blue))
            SetBorder(sheetView.Cells(rowIndex + 1, 1), New ComplexBorderSide(ComplexBorderSideStyle.DashDotDot, Color.Black))
        End Sub
        Private Function GetColor(index As Integer) As Color
            Return ColorArray(index Mod ColorArray.Length)
        End Function
        Private Function GetColor(name As String) As Color
            Return CType(GetType(Color).GetProperty(name).GetValue(Nothing, Nothing), Color)
        End Function
        Private Function GetActualCellRange(cellRange As CellRange, rowCount As Integer, columnCount As Integer) As CellRange
            If cellRange.Row = -1 AndAlso cellRange.Column = -1 Then
                Return New CellRange(0, 0, rowCount, columnCount)
            ElseIf cellRange.Row = -1 Then
                Return New CellRange(0, cellRange.Column, rowCount, cellRange.ColumnCount)
            ElseIf cellRange.Column = -1 Then
                Return New CellRange(cellRange.Row, 0, cellRange.RowCount, columnCount)
            End If

            Return cellRange
        End Function
        Private Function GetBorderLineStyle(index As Integer) As ComplexBorderSideStyle
            Return LineStyleArray(index Mod LineStyleArray.Length)
        End Function
        Private Sub SetCellsBorder(cells As Cell(), index As Integer)
            For Each cell As Cell In cells
                SetCellBorder(cell, index)
            Next
        End Sub
        Private Sub SetCellBorder(cell As Cell, index As Integer)
            Dim left As New ComplexBorderSide(GetBorderLineStyle(index + 0), GetColor(index + 0))
            Dim top As New ComplexBorderSide(GetBorderLineStyle(index + 1), GetColor(index + 1))
            Dim right As New ComplexBorderSide(GetBorderLineStyle(index + 2), GetColor(index + 2))
            Dim bottom As New ComplexBorderSide(GetBorderLineStyle(index + 3), GetColor(index + 3))
            cell.Border = New ComplexBorder(left, top, right, bottom)
        End Sub
        Private Sub SetBorder(_cell As Cell, _border As ComplexBorderSide)
            SetBorder(_cell, _border, False)
        End Sub
        Private Sub SetBorder(_cell As Cell, _border As ComplexBorderSide, _diagonalLine As Boolean)
            If _border Is Nothing Then
                _cell.ResetBorder()
            Else

                If Not _diagonalLine Then
                    _cell.Border = New ComplexBorder(_border, _border, _border, _border)
                Else

                    _cell.Border = New ComplexBorder(_border, _border, _border, _border, _border, True,
                        True)
                End If
            End If
        End Sub
    End Class
End Namespace

'
'BordersDemo.Designer.vb
'

Imports FarPoint.Win.Spread
Namespace Features
	Partial Class BordersDemo
		''' <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.gridLinesGroupBox = New System.Windows.Forms.GroupBox()
			Me.setGridLineButton = New System.Windows.Forms.Button()
			Me.gridLineColorComboBox = New System.Windows.Forms.ComboBox()
			Me.gridLineColorLabel = New System.Windows.Forms.Label()
			Me.gridLineCKB = New System.Windows.Forms.CheckBox()
			Me.textRotationGroupBox = New System.Windows.Forms.GroupBox()
			Me.textRotationComboBox = New System.Windows.Forms.ComboBox()
			Me.textRotationLabel = New System.Windows.Forms.Label()
			Me.diagonalLineCKB = New System.Windows.Forms.CheckBox()
			Me.quickSettingGroupBox = New System.Windows.Forms.GroupBox()
			Me.setButton = New System.Windows.Forms.Button()
			Me.borderColorComboBox = New System.Windows.Forms.ComboBox()
			Me.borderColorLabel = New System.Windows.Forms.Label()
			Me.borderStyleComboBox = New System.Windows.Forms.ComboBox()
			Me.borderStyleLabel = New System.Windows.Forms.Label()
			Me.clearBorderButton = New System.Windows.Forms.Button()
			Me.setBorderButton = New System.Windows.Forms.Button()
			Me.spread = New FarPoint.Win.Spread.FpSpread()
			Me.sheetView = New FarPoint.Win.Spread.SheetView()
			Me.secondSheetView = New FarPoint.Win.Spread.SheetView()
			Me.pnlMain.SuspendLayout()
			Me.pnlControls.SuspendLayout()
			Me.gridLinesGroupBox.SuspendLayout()
			Me.textRotationGroupBox.SuspendLayout()
			Me.quickSettingGroupBox.SuspendLayout()
			DirectCast(Me.spread, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.sheetView, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.secondSheetView, System.ComponentModel.ISupportInitialize).BeginInit()
			Me.SuspendLayout()
			' 
			' pnlMain
			' 
			Me.pnlMain.Controls.Add(Me.spread)
			Me.pnlMain.Size = New System.Drawing.Size(481, 611)
			' 
			' pnlControls
			' 
			Me.pnlControls.AutoScroll = True
			Me.pnlControls.Controls.Add(Me.gridLinesGroupBox)
			Me.pnlControls.Controls.Add(Me.setBorderButton)
			Me.pnlControls.Controls.Add(Me.textRotationGroupBox)
			Me.pnlControls.Controls.Add(Me.clearBorderButton)
			Me.pnlControls.Controls.Add(Me.quickSettingGroupBox)
			Me.pnlControls.Size = New System.Drawing.Size(159, 611)
			' 
			' gridLinesGroupBox
			' 
			Me.gridLinesGroupBox.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.gridLinesGroupBox.Controls.Add(Me.setGridLineButton)
			Me.gridLinesGroupBox.Controls.Add(Me.gridLineColorComboBox)
			Me.gridLinesGroupBox.Controls.Add(Me.gridLineColorLabel)
			Me.gridLinesGroupBox.Controls.Add(Me.gridLineCKB)
			Me.gridLinesGroupBox.Location = New System.Drawing.Point(16, 422)
			Me.gridLinesGroupBox.Name = "gridLinesGroupBox"
			Me.gridLinesGroupBox.Size = New System.Drawing.Size(136, 171)
			Me.gridLinesGroupBox.TabIndex = 4
			Me.gridLinesGroupBox.TabStop = False
			Me.gridLinesGroupBox.Text = "GridLines"
			' 
			' setGridLineButton
			' 
			Me.setGridLineButton.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.setGridLineButton.AutoSizeMode = System.Windows.Forms.AutoSizeMode.GrowAndShrink
			Me.setGridLineButton.Location = New System.Drawing.Point(16, 127)
			Me.setGridLineButton.Name = "setGridLineButton"
			Me.setGridLineButton.Size = New System.Drawing.Size(101, 23)
			Me.setGridLineButton.TabIndex = 3
			Me.setGridLineButton.Text = "Set GridLine"
			Me.setGridLineButton.UseVisualStyleBackColor = True
			AddHandler Me.setGridLineButton.Click, New System.EventHandler(AddressOf Me.SetGridLineButton_Click)
			' 
			' gridLineColorComboBox
			' 
			Me.gridLineColorComboBox.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.gridLineColorComboBox.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
			Me.gridLineColorComboBox.FormattingEnabled = True
			Me.gridLineColorComboBox.Location = New System.Drawing.Point(16, 100)
			Me.gridLineColorComboBox.Name = "gridLineColorComboBox"
			Me.gridLineColorComboBox.Size = New System.Drawing.Size(101, 21)
			Me.gridLineColorComboBox.TabIndex = 2
			' 
			' gridLineColorLabel
			' 
			Me.gridLineColorLabel.AutoSize = True
			Me.gridLineColorLabel.Location = New System.Drawing.Point(15, 74)
			Me.gridLineColorLabel.Name = "gridLineColorLabel"
			Me.gridLineColorLabel.Size = New System.Drawing.Size(76, 13)
			Me.gridLineColorLabel.TabIndex = 1
			Me.gridLineColorLabel.Text = "GridLine Color:"
			' 
			' gridLineCKB
			' 
			Me.gridLineCKB.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.gridLineCKB.Location = New System.Drawing.Point(13, 20)
			Me.gridLineCKB.Name = "gridLineCKB"
			Me.gridLineCKB.Size = New System.Drawing.Size(104, 51)
			Me.gridLineCKB.TabIndex = 0
			Me.gridLineCKB.Text = "GridLine Visible"
			Me.gridLineCKB.UseVisualStyleBackColor = True
			' 
			' textRotationGroupBox
			' 
			Me.textRotationGroupBox.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.textRotationGroupBox.Controls.Add(Me.textRotationComboBox)
			Me.textRotationGroupBox.Controls.Add(Me.textRotationLabel)
			Me.textRotationGroupBox.Controls.Add(Me.diagonalLineCKB)
			Me.textRotationGroupBox.Location = New System.Drawing.Point(16, 242)
			Me.textRotationGroupBox.Name = "textRotationGroupBox"
			Me.textRotationGroupBox.Size = New System.Drawing.Size(136, 160)
			Me.textRotationGroupBox.TabIndex = 3
			Me.textRotationGroupBox.TabStop = False
			Me.textRotationGroupBox.Text = "Diagonal Line and Text Rotation"
			' 
			' textRotationComboBox
			' 
			Me.textRotationComboBox.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.textRotationComboBox.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
			Me.textRotationComboBox.FormattingEnabled = True
			Me.textRotationComboBox.Location = New System.Drawing.Point(13, 133)
			Me.textRotationComboBox.Name = "textRotationComboBox"
			Me.textRotationComboBox.Size = New System.Drawing.Size(104, 21)
			Me.textRotationComboBox.TabIndex = 2
			AddHandler Me.textRotationComboBox.SelectedIndexChanged, New System.EventHandler(AddressOf Me.TextRotationComboBox_SelectedIndexChanged)
			' 
			' textRotationLabel
			' 
			Me.textRotationLabel.AutoSize = True
			Me.textRotationLabel.Location = New System.Drawing.Point(10, 105)
			Me.textRotationLabel.Name = "textRotationLabel"
			Me.textRotationLabel.Size = New System.Drawing.Size(71, 13)
			Me.textRotationLabel.TabIndex = 1
			Me.textRotationLabel.Text = "Text Rotation"
			' 
			' diagonalLineCKB
			' 
			Me.diagonalLineCKB.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.diagonalLineCKB.Location = New System.Drawing.Point(6, 38)
			Me.diagonalLineCKB.Name = "diagonalLineCKB"
			Me.diagonalLineCKB.Size = New System.Drawing.Size(111, 64)
			Me.diagonalLineCKB.TabIndex = 0
			Me.diagonalLineCKB.Text = "Enable diagonal line"
			Me.diagonalLineCKB.UseVisualStyleBackColor = True
			AddHandler Me.diagonalLineCKB.CheckedChanged, New System.EventHandler(AddressOf Me.DiagonalLineCKB_CheckedChanged)
			' 
			' quickSettingGroupBox
			' 
			Me.quickSettingGroupBox.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.quickSettingGroupBox.Controls.Add(Me.setButton)
			Me.quickSettingGroupBox.Controls.Add(Me.borderColorComboBox)
			Me.quickSettingGroupBox.Controls.Add(Me.borderColorLabel)
			Me.quickSettingGroupBox.Controls.Add(Me.borderStyleComboBox)
			Me.quickSettingGroupBox.Controls.Add(Me.borderStyleLabel)
			Me.quickSettingGroupBox.Location = New System.Drawing.Point(16, 61)
			Me.quickSettingGroupBox.Name = "quickSettingGroupBox"
			Me.quickSettingGroupBox.Size = New System.Drawing.Size(136, 163)
			Me.quickSettingGroupBox.TabIndex = 2
			Me.quickSettingGroupBox.TabStop = False
			Me.quickSettingGroupBox.Text = "Quick Setting"
			' 
			' setButton
			' 
			Me.setButton.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.setButton.Location = New System.Drawing.Point(13, 134)
			Me.setButton.Name = "setButton"
			Me.setButton.Size = New System.Drawing.Size(104, 23)
			Me.setButton.TabIndex = 4
			Me.setButton.Text = "Set"
			Me.setButton.UseVisualStyleBackColor = True
			AddHandler Me.setButton.Click, New System.EventHandler(AddressOf Me.SetButton_Click)
			' 
			' borderColorComboBox
			' 
			Me.borderColorComboBox.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.borderColorComboBox.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
			Me.borderColorComboBox.FormattingEnabled = True
			Me.borderColorComboBox.Location = New System.Drawing.Point(13, 96)
			Me.borderColorComboBox.Name = "borderColorComboBox"
			Me.borderColorComboBox.Size = New System.Drawing.Size(104, 21)
			Me.borderColorComboBox.TabIndex = 3
			' 
			' borderColorLabel
			' 
			Me.borderColorLabel.AutoSize = True
			Me.borderColorLabel.Location = New System.Drawing.Point(10, 79)
			Me.borderColorLabel.Name = "borderColorLabel"
			Me.borderColorLabel.Size = New System.Drawing.Size(68, 13)
			Me.borderColorLabel.TabIndex = 2
			Me.borderColorLabel.Text = "Border Color:"
			' 
			' borderStyleComboBox
			' 
			Me.borderStyleComboBox.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.borderStyleComboBox.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
			Me.borderStyleComboBox.FormattingEnabled = True
			Me.borderStyleComboBox.Location = New System.Drawing.Point(10, 37)
			Me.borderStyleComboBox.Name = "borderStyleComboBox"
			Me.borderStyleComboBox.Size = New System.Drawing.Size(107, 21)
			Me.borderStyleComboBox.TabIndex = 1
			' 
			' borderStyleLabel
			' 
			Me.borderStyleLabel.AutoSize = True
			Me.borderStyleLabel.Location = New System.Drawing.Point(7, 20)
			Me.borderStyleLabel.Name = "borderStyleLabel"
			Me.borderStyleLabel.Size = New System.Drawing.Size(67, 13)
			Me.borderStyleLabel.TabIndex = 0
			Me.borderStyleLabel.Text = "Border Style:"
			' 
			' clearBorderButton
			' 
			Me.clearBorderButton.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.clearBorderButton.Location = New System.Drawing.Point(16, 32)
			Me.clearBorderButton.Name = "clearBorderButton"
			Me.clearBorderButton.Size = New System.Drawing.Size(136, 23)
			Me.clearBorderButton.TabIndex = 1
			Me.clearBorderButton.Text = "Clear Border"
			Me.clearBorderButton.UseVisualStyleBackColor = True
			AddHandler Me.clearBorderButton.Click, New System.EventHandler(AddressOf Me.ClearBorderButton_Click)
			' 
			' setBorderButton
			' 
			Me.setBorderButton.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.setBorderButton.Location = New System.Drawing.Point(16, 3)
			Me.setBorderButton.Name = "setBorderButton"
			Me.setBorderButton.Size = New System.Drawing.Size(136, 23)
			Me.setBorderButton.TabIndex = 0
			Me.setBorderButton.Text = "Set Border"
			Me.setBorderButton.UseVisualStyleBackColor = True
			AddHandler Me.setBorderButton.Click, New System.EventHandler(AddressOf Me.SetBorderButton_Click)
			' 
			' spread
			' 
			Me.spread.Dock = System.Windows.Forms.DockStyle.Fill
			Me.spread.Location = New System.Drawing.Point(0, 0)
			Me.spread.Name = "spread"
			Me.spread.Sheets.AddRange(New FarPoint.Win.Spread.SheetView() {Me.sheetView, Me.secondSheetView})
			Me.spread.Size = New System.Drawing.Size(481, 611)
			Me.spread.TabIndex = 0
			AddHandler Me.spread.ActiveSheetChanged, New System.EventHandler(AddressOf Me.Spread_ActiveSheetChanged)
			Me.spread.ActiveSheetIndex = 1
			' 
			' sheetView
			' 
			Me.sheetView.Reset()
			Me.sheetView.SheetName = "Basic border"
			' Formulas and custom names must be loaded with R1C1 reference style
			Me.sheetView.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
			Me.sheetView.EnableDiagonalLine = True
			Me.sheetView.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
			' 
			' secondSheetView
			' 
			Me.secondSheetView.Reset()
			Me.secondSheetView.SheetName = "Advanced Border"
			' Formulas and custom names must be loaded with R1C1 reference style
			Me.secondSheetView.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
			Me.secondSheetView.EnableDiagonalLine = True
			Me.secondSheetView.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
			' 
			' BordersDemo
			' 
			Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
			Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
			Me.Name = "BordersDemo"
			Me.Size = New System.Drawing.Size(641, 611)
			Me.pnlMain.ResumeLayout(False)
			Me.pnlControls.ResumeLayout(False)
			Me.gridLinesGroupBox.ResumeLayout(False)
			Me.gridLinesGroupBox.PerformLayout()
			Me.textRotationGroupBox.ResumeLayout(False)
			Me.textRotationGroupBox.PerformLayout()
			Me.quickSettingGroupBox.ResumeLayout(False)
			Me.quickSettingGroupBox.PerformLayout()
			DirectCast(Me.spread, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.sheetView, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.secondSheetView, System.ComponentModel.ISupportInitialize).EndInit()
			Me.ResumeLayout(False)

		End Sub

		#End Region
		Private setBorderButton As System.Windows.Forms.Button
		Private clearBorderButton As System.Windows.Forms.Button
		Private quickSettingGroupBox As System.Windows.Forms.GroupBox
		Private setButton As System.Windows.Forms.Button
		Private borderColorComboBox As System.Windows.Forms.ComboBox
		Private borderColorLabel As System.Windows.Forms.Label
		Private borderStyleComboBox As System.Windows.Forms.ComboBox
		Private borderStyleLabel As System.Windows.Forms.Label
		Private textRotationGroupBox As System.Windows.Forms.GroupBox
		Private textRotationComboBox As System.Windows.Forms.ComboBox
		Private textRotationLabel As System.Windows.Forms.Label
		Private diagonalLineCKB As System.Windows.Forms.CheckBox
		Private gridLinesGroupBox As System.Windows.Forms.GroupBox
		Private gridLineColorComboBox As System.Windows.Forms.ComboBox
		Private gridLineColorLabel As System.Windows.Forms.Label
		Private gridLineCKB As System.Windows.Forms.CheckBox
		Private spread As FpSpread
		Private sheetView As SheetView
		Private setGridLineButton As System.Windows.Forms.Button
		Private secondSheetView As SheetView
	End Class
End Namespace

