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 Spread.Common.Features.Spread.Common.Features.Sample
Namespace Features
	Public Partial Class FrozenRowColDemo
		Inherits BaseSampleControl
		Public Sub New()
			InitializeComponent()
			SetupSpreadSheet()
			InitializeControls()
		End Sub

		Private Sub SetupSpreadSheet()
			Dim random As New Random()
			Dim sum As Integer = 0, cost As Integer
			Name = "Frozen Rows and Columns"
			sheetView.Columns.Count = 10
			sheetView.Rows.Count = 30

			sheetView.Columns.Add(0, 1)
			sheetView.Columns(0).Width = 150
			sheetView.Cells(2, 0).Value = "Date"
			sheetView.Cells(2, 0).ForeColor = Color.Green

			sheetView.AlternatingRows(1).BackColor = Color.WhiteSmoke
			For column As Integer = 0 To sheetView.Columns.Count - 1
				sheetView.Cells(2, column).Border = New LineBorder(Color.DarkOliveGreen, 3, False, True, False, False)
				sheetView.Cells(29, column).Border = New LineBorder(Color.DarkOliveGreen, 3, False, True, False, False)
			Next
			For row As Integer = 3 To 28
				cost = random.[Next](25, 500)
				sheetView.Cells(row, 2).Value = cost.ToString("C")
				sum += cost
				sheetView.Cells(row, 0).Value = DateTime.Today.AddDays(random.[Next](-30, 0)).ToString("MMM dd , yyyy")
				sheetView.Cells(row, 0).Font = New Font(FontFamily.GenericSansSerif, 12, FontStyle.Regular)
			Next
			sheetView.Cells(29, 1).Value = "Total"
			sheetView.Cells(29, 2).Value = sum.ToString("C")
			sheetView.Cells(0, 0).Value = "Household"
			sheetView.Cells(1, 0).Value = "BUDGET"
			sheetView.Cells(0, 0).ForeColor = Color.Green
			sheetView.Cells(1, 0).ForeColor = Color.Navy
			sheetView.Cells(1, 0).Font = InlineAssignHelper(sheetView.Cells(0, 0).Font, New Font(FontFamily.GenericMonospace, 16, FontStyle.Bold))
			sheetView.Cells(1, 0).HorizontalAlignment = InlineAssignHelper(sheetView.Cells(0, 0).HorizontalAlignment, CellHorizontalAlignment.Center)
			sheetView.Cells(1, 0).VerticalAlignment = InlineAssignHelper(sheetView.Cells(0, 0).VerticalAlignment, CellVerticalAlignment.Center)
			sheetView.FrozenRowCount = 3
			sheetView.FrozenTrailingRowCount = 1
			sheetView.FrozenColumnCount = 1
			freezeRowUpDown.Value = 3
			freezeColumnUpDown.Value = 1
			trailingRowUpDown.Value = 1
			spread.ScrollBarTrackPolicy = ScrollBarTrackPolicy.Both
		End Sub
		Private Sub InitializeControls()
			freezeRowUpDown.Minimum = InlineAssignHelper(freezeColumnUpDown.Minimum, InlineAssignHelper(trailingRowUpDown.Minimum, InlineAssignHelper(trailingColumnUpDown.Minimum, 0)))
			freezeRowUpDown.Maximum = InlineAssignHelper(trailingRowUpDown.Maximum, sheetView.Rows.Count)
			freezeColumnUpDown.Maximum = InlineAssignHelper(trailingColumnUpDown.Maximum, sheetView.Columns.Count)
		End Sub
		Private Sub SetButton_Click(sender As Object, e As EventArgs)
			Try
				If freezeRowUpDown.Text <> "" OrElse trailingRowUpDown.Text <> "" OrElse freezeColumnUpDown.Text <> "" OrElse trailingColumnUpDown.Text <> "" Then
					sheetView.FrozenRowCount = Integer.Parse(freezeRowUpDown.Text)
					sheetView.FrozenTrailingRowCount = Integer.Parse(trailingRowUpDown.Text)
					sheetView.FrozenColumnCount = Integer.Parse(freezeColumnUpDown.Text)
					sheetView.FrozenTrailingColumnCount = Integer.Parse(trailingColumnUpDown.Text)
				End If
			Catch ex As Exception
				MessageBox.Show(ex.Message)
			End Try
		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

'
'FrozenRowColDemo.Designer.vb
'

Namespace Features
	Partial Class FrozenRowColDemo
		''' <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.controlsGrpBox = New System.Windows.Forms.GroupBox()
			Me.trailingColumnUpDown = New System.Windows.Forms.NumericUpDown()
			Me.freezeColumnUpDown = New System.Windows.Forms.NumericUpDown()
			Me.trailingRowUpDown = New System.Windows.Forms.NumericUpDown()
			Me.freezeRowUpDown = New System.Windows.Forms.NumericUpDown()
			Me.setButton = New System.Windows.Forms.Button()
			Me.trailingColumnLabel = New System.Windows.Forms.Label()
			Me.freezeColumnLabel = New System.Windows.Forms.Label()
			Me.trailingRowCount = New System.Windows.Forms.Label()
			Me.freezeRowLabel = New System.Windows.Forms.Label()
			Me.spread = New FarPoint.Win.Spread.FpSpread()
			Me.sheetView = New FarPoint.Win.Spread.SheetView()
			Me.pnlMain.SuspendLayout()
			Me.pnlControls.SuspendLayout()
			Me.controlsGrpBox.SuspendLayout()
			DirectCast(Me.trailingColumnUpDown, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.freezeColumnUpDown, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.trailingRowUpDown, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.freezeRowUpDown, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.spread, System.ComponentModel.ISupportInitialize).BeginInit()
			DirectCast(Me.sheetView, System.ComponentModel.ISupportInitialize).BeginInit()
			Me.SuspendLayout()
			' 
			' pnlMain
			' 
			Me.pnlMain.Controls.Add(Me.spread)
			' 
			' pnlControls
			' 
			Me.pnlControls.Controls.Add(Me.controlsGrpBox)
			' 
			' controlsGrpBox
			' 
			Me.controlsGrpBox.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.controlsGrpBox.Controls.Add(Me.trailingColumnUpDown)
			Me.controlsGrpBox.Controls.Add(Me.freezeColumnUpDown)
			Me.controlsGrpBox.Controls.Add(Me.trailingRowUpDown)
			Me.controlsGrpBox.Controls.Add(Me.freezeRowUpDown)
			Me.controlsGrpBox.Controls.Add(Me.setButton)
			Me.controlsGrpBox.Controls.Add(Me.trailingColumnLabel)
			Me.controlsGrpBox.Controls.Add(Me.freezeColumnLabel)
			Me.controlsGrpBox.Controls.Add(Me.trailingRowCount)
			Me.controlsGrpBox.Controls.Add(Me.freezeRowLabel)
			Me.controlsGrpBox.Location = New System.Drawing.Point(5, 30)
			Me.controlsGrpBox.Name = "controlsGrpBox"
			Me.controlsGrpBox.Size = New System.Drawing.Size(132, 303)
			Me.controlsGrpBox.TabIndex = 1
			Me.controlsGrpBox.TabStop = False
			Me.controlsGrpBox.Text = "Actions and Settings"
			' 
			' trailingColumnUpDown
			' 
			Me.trailingColumnUpDown.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.trailingColumnUpDown.Location = New System.Drawing.Point(6, 234)
			Me.trailingColumnUpDown.Name = "trailingColumnUpDown"
			Me.trailingColumnUpDown.Size = New System.Drawing.Size(120, 20)
			Me.trailingColumnUpDown.TabIndex = 3
			' 
			' freezeColumnUpDown
			' 
			Me.freezeColumnUpDown.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.freezeColumnUpDown.Location = New System.Drawing.Point(6, 171)
			Me.freezeColumnUpDown.Name = "freezeColumnUpDown"
			Me.freezeColumnUpDown.Size = New System.Drawing.Size(120, 20)
			Me.freezeColumnUpDown.TabIndex = 2
			' 
			' trailingRowUpDown
			' 
			Me.trailingRowUpDown.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.trailingRowUpDown.Location = New System.Drawing.Point(6, 114)
			Me.trailingRowUpDown.Name = "trailingRowUpDown"
			Me.trailingRowUpDown.Size = New System.Drawing.Size(120, 20)
			Me.trailingRowUpDown.TabIndex = 1
			' 
			' freezeRowUpDown
			' 
			Me.freezeRowUpDown.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.freezeRowUpDown.Location = New System.Drawing.Point(6, 62)
			Me.freezeRowUpDown.Name = "freezeRowUpDown"
			Me.freezeRowUpDown.Size = New System.Drawing.Size(120, 20)
			Me.freezeRowUpDown.TabIndex = 0
			' 
			' 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(6, 259)
			Me.setButton.Name = "setButton"
			Me.setButton.Size = New System.Drawing.Size(120, 23)
			Me.setButton.TabIndex = 4
			Me.setButton.Text = "Set"
			Me.setButton.UseVisualStyleBackColor = True
			AddHandler Me.setButton.Click, New System.EventHandler(AddressOf Me.SetButton_Click)
			' 
			' trailingColumnLabel
			' 
			Me.trailingColumnLabel.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.trailingColumnLabel.Location = New System.Drawing.Point(3, 217)
			Me.trailingColumnLabel.Name = "trailingColumnLabel"
			Me.trailingColumnLabel.Size = New System.Drawing.Size(123, 13)
			Me.trailingColumnLabel.TabIndex = 5
			Me.trailingColumnLabel.Text = "TrailingColumnCount"
			' 
			' freezeColumnLabel
			' 
			Me.freezeColumnLabel.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.freezeColumnLabel.Location = New System.Drawing.Point(3, 155)
			Me.freezeColumnLabel.Name = "freezeColumnLabel"
			Me.freezeColumnLabel.Size = New System.Drawing.Size(123, 13)
			Me.freezeColumnLabel.TabIndex = 4
			Me.freezeColumnLabel.Text = "FreezeColumnCount"
			' 
			' trailingRowCount
			' 
			Me.trailingRowCount.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.trailingRowCount.Location = New System.Drawing.Point(3, 97)
			Me.trailingRowCount.Name = "trailingRowCount"
			Me.trailingRowCount.Size = New System.Drawing.Size(123, 13)
			Me.trailingRowCount.TabIndex = 3
			Me.trailingRowCount.Text = "Trailing Row Count"
			' 
			' freezeRowLabel
			' 
			Me.freezeRowLabel.Anchor = CType(((System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Left) Or System.Windows.Forms.AnchorStyles.Right), System.Windows.Forms.AnchorStyles)
			Me.freezeRowLabel.Location = New System.Drawing.Point(3, 45)
			Me.freezeRowLabel.Name = "freezeRowLabel"
			Me.freezeRowLabel.Size = New System.Drawing.Size(123, 13)
			Me.freezeRowLabel.TabIndex = 2
			Me.freezeRowLabel.Text = "Freeze Row Count"
			' 
			' 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.spread.Size = New System.Drawing.Size(477, 487)
			Me.spread.TabIndex = 0
			' 
			' sheetView
			' 
			Me.sheetView.Reset()
			Me.sheetView.SheetName = "Sheet1"
			' Formulas and custom names must be loaded with R1C1 reference style
			Me.sheetView.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
			Me.sheetView.ActiveRowIndex = 1
			Me.sheetView.Cells.[Get](0, 0).Font = New System.Drawing.Font("Microsoft Sans Serif", 14.25F)
			Me.sheetView.Cells.[Get](0, 0).ForeColor = System.Drawing.Color.Green
			Me.sheetView.Cells.[Get](0, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center
			Me.sheetView.Cells.[Get](0, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center
			Me.sheetView.Cells.[Get](1, 0).Font = New System.Drawing.Font("Microsoft Sans Serif", 15.75F, System.Drawing.FontStyle.Bold)
			Me.sheetView.Cells.[Get](1, 0).ForeColor = System.Drawing.Color.Navy
			Me.sheetView.Cells.[Get](1, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center
			Me.sheetView.Cells.[Get](1, 0).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center
			Me.sheetView.Cells.[Get](2, 0).Font = New System.Drawing.Font("Arial Narrow", 12F, System.Drawing.FontStyle.Bold)
			Me.sheetView.Cells.[Get](2, 0).ForeColor = System.Drawing.Color.Green
			Me.sheetView.Cells.[Get](2, 0).Value = "EXPENSES"
			Me.sheetView.Cells.[Get](2, 1).Font = New System.Drawing.Font("Arial Narrow", 12F, System.Drawing.FontStyle.Bold)
			Me.sheetView.Cells.[Get](2, 1).ForeColor = System.Drawing.Color.Green
			Me.sheetView.Cells.[Get](2, 1).Value = "AMOUNT"
			Me.sheetView.Cells.[Get](2, 2).Font = New System.Drawing.Font("Arial Narrow", 12F, System.Drawing.FontStyle.Bold)
			Me.sheetView.Cells.[Get](2, 2).ForeColor = System.Drawing.Color.Green
			Me.sheetView.Cells.[Get](2, 2).Value = "NAME"
			Me.sheetView.Cells.[Get](2, 3).Font = New System.Drawing.Font("Arial Narrow", 12F, System.Drawing.FontStyle.Bold)
			Me.sheetView.Cells.[Get](2, 3).ForeColor = System.Drawing.Color.Green
			Me.sheetView.Cells.[Get](2, 3).Value = "NOTES"
			Me.sheetView.Cells.[Get](3, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](3, 0).Value = "Rent"
			Me.sheetView.Cells.[Get](3, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](3, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](3, 2).Value = "Roommate1"
			Me.sheetView.Cells.[Get](3, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](3, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](4, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](4, 0).Value = "Rent"
			Me.sheetView.Cells.[Get](4, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](4, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](4, 2).Value = "Roommate2"
			Me.sheetView.Cells.[Get](4, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](4, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](5, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](5, 0).Value = "Rent"
			Me.sheetView.Cells.[Get](5, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](5, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](5, 2).Value = "Roommate3"
			Me.sheetView.Cells.[Get](5, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](5, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](6, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](6, 0).Value = "Rent"
			Me.sheetView.Cells.[Get](6, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](6, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](6, 2).Value = "Roommate4"
			Me.sheetView.Cells.[Get](6, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](6, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](7, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](7, 0).Value = "Cable TV"
			Me.sheetView.Cells.[Get](7, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](7, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](7, 2).Value = "Roommate1"
			Me.sheetView.Cells.[Get](7, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](7, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](8, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](8, 0).Value = "CableTV"
			Me.sheetView.Cells.[Get](8, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](8, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](8, 2).Value = "Roommate2"
			Me.sheetView.Cells.[Get](8, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](8, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](9, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](9, 0).Value = "CableTV"
			Me.sheetView.Cells.[Get](9, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](9, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](9, 2).Value = "Roommate3"
			Me.sheetView.Cells.[Get](9, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](9, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](10, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](10, 0).Value = "CableTV"
			Me.sheetView.Cells.[Get](10, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](10, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](10, 2).Value = "Roommate4"
			Me.sheetView.Cells.[Get](10, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](10, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](11, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](11, 0).Value = "Groceries"
			Me.sheetView.Cells.[Get](11, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](11, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](11, 2).Value = "Roommate2"
			Me.sheetView.Cells.[Get](11, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](11, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](12, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](12, 0).Value = "Groceries"
			Me.sheetView.Cells.[Get](12, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](12, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](12, 2).Value = "Roommate3"
			Me.sheetView.Cells.[Get](12, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](12, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](13, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](13, 0).Value = "Electricity"
			Me.sheetView.Cells.[Get](13, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](13, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](13, 2).Value = "Roommate1"
			Me.sheetView.Cells.[Get](13, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](13, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](14, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](14, 0).Value = "Electricity"
			Me.sheetView.Cells.[Get](14, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](14, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](14, 2).Value = "Roommate2"
			Me.sheetView.Cells.[Get](14, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](14, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](15, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](15, 0).Value = "Electricity"
			Me.sheetView.Cells.[Get](15, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](15, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](15, 2).Value = "Roommate3"
			Me.sheetView.Cells.[Get](15, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](15, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](16, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](16, 0).Value = "Electricity"
			Me.sheetView.Cells.[Get](16, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](16, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](16, 2).Value = "Roommate4"
			Me.sheetView.Cells.[Get](16, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](16, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](17, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](17, 0).Value = "Food"
			Me.sheetView.Cells.[Get](17, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](17, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](17, 2).Value = "Roommate1"
			Me.sheetView.Cells.[Get](17, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](17, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](18, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](18, 0).Value = "Food"
			Me.sheetView.Cells.[Get](18, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](18, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](18, 2).Value = "Roommate2"
			Me.sheetView.Cells.[Get](18, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](18, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](19, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](19, 0).Value = "Food"
			Me.sheetView.Cells.[Get](19, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](19, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](19, 2).Value = "Roommate3"
			Me.sheetView.Cells.[Get](19, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](19, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](20, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](20, 0).Value = "Food"
			Me.sheetView.Cells.[Get](20, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](20, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](20, 2).Value = "Roommate4"
			Me.sheetView.Cells.[Get](20, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](20, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](21, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](21, 0).Value = "Travel"
			Me.sheetView.Cells.[Get](21, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](21, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](21, 2).Value = "Roommate1"
			Me.sheetView.Cells.[Get](21, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](21, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](22, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](22, 0).Value = "Travel"
			Me.sheetView.Cells.[Get](22, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](22, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](22, 2).Value = "Roommate2"
			Me.sheetView.Cells.[Get](22, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](22, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](23, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](23, 0).Value = "Travel"
			Me.sheetView.Cells.[Get](23, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](23, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](23, 2).Value = "Roommate3"
			Me.sheetView.Cells.[Get](23, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](23, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](24, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](24, 0).Value = "Travel"
			Me.sheetView.Cells.[Get](24, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](24, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](24, 2).Value = "Roommate4"
			Me.sheetView.Cells.[Get](24, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](24, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](25, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](25, 0).Value = "Other"
			Me.sheetView.Cells.[Get](25, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](25, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](25, 2).Value = "Roommate1"
			Me.sheetView.Cells.[Get](25, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](25, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](26, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](26, 0).Value = "Other"
			Me.sheetView.Cells.[Get](26, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](26, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](26, 2).Value = "Roommate2"
			Me.sheetView.Cells.[Get](26, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](26, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](27, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](27, 0).Value = "Other"
			Me.sheetView.Cells.[Get](27, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](27, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](27, 2).Value = "Roommate3"
			Me.sheetView.Cells.[Get](27, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](27, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](28, 0).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](28, 0).Value = "Other"
			Me.sheetView.Cells.[Get](28, 1).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](28, 2).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](28, 2).Value = "Roommate4"
			Me.sheetView.Cells.[Get](28, 3).Font = New System.Drawing.Font("Arial Narrow", 12F)
			Me.sheetView.Cells.[Get](28, 3).Value = "Notes"
			Me.sheetView.Cells.[Get](29, 0).Font = New System.Drawing.Font("Arial Narrow", 12F, System.Drawing.FontStyle.Bold)
			Me.sheetView.Cells.[Get](29, 1).Font = New System.Drawing.Font("Arial Narrow", 12F, System.Drawing.FontStyle.Bold)
			Me.sheetView.Columns.[Default].Width = 150F
			Me.sheetView.Columns.[Get](0).Width = 120F
			Me.sheetView.Rows.[Default].Height = 30F
			Me.sheetView.Rows.[Get](0).Height = 40F
			Me.sheetView.Rows.[Get](1).Height = 41F
			Me.sheetView.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
			' 
			' FrozenRowColDemo
			' 
			Me.AutoScaleDimensions = New System.Drawing.SizeF(6F, 13F)
			Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
			Me.Name = "FrozenRowColDemo"
			Me.pnlMain.ResumeLayout(False)
			Me.pnlControls.ResumeLayout(False)
			Me.controlsGrpBox.ResumeLayout(False)
			DirectCast(Me.trailingColumnUpDown, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.freezeColumnUpDown, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.trailingRowUpDown, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.freezeRowUpDown, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.spread, System.ComponentModel.ISupportInitialize).EndInit()
			DirectCast(Me.sheetView, System.ComponentModel.ISupportInitialize).EndInit()
			Me.ResumeLayout(False)

		End Sub

		#End Region
		Private controlsGrpBox As System.Windows.Forms.GroupBox
		Private setButton As System.Windows.Forms.Button
		Private spread As FarPoint.Win.Spread.FpSpread
		Private sheetView As FarPoint.Win.Spread.SheetView
		Private freezeRowLabel As System.Windows.Forms.Label
		Private trailingRowCount As System.Windows.Forms.Label
		Private freezeColumnLabel As System.Windows.Forms.Label
		Private trailingColumnLabel As System.Windows.Forms.Label
		Private freezeRowUpDown As System.Windows.Forms.NumericUpDown
		Private trailingRowUpDown As System.Windows.Forms.NumericUpDown
		Private freezeColumnUpDown As System.Windows.Forms.NumericUpDown
		Private trailingColumnUpDown As System.Windows.Forms.NumericUpDown
	End Class
End Namespace
