Imports System.Drawing
Imports System.Linq
Imports System.Windows.Forms
Imports FarPoint.Win.Spread
Imports Spread.Common.DataStore
Imports Spread.Common.Features.Spread.Common.Features.Sample

Namespace Features
    Partial Public Class FilterIntro
        Inherits BaseSampleControl
#Region "Fields"
        Private _dataSource As AccessDataSource
        Private _prevComboColIndex As Integer = -1
#End Region

#Region "ctor"
        Public Sub New()
            InitializeComponent()
            Name = "Introduction"
            _dataSource = New DataService().AccessDataSource

            InitSpreadSheet(fpSpread.ActiveSheet)
            InitControls()

            AddHandler chkTextCondition.CheckedChanged, AddressOf ChkTextCondition_CheckedChanged
            AddHandler chkNumberCondition.CheckedChanged, AddressOf ChkNumberCondition_CheckedChanged
            AddHandler chkDateCondition.CheckedChanged, AddressOf ChkDateCondition_CheckedChanged
            AddHandler chkStyleCondition.CheckedChanged, AddressOf ChkStyleCondition_CheckedChanged
            AddHandler chkCustomCondition.CheckedChanged, AddressOf ChkCustomCondition_CheckedChanged
        End Sub
#End Region

        Private Sub InitSpreadSheet(sheet As SheetView)
            sheet.DataSource = _dataSource.GetDataFrom("fpWine.mdb", "select OrderID, CustomerID," & "SalesPerson, OrderDate, ShippedDate, Freight from Orders")

            sheet.Columns(2).Width = 120
            sheet.Columns(3, 4).Width = 80
            sheet.Columns(5).Width = 70

            sheet.SetMultipleRowHeights(0, sheet.RowCount, 20)

            Dim random As New Random()
            Dim colors = [Enum].GetValues(GetType(KnownColor))
            Dim row As Integer = random.[Next](0, 4)
            While row < sheet.RowCount
                sheet.Cells(row, 1).BackColor = Color.FromKnownColor(CType(colors.GetValue(random.[Next](27, colors.GetUpperBound(0) + 1)), KnownColor))
                row += random.[Next](1, 5)
            End While

            Dim hideRowFilter As New HideRowFilter(sheet)
            For col As Integer = 0 To sheet.ColumnCount - 1
                hideRowFilter.ColumnDefinitions.Add(New FilterColumnDefinition(col, FilterListBehavior.[Custom]))
                sheet.Columns(col).Tag = sheet.Columns(col).Label
            Next
            sheet.RowFilter = hideRowFilter
            sheet.RowFilter.ShowFilterIndicator = False

            sheet.AutoFilter = True
        End Sub

        Private Sub InitControls()
            Dim columns As String() = New String(fpSpread.ActiveSheet.ColumnCount - 1) {}
            For col As Integer = 0 To fpSpread.ActiveSheet.ColumnCount - 1
                columns(col) = fpSpread.ActiveSheet.Columns(col).Label
            Next

            comboTextCol.DataSource = columns
            comboTextCol.SelectedItem = "SalesPerson"
            AddHandler comboTextCol.Click, AddressOf ComboColClicked
            AddHandler comboTextCol.SelectedIndexChanged, AddressOf ComboTextCol_SelectedIndexChanged

            comboNumberCol.DataSource = columns.ToList()
            comboNumberCol.SelectedItem = "Freight"
            AddHandler comboNumberCol.SelectedIndexChanged, AddressOf ComboNumberCol_SelectedIndexChanged
            AddHandler comboNumberCol.Click, AddressOf ComboColClicked

            comboDateCol.DataSource = New String() {"OrderDate", "ShippedDate"}
            comboDateCol.SelectedItem = "OrderDate"
            AddHandler comboDateCol.Click, AddressOf ComboColClicked
            AddHandler comboDateCol.SelectedIndexChanged, AddressOf ComboDateCol_SelectedIndexChanged

            comboCustomCol.DataSource = columns.ToList()
            comboCustomCol.SelectedItem = "ShippedDate"
            AddHandler comboCustomCol.Click, AddressOf ComboColClicked
            AddHandler comboCustomCol.SelectedIndexChanged, AddressOf ComboCustomCol_SelectedIndexChanged

            txtTextCriteria.Text = "Steven Buchanan"
            AddHandler txtTextCriteria.TextChanged, AddressOf TxtTextCriteria_TextChanged

            numericUpDown.Value = 50
            AddHandler numericUpDown.ValueChanged, AddressOf NumericUpDown_ValueChanged

            dateTimePicker.Value = New DateTime(1997, DateTime.Now.Month, DateTime.Now.Day)
            AddHandler dateTimePicker.ValueChanged, AddressOf DateTimePicker_ValueChanged

            comboColor.DataSource = [Enum].GetValues(GetType(KnownColor))
            comboColor.SelectedItem = KnownColor.Cyan
            AddHandler comboColor.SelectedIndexChanged, AddressOf ComboColor_SelectedIndexChanged

            comboCustom.Items.AddRange(New Object() {"Blank", "Non-Blank"})
            comboCustom.SelectedItem = "Blank"
            AddHandler comboCustom.SelectedIndexChanged, AddressOf ComboCustom_SelectedIndexChanged
        End Sub

#Region "Event handlers"

#Region "CheckBox Events"
        Private Sub ChkCustomCondition_CheckedChanged(sender As Object, e As EventArgs)
            comboCustom.Enabled = chkCustomCondition.Checked
            comboCustomCol.Enabled = chkCustomCondition.Checked

            FilterByBlankNonBlank(chkCustomCondition.Checked)
        End Sub

        Private Sub ChkStyleCondition_CheckedChanged(sender As Object, e As EventArgs)
            comboColor.Enabled = chkStyleCondition.Checked

            If chkStyleCondition.Checked Then
                ResetPreviousFilter()
            End If

            FilterByColor(chkStyleCondition.Checked)
        End Sub

        Private Sub ChkDateCondition_CheckedChanged(sender As Object, e As EventArgs)
            dateTimePicker.Enabled = chkDateCondition.Checked
            comboDateCol.Enabled = chkDateCondition.Checked

            FilterByDate(chkDateCondition.Checked)
        End Sub

        Private Sub ChkNumberCondition_CheckedChanged(sender As Object, e As EventArgs)
            numericUpDown.Enabled = chkNumberCondition.Checked
            comboNumberCol.Enabled = chkNumberCondition.Checked

            FilterByNumber(chkNumberCondition.Checked)
        End Sub

        Private Sub ChkTextCondition_CheckedChanged(sender As Object, e As EventArgs)
            txtTextCriteria.Enabled = chkTextCondition.Checked
            comboTextCol.Enabled = chkTextCondition.Checked

            FilterByText(chkTextCondition.Checked)
        End Sub
#End Region

#Region "Input controls Events"
        Private Sub ComboTextCol_SelectedIndexChanged(sender As Object, e As EventArgs)
            ResetPreviousFilter(TryCast(sender, ComboBox))
            FilterByText(True)
        End Sub

        Private Sub TxtTextCriteria_TextChanged(sender As Object, e As EventArgs)
            FilterByText(True)
        End Sub

        Private Sub ComboDateCol_SelectedIndexChanged(sender As Object, e As EventArgs)
            ResetPreviousFilter(TryCast(sender, ComboBox))
            FilterByDate(True)
        End Sub

        Private Sub DateTimePicker_ValueChanged(sender As Object, e As EventArgs)
            FilterByDate(True)
        End Sub

        Private Sub ComboCustomCol_SelectedIndexChanged(sender As Object, e As EventArgs)
            ResetPreviousFilter(TryCast(sender, ComboBox))
            FilterByBlankNonBlank(True)
        End Sub

        Private Sub ComboCustom_SelectedIndexChanged(sender As Object, e As EventArgs)
            FilterByBlankNonBlank(True)
        End Sub

        Private Sub ComboNumberCol_SelectedIndexChanged(sender As Object, e As EventArgs)
            ResetPreviousFilter(TryCast(sender, ComboBox))
            FilterByNumber(True)
        End Sub

        Private Sub NumericUpDown_ValueChanged(sender As Object, e As EventArgs)
            FilterByNumber(True)
        End Sub

        Private Sub ComboColor_SelectedIndexChanged(sender As Object, e As EventArgs)
            FilterByColor(True)
        End Sub
#End Region

#End Region

        Private Sub ComboColClicked(sender As Object, e As EventArgs)
            _prevComboColIndex = fpSpread.ActiveSheet.Columns(TryCast(sender, ComboBox).SelectedItem.ToString()).Index
        End Sub

#Region "Filtering methods"
        Private Sub FilterByColor(enabled As Boolean)
            Dim sheet As SheetView = fpSpread.ActiveSheet
            Dim colIndex As Integer = sheet.Columns("CustomerID").Index
            Dim defColIndex As Integer = sheet.RowFilter.ColumnDefinitions.GetColumnDefinitionIndexFromColumnIndex(colIndex)
            Dim fcd = sheet.RowFilter.ColumnDefinitions(defColIndex)

            sheet.AutoFilterReset(_prevComboColIndex)
            fcd.Filters.Clear()
            If enabled Then
                Dim filter As New ColorFilterItem(False, Color.FromKnownColor(CType(comboColor.SelectedItem, KnownColor)))
                fcd.Filters.Add(filter)

                sheet.AutoFilterColumn(colIndex, filter.DisplayName, 0)
            End If
        End Sub

        Private Sub FilterByNumber(enabled As Boolean)
            Dim sheet As SheetView = fpSpread.ActiveSheet
            Dim colIndex As Integer = sheet.Columns(comboNumberCol.SelectedItem.ToString()).Index
            Dim defColIndex As Integer = sheet.RowFilter.ColumnDefinitions.GetColumnDefinitionIndexFromColumnIndex(colIndex)
            Dim fcd = sheet.RowFilter.ColumnDefinitions(defColIndex)

            sheet.AutoFilterReset(_prevComboColIndex)
            fcd.Filters.Clear()
            If enabled Then
                Dim filter As New CustomFilterItem(New FilterCondition(CustomFilterOperatorType.LessThan, numericUpDown.Value), Nothing, False)
                fcd.Filters.Add(filter)

                sheet.AutoFilterColumn(colIndex, filter.DisplayName, 0)
            End If
        End Sub

        Private Sub FilterByBlankNonBlank(enabled As Boolean)
            Dim sheet As SheetView = fpSpread.ActiveSheet
            Dim colIndex As Integer = sheet.Columns(comboCustomCol.SelectedItem.ToString()).Index
            Dim defColIndex As Integer = sheet.RowFilter.ColumnDefinitions.GetColumnDefinitionIndexFromColumnIndex(colIndex)
            Dim fcd = sheet.RowFilter.ColumnDefinitions(defColIndex)

            sheet.AutoFilterReset(_prevComboColIndex)
            fcd.Filters.Clear()
            If enabled Then
                Dim filterBlank As New CustomFilterItem(New FilterCondition(CustomFilterOperatorType.Equal, String.Empty), Nothing, False)
                Dim filterNonBlank As New CustomFilterItem(New FilterCondition(CustomFilterOperatorType.NotEqual, String.Empty), Nothing, False)
                fcd.Filters.Add(filterBlank)
                fcd.Filters.Add(filterNonBlank)

                sheet.AutoFilterColumn(colIndex, If(comboCustom.SelectedIndex = 0, filterBlank.DisplayName, filterNonBlank.DisplayName), comboCustom.SelectedIndex)
            End If
        End Sub

        Private Sub FilterByDate(enabled As Boolean)
            Dim sheet As SheetView = fpSpread.ActiveSheet
            Dim colIndex As Integer = sheet.Columns(comboCustomCol.SelectedItem.ToString()).Index
            Dim defColIndex As Integer = sheet.RowFilter.ColumnDefinitions.GetColumnDefinitionIndexFromColumnIndex(colIndex)
            Dim fcd = sheet.RowFilter.ColumnDefinitions(defColIndex)

            sheet.AutoFilterReset(_prevComboColIndex)
            fcd.Filters.Clear()
            If enabled Then
                Dim filter As New CustomFilterItem(New FilterCondition(CustomFilterOperatorType.LessThan, dateTimePicker.Value), Nothing, False)
                fcd.Filters.Add(filter)

                sheet.AutoFilterColumn(colIndex, filter.DisplayName, 0)
            End If
        End Sub

        Private Sub FilterByText(enabled As Boolean)
            Dim sheet As SheetView = fpSpread.ActiveSheet
            Dim colIndex As Integer = sheet.Columns(comboTextCol.SelectedItem.ToString()).Index
            Dim defColIndex As Integer = sheet.RowFilter.ColumnDefinitions.GetColumnDefinitionIndexFromColumnIndex(colIndex)
            Dim fcd = sheet.RowFilter.ColumnDefinitions(defColIndex)

            sheet.AutoFilterReset(_prevComboColIndex)
            fcd.Filters.Clear()
            If enabled Then
                Dim filter As New CustomFilterItem(New FilterCondition(CustomFilterOperatorType.Equal, txtTextCriteria.Text), Nothing, False)
                fcd.Filters.Add(filter)

                sheet.AutoFilterColumn(colIndex, filter.DisplayName, 0)
            End If
        End Sub
#End Region

        Private Sub ResetPreviousFilter(Optional currentColComboBox As ComboBox = Nothing)
            If currentColComboBox Is Nothing Then
                If comboTextCol.SelectedItem.ToString() = "CustomerID" Then
                    chkTextCondition.Checked = False
                End If
                If comboNumberCol.SelectedItem.ToString() = "CustomerID" Then
                    chkNumberCondition.Checked = False
                End If
                If comboCustomCol.SelectedItem.ToString() = "CustomerID" Then
                    chkCustomCondition.Checked = False
                End If
                Return
            End If

            If comboTextCol IsNot currentColComboBox AndAlso comboTextCol.SelectedItem Is currentColComboBox.SelectedItem Then
                chkTextCondition.Checked = False
            End If
            If comboNumberCol IsNot currentColComboBox AndAlso comboNumberCol.SelectedItem Is currentColComboBox.SelectedItem Then
                chkNumberCondition.Checked = False
            End If
            If comboDateCol IsNot currentColComboBox AndAlso comboDateCol.SelectedItem Is currentColComboBox.SelectedItem Then
                chkDateCondition.Checked = False
            End If
            If comboCustomCol IsNot currentColComboBox AndAlso comboCustomCol.SelectedItem Is currentColComboBox.SelectedItem Then
                chkCustomCondition.Checked = False
            End If

            If currentColComboBox.SelectedItem.ToString() = "CustomerID" Then
                chkStyleCondition.Checked = False
            End If
        End Sub
    End Class
End Namespace

'
'FilterIntro.Designer.vb
'

Namespace Features
	Partial Class FilterIntro
		''' <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.dateTimePicker = New System.Windows.Forms.DateTimePicker()
			Me.numericUpDown = New System.Windows.Forms.NumericUpDown()
			Me.comboCustom = New System.Windows.Forms.ComboBox()
			Me.comboCustomCol = New System.Windows.Forms.ComboBox()
			Me.label9 = New System.Windows.Forms.Label()
			Me.label10 = New System.Windows.Forms.Label()
			Me.chkCustomCondition = New System.Windows.Forms.CheckBox()
			Me.label8 = New System.Windows.Forms.Label()
			Me.chkStyleCondition = New System.Windows.Forms.CheckBox()
			Me.comboDateCol = New System.Windows.Forms.ComboBox()
			Me.label5 = New System.Windows.Forms.Label()
			Me.label6 = New System.Windows.Forms.Label()
			Me.chkDateCondition = New System.Windows.Forms.CheckBox()
			Me.comboColor = New System.Windows.Forms.ComboBox()
			Me.comboNumberCol = New System.Windows.Forms.ComboBox()
			Me.label3 = New System.Windows.Forms.Label()
			Me.label4 = New System.Windows.Forms.Label()
			Me.chkNumberCondition = New System.Windows.Forms.CheckBox()
			Me.comboTextCol = New System.Windows.Forms.ComboBox()
			Me.label2 = New System.Windows.Forms.Label()
			Me.txtTextCriteria = New System.Windows.Forms.TextBox()
			Me.label1 = New System.Windows.Forms.Label()
			Me.chkTextCondition = 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()
			DirectCast(Me.numericUpDown, System.ComponentModel.ISupportInitialize).BeginInit()
			Me.SuspendLayout()
			' 
			' pnlMain
			' 
			Me.pnlMain.Controls.Add(Me.fpSpread)
			' 
			' pnlControls
			' 
			Me.pnlControls.Controls.Add(Me.groupBox1)
			' 
			' fpSpread
			' 
			Me.fpSpread.AccessibleDescription = ""
			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.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.R1C1
			Me.fpSpread_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.dateTimePicker)
			Me.groupBox1.Controls.Add(Me.numericUpDown)
			Me.groupBox1.Controls.Add(Me.comboCustom)
			Me.groupBox1.Controls.Add(Me.comboCustomCol)
			Me.groupBox1.Controls.Add(Me.label9)
			Me.groupBox1.Controls.Add(Me.label10)
			Me.groupBox1.Controls.Add(Me.chkCustomCondition)
			Me.groupBox1.Controls.Add(Me.label8)
			Me.groupBox1.Controls.Add(Me.chkStyleCondition)
			Me.groupBox1.Controls.Add(Me.comboDateCol)
			Me.groupBox1.Controls.Add(Me.label5)
			Me.groupBox1.Controls.Add(Me.label6)
			Me.groupBox1.Controls.Add(Me.chkDateCondition)
			Me.groupBox1.Controls.Add(Me.comboColor)
			Me.groupBox1.Controls.Add(Me.comboNumberCol)
			Me.groupBox1.Controls.Add(Me.label3)
			Me.groupBox1.Controls.Add(Me.label4)
			Me.groupBox1.Controls.Add(Me.chkNumberCondition)
			Me.groupBox1.Controls.Add(Me.comboTextCol)
			Me.groupBox1.Controls.Add(Me.label2)
			Me.groupBox1.Controls.Add(Me.txtTextCriteria)
			Me.groupBox1.Controls.Add(Me.label1)
			Me.groupBox1.Controls.Add(Me.chkTextCondition)
			Me.groupBox1.Location = New System.Drawing.Point(5, 3)
			Me.groupBox1.Name = "groupBox1"
			Me.groupBox1.Size = New System.Drawing.Size(149, 435)
			Me.groupBox1.TabIndex = 0
			Me.groupBox1.TabStop = False
			Me.groupBox1.Text = "Filter Criteria"
			' 
			' dateTimePicker
			' 
			Me.dateTimePicker.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.dateTimePicker.Enabled = False
			Me.dateTimePicker.Location = New System.Drawing.Point(63, 217)
			Me.dateTimePicker.Name = "dateTimePicker"
			Me.dateTimePicker.Size = New System.Drawing.Size(81, 20)
			Me.dateTimePicker.TabIndex = 27
			' 
			' numericUpDown
			' 
			Me.numericUpDown.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.numericUpDown.Enabled = False
			Me.numericUpDown.Location = New System.Drawing.Point(63, 130)
			Me.numericUpDown.Name = "numericUpDown"
			Me.numericUpDown.Size = New System.Drawing.Size(79, 20)
			Me.numericUpDown.TabIndex = 26
			' 
			' comboCustom
			' 
			Me.comboCustom.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.comboCustom.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
			Me.comboCustom.Enabled = False
			Me.comboCustom.FormattingEnabled = True
			Me.comboCustom.Location = New System.Drawing.Point(63, 366)
			Me.comboCustom.Name = "comboCustom"
			Me.comboCustom.Size = New System.Drawing.Size(79, 21)
			Me.comboCustom.TabIndex = 25
			' 
			' comboCustomCol
			' 
			Me.comboCustomCol.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.comboCustomCol.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
			Me.comboCustomCol.Enabled = False
			Me.comboCustomCol.FormattingEnabled = True
			Me.comboCustomCol.Location = New System.Drawing.Point(64, 393)
			Me.comboCustomCol.Name = "comboCustomCol"
			Me.comboCustomCol.Size = New System.Drawing.Size(79, 21)
			Me.comboCustomCol.TabIndex = 25
			' 
			' label9
			' 
			Me.label9.AutoSize = True
			Me.label9.Location = New System.Drawing.Point(7, 396)
			Me.label9.Name = "label9"
			Me.label9.Size = New System.Drawing.Size(42, 13)
			Me.label9.TabIndex = 24
			Me.label9.Text = "Column"
			' 
			' label10
			' 
			Me.label10.AutoSize = True
			Me.label10.Location = New System.Drawing.Point(7, 369)
			Me.label10.Name = "label10"
			Me.label10.Size = New System.Drawing.Size(56, 13)
			Me.label10.TabIndex = 22
			Me.label10.Text = "Has Value"
			' 
			' chkCustomCondition
			' 
			Me.chkCustomCondition.AutoSize = True
			Me.chkCustomCondition.Location = New System.Drawing.Point(7, 345)
			Me.chkCustomCondition.Name = "chkCustomCondition"
			Me.chkCustomCondition.Size = New System.Drawing.Size(111, 17)
			Me.chkCustomCondition.TabIndex = 21
			Me.chkCustomCondition.Text = "Custom Condition:"
			Me.chkCustomCondition.UseVisualStyleBackColor = True
			' 
			' label8
			' 
			Me.label8.AutoSize = True
			Me.label8.Location = New System.Drawing.Point(7, 306)
			Me.label8.Name = "label8"
			Me.label8.Size = New System.Drawing.Size(41, 13)
			Me.label8.TabIndex = 17
			Me.label8.Text = "Color is"
			' 
			' chkStyleCondition
			' 
			Me.chkStyleCondition.AutoSize = True
			Me.chkStyleCondition.Location = New System.Drawing.Point(7, 282)
			Me.chkStyleCondition.Name = "chkStyleCondition"
			Me.chkStyleCondition.Size = New System.Drawing.Size(99, 17)
			Me.chkStyleCondition.TabIndex = 16
			Me.chkStyleCondition.Text = "Style Condition:"
			Me.chkStyleCondition.UseVisualStyleBackColor = True
			' 
			' comboDateCol
			' 
			Me.comboDateCol.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.comboDateCol.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
			Me.comboDateCol.Enabled = False
			Me.comboDateCol.FormattingEnabled = True
			Me.comboDateCol.Location = New System.Drawing.Point(63, 243)
			Me.comboDateCol.Name = "comboDateCol"
			Me.comboDateCol.Size = New System.Drawing.Size(81, 21)
			Me.comboDateCol.TabIndex = 15
			' 
			' label5
			' 
			Me.label5.AutoSize = True
			Me.label5.Location = New System.Drawing.Point(7, 246)
			Me.label5.Name = "label5"
			Me.label5.Size = New System.Drawing.Size(42, 13)
			Me.label5.TabIndex = 14
			Me.label5.Text = "Column"
			' 
			' label6
			' 
			Me.label6.AutoSize = True
			Me.label6.Location = New System.Drawing.Point(7, 219)
			Me.label6.Name = "label6"
			Me.label6.Size = New System.Drawing.Size(38, 13)
			Me.label6.TabIndex = 12
			Me.label6.Text = "Before"
			' 
			' chkDateCondition
			' 
			Me.chkDateCondition.AutoSize = True
			Me.chkDateCondition.Location = New System.Drawing.Point(7, 195)
			Me.chkDateCondition.Name = "chkDateCondition"
			Me.chkDateCondition.Size = New System.Drawing.Size(99, 17)
			Me.chkDateCondition.TabIndex = 11
			Me.chkDateCondition.Text = "Date Condition:"
			Me.chkDateCondition.UseVisualStyleBackColor = True
			' 
			' comboColor
			' 
			Me.comboColor.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.comboColor.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
			Me.comboColor.Enabled = False
			Me.comboColor.FormattingEnabled = True
			Me.comboColor.Location = New System.Drawing.Point(64, 303)
			Me.comboColor.Name = "comboColor"
			Me.comboColor.Size = New System.Drawing.Size(79, 21)
			Me.comboColor.TabIndex = 10
			' 
			' comboNumberCol
			' 
			Me.comboNumberCol.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.comboNumberCol.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
			Me.comboNumberCol.Enabled = False
			Me.comboNumberCol.FormattingEnabled = True
			Me.comboNumberCol.Location = New System.Drawing.Point(64, 156)
			Me.comboNumberCol.Name = "comboNumberCol"
			Me.comboNumberCol.Size = New System.Drawing.Size(79, 21)
			Me.comboNumberCol.TabIndex = 10
			' 
			' label3
			' 
			Me.label3.AutoSize = True
			Me.label3.Location = New System.Drawing.Point(7, 159)
			Me.label3.Name = "label3"
			Me.label3.Size = New System.Drawing.Size(42, 13)
			Me.label3.TabIndex = 9
			Me.label3.Text = "Column"
			' 
			' label4
			' 
			Me.label4.AutoSize = True
			Me.label4.Location = New System.Drawing.Point(7, 132)
			Me.label4.Name = "label4"
			Me.label4.Size = New System.Drawing.Size(53, 13)
			Me.label4.TabIndex = 7
			Me.label4.Text = "Less than"
			' 
			' chkNumberCondition
			' 
			Me.chkNumberCondition.AutoSize = True
			Me.chkNumberCondition.Location = New System.Drawing.Point(7, 108)
			Me.chkNumberCondition.Name = "chkNumberCondition"
			Me.chkNumberCondition.Size = New System.Drawing.Size(113, 17)
			Me.chkNumberCondition.TabIndex = 6
			Me.chkNumberCondition.Text = "Number Condition:"
			Me.chkNumberCondition.UseVisualStyleBackColor = True
			' 
			' comboTextCol
			' 
			Me.comboTextCol.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.comboTextCol.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
			Me.comboTextCol.Enabled = False
			Me.comboTextCol.FormattingEnabled = True
			Me.comboTextCol.Location = New System.Drawing.Point(64, 67)
			Me.comboTextCol.Name = "comboTextCol"
			Me.comboTextCol.Size = New System.Drawing.Size(79, 21)
			Me.comboTextCol.TabIndex = 5
			' 
			' label2
			' 
			Me.label2.AutoSize = True
			Me.label2.Location = New System.Drawing.Point(6, 70)
			Me.label2.Name = "label2"
			Me.label2.Size = New System.Drawing.Size(42, 13)
			Me.label2.TabIndex = 4
			Me.label2.Text = "Column"
			' 
			' txtTextCriteria
			' 
			Me.txtTextCriteria.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.txtTextCriteria.Enabled = False
			Me.txtTextCriteria.Location = New System.Drawing.Point(64, 40)
			Me.txtTextCriteria.Name = "txtTextCriteria"
			Me.txtTextCriteria.Size = New System.Drawing.Size(79, 20)
			Me.txtTextCriteria.TabIndex = 3
			' 
			' label1
			' 
			Me.label1.AutoSize = True
			Me.label1.Location = New System.Drawing.Point(6, 43)
			Me.label1.Name = "label1"
			Me.label1.Size = New System.Drawing.Size(34, 13)
			Me.label1.TabIndex = 2
			Me.label1.Text = "Value"
			' 
			' chkTextCondition
			' 
			Me.chkTextCondition.AutoSize = True
			Me.chkTextCondition.Location = New System.Drawing.Point(6, 19)
			Me.chkTextCondition.Name = "chkTextCondition"
			Me.chkTextCondition.Size = New System.Drawing.Size(97, 17)
			Me.chkTextCondition.TabIndex = 1
			Me.chkTextCondition.Text = "Text Condition:"
			Me.chkTextCondition.UseVisualStyleBackColor = True
			' 
			' FilterIntro
			' 
			Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
			Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
			Me.Name = "FilterIntro"
			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.groupBox1.PerformLayout()
			DirectCast(Me.numericUpDown, System.ComponentModel.ISupportInitialize).EndInit()
			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 numericUpDown As System.Windows.Forms.NumericUpDown
		Private comboCustom As System.Windows.Forms.ComboBox
		Private comboCustomCol As System.Windows.Forms.ComboBox
		Private label9 As System.Windows.Forms.Label
		Private label10 As System.Windows.Forms.Label
		Private chkCustomCondition As System.Windows.Forms.CheckBox
		Private label8 As System.Windows.Forms.Label
		Private chkStyleCondition As System.Windows.Forms.CheckBox
		Private comboDateCol As System.Windows.Forms.ComboBox
		Private label5 As System.Windows.Forms.Label
		Private label6 As System.Windows.Forms.Label
		Private chkDateCondition As System.Windows.Forms.CheckBox
		Private comboColor As System.Windows.Forms.ComboBox
		Private comboNumberCol As System.Windows.Forms.ComboBox
		Private label3 As System.Windows.Forms.Label
		Private label4 As System.Windows.Forms.Label
		Private chkNumberCondition As System.Windows.Forms.CheckBox
		Private comboTextCol As System.Windows.Forms.ComboBox
		Private label2 As System.Windows.Forms.Label
		Private txtTextCriteria As System.Windows.Forms.TextBox
		Private label1 As System.Windows.Forms.Label
		Private chkTextCondition As System.Windows.Forms.CheckBox
		Private dateTimePicker As System.Windows.Forms.DateTimePicker
	End Class
End Namespace
