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 Spread.Common.DataStore
Imports FarPoint.Win
Imports GrapeCity.Spreadsheet
Imports Spread.Common.Features.Spread.Common.Features.Sample

Namespace Features
    Partial Public Class BasicFunctionDemo
        Inherits BaseSampleControl
        Public Sub New()
            InitializeComponent()
            SetUpSpreadSheet()
        End Sub
        Private Sub SetUpSpreadSheet()
            Name = "Basic Functions"
            sheetView.DataAutoSizeColumns = False
            sheetView.Rows.[Default].Height = 30
            sheetView.Columns.[Default].Width = 90
            sheetView.DataSource = New DataService().JsonDataSource.GetMovieRecords()

            sheetView.Columns.Add(sheetView.Columns.Count, 2)
            sheetView.Cells(1, sheetView.Columns.Count - 2).Value = "Audience Maximum Score"
            sheetView.Cells(2, sheetView.Columns.Count - 2).Value = "Audience Minimum Score"
            sheetView.Cells(3, sheetView.Columns.Count - 2).Value = "Audience Average Score"

            sheetView.Cells(1, sheetView.Columns.Count - 1).Formula = "MAX(D1:D74)"
            sheetView.Cells(2, sheetView.Columns.Count - 1).Formula = "MIN(D1:D74)"
            sheetView.Cells(3, sheetView.Columns.Count - 1).Formula = "AVERAGE(D1:D74)"

            sheetView.Cells(6, sheetView.Columns.Count - 2).Value = "Maximum Rating"
            sheetView.Cells(7, sheetView.Columns.Count - 2).Value = "Minimum Rating"
            sheetView.Cells(8, sheetView.Columns.Count - 2).Value = "Average Rating"

            sheetView.Cells(6, sheetView.Columns.Count - 1).Formula = "MAX(F1:F74)"
            sheetView.Cells(7, sheetView.Columns.Count - 1).Formula = "MIN(F1:F74)"
            sheetView.Cells(8, sheetView.Columns.Count - 1).Formula = "AVERAGE(F1:F74)"
            sheetView.Columns(sheetView.Columns.Count - 1).Width = 110
            sheetView.Columns(sheetView.Columns.Count - 2).Width = 150

            For column As Integer = sheetView.Columns.Count - 2 To sheetView.Columns.Count - 1
                For row As Integer = 1 To 3
                    sheetView.Cells(row, column).BackColor = System.Drawing.Color.LightGreen
                    sheetView.Cells(row + 5, column).BackColor = System.Drawing.Color.LightBlue
                    sheetView.Cells(row + 5, column).Border = InlineAssignHelper(sheetView.Cells(row, column).Border, New LineBorder(System.Drawing.Color.Black, 2, column = sheetView.Columns.Count - 2, row = 1, column = sheetView.Columns.Count - 1, row = 3))
                Next
            Next
            spread.DefaultSkin = FarPoint.Win.Spread.DefaultSpreadSkins.Office2016Colorful
            For c As Integer = 0 To sheetView.ColumnCount - 1
                spread.AsWorkbook().Worksheets(0).Columns(c).AutoFit()
            Next
        End Sub
        Private Shared Function InlineAssignHelper(Of T)(ByRef target As T, value As T) As T
            target = value
            Return value
        End Function
    End Class
End Namespace

'
'
'
BasicFunctionDemo.Designer.vb
'
'
'

Namespace Features
	Partial Class BasicFunctionDemo
		''' <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()
            Dim resources As System.ComponentModel.ComponentResourceManager = New System.ComponentModel.ComponentResourceManager(GetType(BasicFunctionDemo))
            Me.panelFormulaBar = New System.Windows.Forms.Panel()
            Me.splitContainer1 = New System.Windows.Forms.SplitContainer()
            Me.nameBox1 = New FarPoint.Win.Spread.NameBox()
            Me.formulaTextBox1 = New FarPoint.Win.Spread.FormulaTextBox()
            Me.spread = New FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None, CType(resources.GetObject("pnlMain.Controls"), Object))
            Me.sheetView = Me.spread.GetSheet(0)
            Me.pnlMain.SuspendLayout()
            Me.panelFormulaBar.SuspendLayout()
            CType(Me.splitContainer1, System.ComponentModel.ISupportInitialize).BeginInit()
            Me.splitContainer1.Panel1.SuspendLayout()
            Me.splitContainer1.Panel2.SuspendLayout()
            Me.splitContainer1.SuspendLayout()
            CType(Me.spread, System.ComponentModel.ISupportInitialize).BeginInit()
            Me.SuspendLayout()
            '
            'pnlMain
            '
            Me.pnlMain.Controls.Add(Me.spread)
            Me.pnlMain.Controls.Add(Me.panelFormulaBar)
            '
            'panelFormulaBar
            '
            Me.panelFormulaBar.Controls.Add(Me.splitContainer1)
            Me.panelFormulaBar.Dock = System.Windows.Forms.DockStyle.Top
            Me.panelFormulaBar.Location = New System.Drawing.Point(0, 0)
            Me.panelFormulaBar.Name = "panelFormulaBar"
            Me.panelFormulaBar.Size = New System.Drawing.Size(477, 23)
            Me.panelFormulaBar.TabIndex = 6
            '
            'splitContainer1
            '
            Me.splitContainer1.Dock = System.Windows.Forms.DockStyle.Fill
            Me.splitContainer1.Location = New System.Drawing.Point(0, 0)
            Me.splitContainer1.Name = "splitContainer1"
            '
            'splitContainer1.Panel1
            '
            Me.splitContainer1.Panel1.Controls.Add(Me.nameBox1)
            Me.splitContainer1.Panel1MinSize = 121
            '
            'splitContainer1.Panel2
            '
            Me.splitContainer1.Panel2.Controls.Add(Me.formulaTextBox1)
            Me.splitContainer1.Size = New System.Drawing.Size(477, 23)
            Me.splitContainer1.SplitterDistance = 121
            Me.splitContainer1.TabIndex = 0
            '
            'nameBox1
            '
            Me.nameBox1.Dock = System.Windows.Forms.DockStyle.Fill
            Me.nameBox1.Location = New System.Drawing.Point(0, 0)
            Me.nameBox1.MaxLength = 255
            Me.nameBox1.Name = "nameBox1"
            Me.nameBox1.Size = New System.Drawing.Size(121, 21)
            Me.nameBox1.TabIndex = 0
            Me.nameBox1.Attach(spread)
            '
            'formulaTextBox1
            '
            Me.formulaTextBox1.Dock = System.Windows.Forms.DockStyle.Fill
            Me.formulaTextBox1.Location = New System.Drawing.Point(0, 0)
            Me.formulaTextBox1.Name = "formulaTextBox1"
            Me.formulaTextBox1.Size = New System.Drawing.Size(352, 23)
            Me.formulaTextBox1.TabIndex = 0
            Me.formulaTextBox1.Attach(spread)
            '
            'spread
            '
            Me.spread.AccessibleDescription = "Book1, Sheet1, Row 0, Column 0"
            Me.spread.Dock = System.Windows.Forms.DockStyle.Fill
            Me.spread.Font = New System.Drawing.Font("Calibri", 11.0!)
            Me.spread.Location = New System.Drawing.Point(0, 23)
            Me.spread.Name = "spread"
            Me.spread.Size = New System.Drawing.Size(477, 464)
            Me.spread.TabIndex = 7
            '
            'BasicFunctionDemo
            '
            Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!)
            Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
            Me.Name = "BasicFunctionDemo"
            Me.pnlMain.ResumeLayout(False)
            Me.panelFormulaBar.ResumeLayout(False)
            Me.splitContainer1.Panel1.ResumeLayout(False)
            Me.splitContainer1.Panel2.ResumeLayout(False)
            CType(Me.splitContainer1, System.ComponentModel.ISupportInitialize).EndInit()
            Me.splitContainer1.ResumeLayout(False)
            CType(Me.spread, System.ComponentModel.ISupportInitialize).EndInit()
            Me.ResumeLayout(False)

        End Sub

#End Region

        Private splitContainer1 As System.Windows.Forms.SplitContainer
        Protected Friend panelFormulaBar As System.Windows.Forms.Panel
        Protected Friend nameBox1 As FarPoint.Win.Spread.NameBox
        Protected Friend formulaTextBox1 As FarPoint.Win.Spread.FormulaTextBox
        Friend WithEvents spread As FarPoint.Win.Spread.FpSpread
        Friend WithEvents sheetView As FarPoint.Win.Spread.SheetView
    End Class
End Namespace

