Imports System.Drawing
Imports FarPoint.Win.Spread
Imports FarPoint.Win.Spread.CellType
Imports GrapeCity.Spreadsheet
Imports Spread.Common.Features.Spread.Common.Features.Sample

Namespace Features
    Partial Public Class PieSparkline
        Inherits BaseSampleControl

        Sub New()
            InitializeComponent()
            Name = "Pie"
            InitSpreadSheet(_fpSpread.ActiveSheet)
        End Sub

#Region "Private Methods"
        Private Sub InitSpreadSheet(ByVal sheetView As SheetView)
            Dim worksheet As IWorksheet = sheetView.AsWorksheet()

            worksheet.Cells("A1:D1").Merge()
            Dim range As IRange = worksheet.Cells("A1")
            range.Value = "My Assets"
            range.Font.ApplyFont(New GrapeCity.Spreadsheet.Font() With {
                .Name = "Arial",
                .Size = 17
            })
            range.VerticalAlignment = VerticalAlignment.Center

            For i As Integer = 65 To 69 - 1
                sheetView.Cells($"{Convert.ToChar(i)}2").BackColor = ColorTranslator.FromHtml("#E3E3E3")
            Next

            worksheet.SetValue(1, 0, New Object(,) {
            {"Asset Type", "Amount", "Diagram", "Note"},
            {"House", 120000, Nothing, Nothing},
            {"401k", 78000, Nothing, Nothing},
            {"Savings", 25000, Nothing, Nothing},
            {"Bonds", 15000, Nothing, Nothing},
            {"Stocks", 9000, Nothing, Nothing},
            {"Car", 7500, Nothing, Nothing}})

            worksheet.Cells("C3:C8").Merge()
            worksheet.Cells("C3").Formula2 = "PIESPARKLINE(B3:B8,""#82bc00"",""#96c63f"",""#aacf62"",""#bcd983"",""#cee3a3"",""#dfecc3"")"
            sheetView.Cells("D3").BackColor = ColorTranslator.FromHtml("#82bc00")
            worksheet.Cells("D3").Formula = "B3/SUM(B3:B8)"
            sheetView.Cells("D4").BackColor = ColorTranslator.FromHtml("#96c63f")
            worksheet.Cells("D4").Formula = "B4/SUM(B3:B8)"
            sheetView.Cells("D5").BackColor = ColorTranslator.FromHtml("#aacf62")
            worksheet.Cells("D5").Formula = "B5/SUM(B3:B8)"
            sheetView.Cells("D6").BackColor = ColorTranslator.FromHtml("#bcd983")
            worksheet.Cells("D6").Formula = "B6/SUM(B3:B8)"
            sheetView.Cells("D7").BackColor = ColorTranslator.FromHtml("#cee3a3")
            worksheet.Cells("D7").Formula = "B7/SUM(B3:B8)"
            sheetView.Cells("D8").BackColor = ColorTranslator.FromHtml("#dfecc3")
            worksheet.Cells("D8").Formula = "B8/SUM(B3:B8)"

            worksheet.Cells("D3:D8").CellType = New PercentCellType() With {
                .DecimalPlaces = 2
            }

            worksheet.Cells("B3:B8").CellType = New CurrencyCellType() With {
                .ShowCurrencySymbol = True,
                .DecimalPlaces = 0,
                .ShowSeparator = True,
                .CurrencySymbol = "$"
            }

            worksheet.Rows("1").RowHeight = 30
            worksheet.Rows("2:8").RowHeight = 25
            worksheet.Columns("A").ColumnWidth = 100
            worksheet.Columns("B").ColumnWidth = 100
            worksheet.Columns("C").ColumnWidth = 200
        End Sub
#End Region
    End Class
End Namespace


'
'PieSparkline.Designer.vb
'


Namespace Features
    Partial Class PieSparkline

        'UserControl overrides dispose to clean up the component list.
        Protected Overloads Sub Dispose(ByVal disposing As Boolean)
            Try
                If disposing AndAlso components IsNot Nothing Then
                    components.Dispose()
                End If
            Finally
                MyBase.Dispose(disposing)
            End Try
        End Sub

        'Required by the Windows Form Designer
        Private components As System.ComponentModel.IContainer

        'NOTE: The following procedure is required by the Windows Form Designer
        'It can be modified using the Windows Form Designer.  
        'Do not modify it using the code editor.
        <System.Diagnostics.DebuggerStepThrough()>
        Private Sub InitializeComponent()
            Dim resources As System.ComponentModel.ComponentResourceManager = New System.ComponentModel.ComponentResourceManager(GetType(PieSparkline))
            Me._fpSpread = New FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None, CType(resources.GetObject("pnlMain.Controls"), Object))
            Me._fpSpread_Sheet1 = Me._fpSpread.GetSheet(0)
            Me.pnlMain.SuspendLayout()
            CType(Me._fpSpread, System.ComponentModel.ISupportInitialize).BeginInit()
            Me.SuspendLayout()
            '
            'pnlMain
            '
            Me.pnlMain.Controls.Add(Me._fpSpread)
            '
            '_fpSpread
            '
            Me._fpSpread.AccessibleDescription = "Book1, Sheet1, Row 0, Column 0"
            Me._fpSpread.Dock = System.Windows.Forms.DockStyle.Fill
            Me._fpSpread.Font = New System.Drawing.Font("Calibri", 11.0!)
            Me._fpSpread.Location = New System.Drawing.Point(0, 0)
            Me._fpSpread.Name = "_fpSpread"
            Me._fpSpread.Size = New System.Drawing.Size(477, 487)
            Me._fpSpread.TabIndex = 0
            '
            'PieSparkline
            '
            Me.AutoScaleDimensions = New System.Drawing.SizeF(6.0!, 13.0!)
            Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font
            Me.Name = "PieSparkline"
            Me.pnlMain.ResumeLayout(False)
            CType(Me._fpSpread, System.ComponentModel.ISupportInitialize).EndInit()
            Me.ResumeLayout(False)

        End Sub

        Friend WithEvents _fpSpread As FarPoint.Win.Spread.FpSpread
        Friend WithEvents _fpSpread_Sheet1 As FarPoint.Win.Spread.SheetView
    End Class
End Namespace
