Imports FarPoint.Win.Spread.Model
Imports Spread.Common.DataStore
Imports Spread.Common.Features.Spread.Common.Features.Sample

Partial Public Class Introduction
    Inherits BaseSampleControl
    Public Sub New()
        InitializeComponent()
        fpSpread1_Sheet1.DataAutoSizeColumns = False
        fpSpread1_Sheet1.SetColumnWidth(-1, 120)
        fpSpread1_Sheet1.SetRowHeight(-1, 21)

        Dim dataSource = New DataService().JsonDataSource.GetMovieRecords()
        fpSpread1_Sheet1.DataSource = dataSource

        fpSpread1_Sheet1.SetColumnAllowAutoSort(-1, True)
    End Sub

    Private Sub _bSortAToZ_Click(sender As Object, e As EventArgs)
        Dim cr As CellRange = fpSpread1_Sheet1.GetSelection(0)
        If cr IsNot Nothing Then
            fpSpread1_Sheet1.SortRange(cr.Row, cr.Column, cr.RowCount, cr.ColumnCount, True, New FarPoint.Win.Spread.SortInfo() {New FarPoint.Win.Spread.SortInfo(cr.Column, True)})
        End If
    End Sub

    Private Sub _bSortZToA_Click(sender As Object, e As EventArgs)
        Dim cr As CellRange = fpSpread1_Sheet1.GetSelection(0)
        If cr IsNot Nothing Then
            fpSpread1_Sheet1.SortRange(cr.Row, cr.Column, cr.RowCount, cr.ColumnCount, True, New FarPoint.Win.Spread.SortInfo() {New FarPoint.Win.Spread.SortInfo(cr.Column, False)})
        End If
    End Sub
End Class

'
'Introduction.Designer.vb
'

Partial Class Introduction
	''' <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._bSortAToZ = New System.Windows.Forms.Button()
		Me._bSortZToA = New System.Windows.Forms.Button()
		Me.groupBox1 = New System.Windows.Forms.GroupBox()
		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.SuspendLayout()
		' 
		' pnlMain
		' 
		Me.pnlMain.Controls.Add(Me.fpSpread1)
		' 
		' pnlControls
		' 
		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
		' 
		' _bSortAToZ
		' 
		Me._bSortAToZ.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
		Me._bSortAToZ.Location = New System.Drawing.Point(13, 19)
		Me._bSortAToZ.Name = "_bSortAToZ"
		Me._bSortAToZ.Size = New System.Drawing.Size(115, 23)
		Me._bSortAToZ.TabIndex = 0
		Me._bSortAToZ.Text = "Sort A -> Z"
		Me._bSortAToZ.UseVisualStyleBackColor = True
		AddHandler Me._bSortAToZ.Click, New System.EventHandler(AddressOf Me._bSortAToZ_Click)
		' 
		' _bSortZToA
		' 
		Me._bSortZToA.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
		Me._bSortZToA.Location = New System.Drawing.Point(13, 59)
		Me._bSortZToA.Name = "_bSortZToA"
		Me._bSortZToA.Size = New System.Drawing.Size(115, 23)
		Me._bSortZToA.TabIndex = 1
		Me._bSortZToA.Text = "Sort Z -> A"
		Me._bSortZToA.UseVisualStyleBackColor = True
		AddHandler Me._bSortZToA.Click, New System.EventHandler(AddressOf Me._bSortZToA_Click)
		' 
		' 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._bSortAToZ)
		Me.groupBox1.Controls.Add(Me._bSortZToA)
		Me.groupBox1.Location = New System.Drawing.Point(6, 14)
		Me.groupBox1.Name = "groupBox1"
		Me.groupBox1.Size = New System.Drawing.Size(148, 88)
		Me.groupBox1.TabIndex = 2
		Me.groupBox1.TabStop = False
		Me.groupBox1.Text = "Selected Range Sorting"
		' 
		' Introduction
		' 
		Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
		Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
		Me.Name = "Introduction"
		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.ResumeLayout(False)

	End Sub

	#End Region

	Private fpSpread1 As FarPoint.Win.Spread.FpSpread
	Private fpSpread1_Sheet1 As FarPoint.Win.Spread.SheetView
	Private _bSortZToA As System.Windows.Forms.Button
	Private _bSortAToZ As System.Windows.Forms.Button
	Private groupBox1 As System.Windows.Forms.GroupBox
End Class
