﻿Imports GrapeCity.Spreadsheet
Imports FarPoint.Win.Spread
Imports GrapeCity.Spreadsheet
Imports Spread.Common.Features.Spread.Common.Features.Sample
Imports System
Imports System.IO
Imports System.Windows.Forms

Namespace Spread.Worksheet.Features
    Public Partial Class TextToColumn
        Inherits BaseSampleControl
        Public Sub New()
            InitializeComponent()

            Using stream As MemoryStream = New MemoryStream(My.Resources.CustomerData)
                _fpSpread.OpenExcel(stream)
            End Using
            _fpSpread.AsWorkbook().ActiveSheet.Cells(0, 0, 39, 0).Select()
        End Sub

        Private Sub OnTextToColumnMenuItemClick(ByVal sender As Object, ByVal e As EventArgs)
            Dim textToColumnDialog As Form = FarPoint.Win.Spread.Dialogs.BuiltInDialogs.TextToColumns(_fpSpread)

            If textToColumnDialog IsNot Nothing Then
                textToColumnDialog.Show(_fpSpread)
            End If
        End Sub

        Private Sub OnTextToColumnByCodeClick(ByVal sender As Object, ByVal e As EventArgs)
            Dim sheet As IWorksheet = _fpSpread.AsWorkbook().ActiveSheet
            Dim selection As IRange = sheet.Selection

            sheet.Cells(selection.Row, selection.Column, selection.Row2, selection.Column2).TextToColumns("$B$1", TextParsingType.Delimited, TextQualifier.DoubleQuote, False, False, False, True)
        End Sub
    End Class
End Namespace

//
// TextToColumn.Designer.cs
//

Namespace Spread.Worksheet.Features
    Partial Class TextToColumn
        ''' <summary> 
        ''' Required designer variable.
        ''' </summary>
        Private components As ComponentModel.IContainer = Nothing

        ''' <summary> 
        ''' Clean up any resources being used.
        ''' </summary>
        ''' <paramname="disposing">true if managed resources should be disposed; otherwise, false.</param>
        Protected Sub Dispose(ByVal 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()
             _fpSpread = New FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None)
            _fpSpread_Sheet1 = New FarPoint.Win.Spread.SheetView()
            menuStrip1 = New Windows.Forms.MenuStrip()
            textToColumnToolStripMenuItem = New Windows.Forms.ToolStripMenuItem()
            _textToColumnCodeToolStripMenuItem = New Windows.Forms.ToolStripMenuItem()
            pnlMain.SuspendLayout()
            CType(_fpSpread, ComponentModel.ISupportInitialize).BeginInit()
            CType(_fpSpread_Sheet1, ComponentModel.ISupportInitialize).BeginInit()
            menuStrip1.SuspendLayout()
            SuspendLayout()
            ' 
            ' pnlMain
            ' 
            pnlMain.Controls.Add(_fpSpread)
            pnlMain.Controls.Add(menuStrip1)
            pnlMain.Margin = New Windows.Forms.Padding(5, 5, 5, 5)
            pnlMain.Size = New Drawing.Size(1071, 1030)
            ' 
            ' pnlControls
            ' 
            pnlControls.Margin = New Windows.Forms.Padding(5, 5, 5, 5)
            pnlControls.Size = New Drawing.Size(355, 1030)
            ' 
            ' _fpSpread
            ' 
            _fpSpread.AccessibleDescription = ""
            _fpSpread.Dock = Windows.Forms.DockStyle.Fill
            _fpSpread.Location = New Drawing.Point(0, 28)
            _fpSpread.Margin = New Windows.Forms.Padding(4, 4, 4, 4)
            _fpSpread.Name = "_fpSpread"
            _fpSpread.Sheets.AddRange(New FarPoint.Win.Spread.SheetView() {_fpSpread_Sheet1})
            _fpSpread.Size = New Drawing.Size(1071, 1002)
            _fpSpread.TabIndex = 1
            ' 
            ' _fpSpread_Sheet1
            ' 
            _fpSpread_Sheet1.Reset()
            _fpSpread_Sheet1.SheetName = "Sheet1"
            ' Formulas and custom names must be loaded with R1C1 reference style
            _fpSpread_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1
            _fpSpread_Sheet1.ColumnFooter.DefaultStyle.BackColor = Drawing.Color.Empty
            _fpSpread_Sheet1.ColumnFooter.DefaultStyle.ForeColor = Drawing.Color.Empty
            _fpSpread_Sheet1.ColumnFooter.DefaultStyle.Locked = False
            _fpSpread_Sheet1.ColumnFooterSheetCornerStyle.BackColor = Drawing.Color.Empty
            _fpSpread_Sheet1.ColumnFooterSheetCornerStyle.ForeColor = Drawing.Color.Empty
            _fpSpread_Sheet1.ColumnFooterSheetCornerStyle.Locked = False
            _fpSpread_Sheet1.ColumnHeader.DefaultStyle.BackColor = Drawing.Color.Empty
            _fpSpread_Sheet1.ColumnHeader.DefaultStyle.ForeColor = Drawing.Color.Empty
            _fpSpread_Sheet1.ColumnHeader.DefaultStyle.Locked = False
            _fpSpread_Sheet1.DefaultStyle.BackColor = Drawing.Color.Empty
            _fpSpread_Sheet1.DefaultStyle.ForeColor = Drawing.Color.Empty
            _fpSpread_Sheet1.DefaultStyle.Locked = False
            _fpSpread_Sheet1.FilterBar.DefaultStyle.BackColor = Drawing.Color.Empty
            _fpSpread_Sheet1.FilterBar.DefaultStyle.ForeColor = Drawing.Color.Empty
            _fpSpread_Sheet1.FilterBar.DefaultStyle.Locked = False
            _fpSpread_Sheet1.FilterBarHeaderStyle.BackColor = Drawing.Color.Empty
            _fpSpread_Sheet1.FilterBarHeaderStyle.ForeColor = Drawing.Color.Empty
            _fpSpread_Sheet1.FilterBarHeaderStyle.Locked = False
            _fpSpread_Sheet1.RowHeader.DefaultStyle.BackColor = Drawing.Color.Empty
            _fpSpread_Sheet1.RowHeader.DefaultStyle.ForeColor = Drawing.Color.Empty
            _fpSpread_Sheet1.RowHeader.DefaultStyle.Locked = False
            _fpSpread_Sheet1.SheetCornerStyle.BackColor = Drawing.Color.Empty
            _fpSpread_Sheet1.SheetCornerStyle.ForeColor = Drawing.Color.Empty
            _fpSpread_Sheet1.SheetCornerStyle.Locked = False
            _fpSpread_Sheet1.SheetCornerStyle.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center
            _fpSpread_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1
            ' 
            ' menuStrip1
            ' 
            menuStrip1.ImageScalingSize = New Drawing.Size(20, 20)
            menuStrip1.Items.AddRange(New Windows.Forms.ToolStripItem() {textToColumnToolStripMenuItem, _textToColumnCodeToolStripMenuItem})
            menuStrip1.Location = New Drawing.Point(0, 0)
            menuStrip1.Name = "menuStrip1"
            menuStrip1.Size = New Drawing.Size(1071, 28)
            menuStrip1.TabIndex = 2
            menuStrip1.Text = "menuStrip1"
            ' 
            ' textToColumnToolStripMenuItem
            ' 
            textToColumnToolStripMenuItem.Name = "textToColumnToolStripMenuItem"
            textToColumnToolStripMenuItem.Size = New Drawing.Size(134, 24)
            textToColumnToolStripMenuItem.Text = "Text To Column..."
            AddHandler textToColumnToolStripMenuItem.Click, New EventHandler(AddressOf OnTextToColumnMenuItemClick)
            ' 
            ' _textToColumnCodeToolStripMenuItem
            ' 
            _textToColumnCodeToolStripMenuItem.Name = "_textToColumnCodeToolStripMenuItem"
            _textToColumnCodeToolStripMenuItem.Size = New Drawing.Size(209, 24)
            _textToColumnCodeToolStripMenuItem.Text = "Text To Column (With Code)"
            AddHandler _textToColumnCodeToolStripMenuItem.Click, New EventHandler(AddressOf OnTextToColumnByCodeClick)
            ' 
            ' TextToColumn
            ' 
            AutoScaleDimensions = New Drawing.SizeF(8F, 16F)
            AutoScaleMode = Windows.Forms.AutoScaleMode.Font
            Margin = New Windows.Forms.Padding(5, 5, 5, 5)
            Name = "TextToColumn"
            Size = New Drawing.Size(1427, 1030)
            pnlMain.ResumeLayout(False)
            pnlMain.PerformLayout()
            CType(_fpSpread, ComponentModel.ISupportInitialize).EndInit()
            CType(_fpSpread_Sheet1, ComponentModel.ISupportInitialize).EndInit()
            menuStrip1.ResumeLayout(False)
            menuStrip1.PerformLayout()
            ResumeLayout(False)

        End Sub

#End Region

        Private _fpSpread As FarPoint.Win.Spread.FpSpread
        Private _fpSpread_Sheet1 As FarPoint.Win.Spread.SheetView
        Private menuStrip1 As Windows.Forms.MenuStrip
        Private textToColumnToolStripMenuItem As Windows.Forms.ToolStripMenuItem
        Private _textToColumnCodeToolStripMenuItem As Windows.Forms.ToolStripMenuItem
    End Class
End Namespace
