Spread WinForms 18
Demos
Blog
Support
Pricing
Download
Spread Windows Forms 18
GrapeCity.Spreadsheet Assembly
/
GrapeCity.Spreadsheet Namespace
/
IRange Interface
/ TextToColumns Method
Collapse All
Expand All
Language Filter: All
Language Filter: Multiple
Language Filter: Visual Basic
Language Filter: Visual Basic (Declaration)
Language Filter: Visual Basic (Usage)
Language Filter: C#
Visual Basic (Declaration)
Visual Basic (Usage)
C#
In This Topic
Overload List
See Also
Spread Windows Forms 18 Product Documentation
Getting Started
Handling Installation
Installing the Product
Activating the Product
End-User License Agreement
Creating a Runtime License
Handling Redistribution
Product Requirements
Using Windows Regional Settings or Options
Using Satellite Assemblies for Languages
Understanding the Spread Wizard
Starting the Spread Wizard
Using the Spread Wizard
Getting More Practice
Finding the Documentation
Getting Technical Support
Tutorial: Creating a Checkbook Register
Adding Spread to the Checkbook Project
Setting Up the Rows and Columns of the Register
Setting the Cell Types of the Register
Adding Formulas to Calculate Balances
Developer's Guide
Understanding the Product
Product Overview
Shortcut Objects
Underlying Models
Formatted versus Unformatted Data
Cell Types
Key Features
Working with the Component
Adding NuGet Package in Spread Windows Forms
Migrate .NET Framework Project to .NET 8 Platform
Migrate .NET Framework Project to .NET 6 Platform
Adding a Component to a Visual Studio 2019 or 2022 Project
Adding a Component to a Visual Studio 2017 Project
Setting the Properties
Using Verbs in the Properties Window
Using Smart Tags Drop-Down
Working with Collection Editors
Adding Support for High DPI Settings
Spreadsheet Objects
Understanding Parts of the Component
Object Parentage
Resetting Parts of the Interface
Rich Text Editing
Improving Performance by Suspending the Layout
Ways to Improve Performance
Allowing User Functionality
Allowing the User to Zoom the Display of the Component
Working with Scroll Bars
Customizing the Scroll Bars
Customizing the Position in the Display
Customizing Scroll Bar Tips
Adding a Status Bar
Customizing Viewports
Customizing Split Boxes
Working With Slicers
Working with Built-In Dialogs
Ribbon Control
Sheets
Working with the Active Sheet
Working with Multiple Sheets
Customizing the Sheet Name Tabs
Navigating Sheet Tabs
Adding a Sheet
Adding ChartSheet
Removing a Sheet
Showing or Hiding a Sheet
Moving a Sheet
Selecting Multiple Sheets
Copying and Inserting a Sheet
Protecting a Worksheet
Form Controls
Adding a Title and Subtitle to a Sheet
Placing Child Controls on a Sheet
Displaying a Footer for Columns or Groups
Adding a Tag to a Sheet
Working with 1-Based Indexing
Customizing Clipboard Operation Options
Rows and Columns
Customizing the Number of Rows or Columns
Adding a Row or Column
Removing a Row or Column
Showing or Hiding a Row or Column
Setting the Row Height or Column Width
Resizing the Row or Column to Fit the Data
Allowing the User to Resize Rows or Columns
Using Auto Row Height
Setting Fixed (Frozen) Rows or Columns
Moving Rows or Columns
Creating Alternating Rows
Setting up Preview Rows
Input Data in Rows or Columns
Rows or Columns That Have Data
Adding a Tag to a Row or Column
Headers
Understanding Headers
Showing or Hiding Headers
Setting the Height or Width of Header
Setting the Header Text
Customizing Header Label Text
Customizing the Default Header Labels
Wrapping the Header Text
Customizing the Appearance of Headers
Customizing the Style of Header Cells
Customizing the Header Grid Lines
Adding a Gradient to Header Cells
Auto Expand Row Headers
Creating a Header with Multiple Rows or Columns
Creating a Span in a Header
Customizing the Sheet Corner Appearance
General Style of the Sheet Corner
Text Display in the Sheet Corner
Table Display in the Sheet Corner
Customizable Cell in the Sheet Corner
Cell Spans in the Sheet Corner
Header Count Synchronization in the Sheet Corner
Drawing (Rendering) Style
Cells
Working with the Active Cell
Adding Hyperlink in a Cell
Creating a Range of Cells
Managing Data on a Sheet
Placing and Retrieving Data
Handling Data Using Sheet Methods
Handling Data Using Cell Properties
Moving Data on a Sheet
Copying Data on a Sheet
Repeatedly Filling a Range of Cells with Copied Cells
Swapping Data on a Sheet
Removing Data from a Sheet
Remove Duplicates from Range
Text to Columns
Creating Data Type for Custom Objects
Displaying Cell Data
Resizing the Data to Fit the Cell
Allowing Cell Data to Overflow
Aligning Cell Contents
Resizing a Cell to Fit the Data
Creating a Span of Cells
Allowing Cells to Merge Automatically
Adding a Note to a Cell
Adding a Tag to a Cell
Displaying Text Tips in a Cell
Working with Cell Format Strings
Working with Pattern and Gradient Fill Effects
Inserting Cells
Setting Rich Text in a Cell
Adding a Comment to a Cell
Adding Image in a Cell
Formatting a Cell Value
Cell Types
Understanding Cell Type Basics
Understanding How Cell Types Work
Understanding How Cell Types Display and Format Data
Understanding How Cell Type Affects Model Data
Working with Editable Cell Types
Setting a General Cell
Setting a Text Cell
Setting a Date-Time Cell
Customizing the Pop-Up Date-Time Control
Setting a GcCharMask Cell
Setting a GcDateTime Cell
Setting a GcMask Cell
Setting a GcNumber Cell
Setting a GcTextBox Cell
Setting a GcComboBox Cell
Setting a GcTimeSpan Cell
Setting a Number Cell
Setting a Currency Cell
Setting a Mask Cell
Setting a Percent Cell
Setting a Regular Expression Cell
Setting a Rich Text Cell
Working with Graphical Cell Types
Setting a Barcode Cell
Setting a Button Cell
Setting a Check Box Cell
Setting a Color Picker Cell
Setting a Combo Box Cell
Allowing a Combo Box Cell to Handle a Double Click
Setting a Hyperlink Cell
Setting an Image Cell
Setting a List Box Cell
Setting a Multiple-Column Combo Box Cell
Setting a Multiple Option Cell
Setting a Progress Indicator Cell
Setting a Slider Cell
Understanding Additional Features of Cell Types
Allowing the Display of Buttons in a Cell
Displaying Spin Buttons
Limiting Values for a Numeric Cell
Customizing the Pop-Up Calculator Control
Customizing Automatic Completion (Type Ahead)
Working with a SubEditor
Creating a Custom Cell Type
Data Binding
Binding to Data
Binding Spread to an External Data Set
Binding a Cell Range in Spread to an External Data Source
Binding a Cell Range in Spread as a Data Source to an External Control
Binding a Combo Box to a DataReader
Customizing Data Binding
Adding an Unbound Column to a Bound Sheet
Customizing Column and Field Binding
Customizing Cell Types for Bound Sheets
Customizing Column Headers for Bound Sheets
Adding to Bound Data
Adding a Row to a Bound Sheet
Adding an Unbound Row to a Bound Sheet
Working with Hierarchical Data Display
Creating a Hierarchical Display Manually
Creating Custom Hierarchy Icons
Tutorial: Binding to a Corporate Database (Visual Studio 2013 or later)
Customizing the Sheet Appearance
Customizing the Dimensions of the Component
Customizing the Individual Sheet Appearance
Setting the Background Colors for a Sheet
Coloring a Cell
Setting a Background Image for a Sheet
Setting a Background Image to a Cell
Customizing the Appearance of a Cell
Customizing the Outline of the Component
Displaying Grid Lines on a Sheet
Creating and Customizing Cell Borders
Creating a Complex Border with Multiple Lines
Customizing the Overall Component Appearance
Setting the Component to the Original Appearance
Applying a Skin to the Component
Creating a Custom Skin for a Component
Applying a Skin to a Sheet
Creating a Custom Skin for a Sheet
Saving and Loading a Skin
Saving a Skin
Loading a Skin
Creating and Applying a Style for Cells
Using Conditional Formatting of Cells
Creating Conditional Formatting with Rules
Color Scale Rules
Data Bar Rule
Icon Set Rule
Highlighting Rules
Top, Bottom, or Average Rules
Setting up Conditional Formatting of a Cell
Customizing the Display of the Pointer
Customizing the User Interface Images
Using XP Themes with the Component
Customizing the Renderers
Handling Right-to-Left Layouts
Customizing Painting of Parts of the Component
Text Rendering with GDI
Applying Theme to Customize the Appearance
Customizing Interaction in Cells
Using Edit Mode and Focus
Understanding Edit Mode in a Cell
Locking a Cell
Customizing User Selection and Deselection of Data
Specifying What the User Can Select
Customizing the Selection Appearance
Working with Selections
Hiding the Selection When Focus is Lost
Working with Deselections
Using Drag Operations to Fill Cells
Filling Cells with Drag and Drop
Filling Cells with Drag and Fill
Filling Cells with Drag and Move
Using Double Click to Fill Cells
Using Validation
Using Validation in Cells
Using a Cell Comparison Validator
Using a Character Format Validator
Using a String Comparison Validator
Using a Value Comparison Validator
Using an Encoding Validator
Using the Exclude List Validator
Using the Include List Validator
Using a Pair Validator
Using the Range Validator
Using a Regular Expression Validator
Using a Required Field Validator
Using a Required Type Validator
Using a Surrogate Character Validator
Using a Text Length Validator
Validating User Input
Customizing the User Error Messages
Displaying Error Icons in Cells or Rows
Using Visible Indicators in the Cell
Locating the Pointer Using HitTest
Returning Information for a Clicked Cell
Preventing a Cell from Receiving Focus
Customizing the Focus Indicator for a Cell
Customizing Undo and Redo Actions
Customizing Interaction Based on Events
Displaying Context Menu at Runtime
Adding Custom Context Menu to a Component
Tables
Adding a Table
Using Table Filters
Resizing a Table
Sorting a Table
Setting Table Styles
Binding a Table
Auto Updating Filters in Table
Adding a Table Formula
Understanding Structured References
Using Operators and Special Items
Understanding Structured Reference Syntax Rules
Using Structured References
Understanding the Underlying Models
Finding More Details on the Sheet Models
Understanding the Sheet Model Classes and Interfaces
Understanding the Data Model
Understanding the Axis Model
Understanding the Selection Model
Understanding the Span Model
Understanding the Style Model
Creating a Custom Sheet Model
Understanding the Optional Interfaces
Customizing Row or Column Interaction
Managing Sorting of Rows of User Data
Allowing the User to Automatically Sort Rows
Using Automatic Sorting
Sorting Rows, Columns, or Ranges
Setting the Appearance of Sort Indicators
Managing Cell Range Sorting
Managing Filtering of Rows of User Data
Allowing the User to Filter Rows
Setting the Appearance of Filtered Rows
Customizing Simple Filtering
Understanding Simple Row Filtering
Customizing the Filter List
Defining the Contents of the Filter Item List
Defining the Order of the Items in the Filter Item List
Setting the Appearance of the Display of the Filter Item List
Creating a Custom Filter
Customizing Enhanced Filtering
Adding a Custom Sort Dialog
Customizing the Filter Bar
Setting the Appearance of Filter Indicators
Using Custom Filter Indicator Images
Showing or Hiding Filter Indicators
Determining Which Header Row Displays the Indicators
Managing Cell Range Filtering
Managing Grouping of Rows of User Data
Allowing the User to Group Rows
Using Grouping
Setting the Appearance of Grouped Rows
Customizing the Group Bar
Creating a Custom Group
Interoperability of Grouping with Other Features
Managing Outlines (Range Groups) of Rows and Columns
Using an Outline (Range Group) of Rows or Columns
Customizing the Appearance of an Outline (Range Group)
Interoperability of Outlines with Other Features
Customizing User Searching of Data
Allowing the User to Perform a Standard Search
Allowing the User to Perform an Advanced Search
Searching for Data with Code
Copying Size and Style of Row/Column on Insert
Formulas in Cells
Placing a Formula in Cells
Displaying Formula in Cells
Specifying a Cell Reference in a Formula
Specifying a Sheet Reference in a Formula
Specifying an External Reference in a Formula
Using a Circular Reference in a Formula
Using DataTable Formula
Nesting Functions in a Formula
Recalculating and Updating Formulas Automatically
Finding a Value Using GoalSeek
Allowing the User to Enter Formulas
Creating and Using a Custom Name
Creating and Using a Custom Function
Creating and Using a Visual Function
Creating and Using External Variable
Using External Variables with Text Box Control
Using the Array Formula
Working With Dynamic Array Formulas
Working with the Formula Text Box
Setting up the Formula Provider
Setting up the Name Box
Using Language Package
Available Language Packages for WinForms
Creating and Using a Custom Language Package
Accessing Data from Header or Footer
Auto Format Formulas
Managing External Reference
Precedents and Dependents
Sparklines
Add Sparklines Using Methods
Specifying Horizontal and Vertical Axes
Customizing Markers and Points
Working with Sparklines
Add Sparklines using Formulas
Column, Line, and Winloss Sparkline
Area Sparkline
BoxPlot Sparkline
Bullet Sparkline
Cascade Sparkline
Gauge KPI Sparkline
Hbar and Vbar Sparkline
Histogram Sparkline
Image Sparkline
Month and Year Sparkline
Pareto Sparkline
Pie Sparkline
Scatter Sparkline
Spread Sparkline
Stacked Sparkline
Vari Sparkline
Keyboard Interaction
Underlying Keystroke Processing
Factors of Keyboard Map Usage
Default Keyboard Navigation
Default Keyboard Maps
Default Map for Normal and WhenFocused
Default Map for Normal and WhenAncestorOfFocused
Default Map for ReadOnly and WhenFocused
Default Map for ReadOnly and WhenAncestorOfFocused
Default Map for ReadOnly and WhenAncestorOfFocused
Default Map for RowMode and WhenAncestorOfFocused
Default Map for SingleSelect and WhenFocused
Default Map for SingleSelect and WhenAncestorOfFocused
Default Map for MultiSelect and WhenFocused
Default Map for MultiSelect and WhenAncestorOfFocused
Default Map for ExtendedSelect and WhenFocused
Default Map for ExtendedSelect and WhenAncestorOfFocused
Deactivating the Default Keyboard Map
Changing the Default Keyboard Map
Using Input Maps with Action Maps
Customizing the Input Maps
Changing an Input Map for a Child View
Saving and Loading Map Files
Using Excel-compatible Keyboard Shortcuts
Using the Excel Compatibility Input Maps
Default Map for Excel Compatibility
Events from User Actions
Clicking Actions
Selecting Actions
Entering Data Actions
Sheet-Level Actions
Interactivity Actions
Shape Actions
Print Actions
File Operations
Saving Data to a File
Saving to a Spread XML File
Saving to an Excel File
Saving to a PDF File
Saving to a Text File
Saving to an Image File
Saving to an HTML File
Adding Custom Properties
Saving to an HTML Table
Saving Spreadsheet Data to Simple XML
Opening Existing Files
Opening an XML Data File
Opening an Excel File
Opening a Custom Text File
Opening a Spread COM File
Using Serialization
Implementing a Serializer Class
Parsing Formulas in Custom XML Deserialization
Storing Excel Summary and View
Printing
Specifying What to Print
Printing an Entire Sheet
Printing to PDF
Printing a Child View of a Hierarchical Display
Printing Particular Pages
Printing the Portion of the Sheet with Data
Printing a Range of Cells on a Sheet
Printing an Area of the Sheet
Printing a Sheet with Cell Notes
Printing a Sheet with Shapes
Printing in Duplex Mode
Customizing the Appearance of the Printing
Understanding the Printing Options
Customizing the Print Job Settings
Customizing the Printed Page Layout
Customizing the Printed Page Header or Footer
Customizing the Print Preview Dialog
Repeating Rows or Columns on Printed Pages
Adding a Page Break
Adding a Watermark to a Printed Page
Optimizing the Printing
Optimizing the Printing Using Rules
Optimizing the Printing Using Size
Displaying Dialogs for Users
Displaying a Print Dialog for the User
Displaying an Abort Message for the User
Modifying the PageSetup Dialog for the User
Providing a Preview of the Printing
Chart Control
Understanding Charts
Chart User Interface Elements
Chart Object Model
Chart Types and Views
Plot Types
Y Plot Types
Bar Charts
Area Charts
Box Whisker Charts
Funnel Charts
Histogram Charts
Line Charts
Market Data (High-Low) Charts
Pareto Charts
Point Charts
Stripe Charts
Waterfall Charts
XY Plot Types
XY Bubble Charts
XY Point Charts
XY Line Charts
XY Stripe Charts
XYZ Plot Types
XYZ Point Charts
XYZ Line Charts
XYZ Surface Charts
XYZ Stripe Charts
Pie Plot Types
Doughnut Charts
Pie Charts
Polar Plot Types
Polar Point Charts
Polar Line Charts
Polar Area Charts
Polar Stripe Charts
Pie Charts
Radar Plot Types
Radar Point Charts
Radar Line Charts
Radar Area Charts
Radar Stripe Charts
Data Plot Types
Plot area
Series
Walls
Axis
Chart Line Style
Elevation and Rotation
Lighting, Shapes, and Borders
Labels
Multi-Level Category Labels
Legends
Error Bars
Creating Charts
Using the Chart Control on sheet
Allowing the User to Change the Chart
Saving or Loading a Chart
Using the Chart Control
Save/Load Chart Control
Creating Plot Types
Creating a Y Plot
Creating an XY Plot
Creating an XYZ Plot
Creating a Pie Plot
Creating a Polar Plot
Creating a Radar Plot
Creating a Sunburst Chart
Creating a Treemap Chart
Combining different types of plots
Connecting to Data
Using a Bound Data Source
Using an UnBound Data Source
Binding with cell range
Advanced chart settings
Fill Effects
View Type
Customizing Drawing
Working with Shapes in Code
Creating Camera Shapes
Allowing the User to Draw with a Tablet PC
Working With Shapes (Enhanced Shape Engine)
Creating Enhanced Camera Shape
Working with Images
Touch Support with the Component
Understanding Touch Messages
Using a Touch Keyboard
Using the Touch Menu Bar
Using Touch Support
Using Touch Support with AutoFit
Using Touch Support with Cell Notes
Using Touch Support with Charts
Using Touch Support with Clipboard Operations
Using Touch Support with Drag and Fill
Using Touch Support with Drop-Down Elements
Using Touch Support with Editable Cells
Using Touch Support with InputMan Cells
Using Touch Support with Filtering
Using Touch Support with Range Grouping
Using Touch Support with Grouping
Using Touch Support when Moving Columns or Rows
Using Touch Support when Resizing Columns or Rows
Using Touch Support with Scrolling
Using Touch Support with Selections
Using Touch Support with Shapes
Using Touch Support when Sorting
Using Touch Support with Viewports
Using Touch Support with the Tab Strip
Using Touch Support with Zooming
Spread Designer Guide
Introduction
Overview of Spread Designer Features
Starting Spread Designer
Using Spread Designer in Runtime
Getting Started Designing
Understanding Applied Settings
Simple Example Using Spread Designer
Running Spread Designer Stand Alone
Spread Designer User Interface
Spread Designer Menus
File Menu
Home Menu
Insert Menu
Page Layout Menu
Formulas Menu
Data Menu
View Menu
Settings Menu
Help Menu
Context Menu
Sheet Context Menu
Table Context Menu
Spread Designer Quick Access Toolbar
Spread Designer Data Area
Spread Designer Property Window
Spread Designer Status Bar
Formula Bar
Spread Designer Dialogs
Cell Type Dialog
BarCode Tab
Button Tab
Check Box Tab
Color Picker Tab
Combo Box Tab
Currency Tab
Date-Time Tab
General Tab
Background Tab
Hyperlink Tab
Image Tab
Label Tab
ListBox Tab
Mask Tab
MultiColumnComboBox Tab
MultiOption Tab
Number Tab
Percent Tab
Progress Tab
Regular Expression Tab
Rich Text Tab
Slider Tab
Text Tab
GcTextBox Tab
GcMask Tab
GcCharMask Tab
GcDateTime Tab
GcTimeSpan Tab
GcNumber Tab
GcComboBox Tab
Conditional Formatting Dialog
Cell Styles Dialog
Custom File Options Dialog
Forecast Sheet Dialog
Goal Seek Dialog
Go To Cell Dialog
Insert Function Dialog
Name Manager Dialog
Row Height or Column Width Dialog
Row or Column Insert or Delete Dialogs
Shape Properties Dialog
Shape Shadow Properties Dialog
Sheet Settings Dialog
General tab
Colors tab
Headers tab
Grid Lines tab
Calculations tab
Font tab
Sheet Print Settings Dialog
General tab
SmartPrint Tab
Output tab
Header/Footer tab
Pagination tab
Margins tab
Sort Dialog
Spread Settings Dialog
Edit tab
Scroll Bars Tab
General Tab
Split Box Tab
View Tab
Unhide Specific Row or Column Dialogs
Zoom Dialog
Spread Designer Editors
Alternating Row Collection Editor
Border Editor
Cells, Columns, and Rows Editor
Formula Editor
Formatter and Editor
Focus Indicator Editor
DefaultGroupFooter Editor
GroupInfo Collection Editor
Header Editor
Footer Editor
SheetSkin Editor
SheetView Collection Editor
Shortcut Collection Editor
SmartPrintRule Collection Editor
SpreadChart Collection Editor
SpreadSkin Editor
Named Style Editor
TabStrip Editor
InputMap Editor
Designing in the Data Area
Selecting an Item in the Spread Designer
Selecting an Individual Cell
Selecting the Cells with Data
Selecting a Contiguous Range of Cells
Selecting a Row of Cells
Selecting a Column of Cells
Selecting a Sheet of Cells
Selecting an Entire FpSpread Component
Setting Properties in Spread Designer
Setting Sheet Properties in Spread Designer
Setting Row Properties in Spread Designer
Setting Column Properties in Spread Designer
Setting Cell Properties in Spread Designer
Setting Table Properties in Spread Designer
Entering a Formula in Spread Designer
Adding and Customizing Sheets
Rich Text Editing
Working with the Design
Resetting and Clearing Design Work
Printing a Sheet from Spread Designer
Previewing a Sheet in Spread Designer
Saving and Opening Design Files
Applying the Design to the Form
Designing Shapes
Understanding the Built-in Shapes
Things to Do with Any Shape
Adding a Shape to a Sheet
Editing the Points of a Shape
Changing the Appearance of a Shape
Rotating a Shape
Resizing a Shape
Moving a Shape
Adding Hyperlink to a Shape
Adding a Drop Shadow
Locking a Shape
Using Keys with Shapes
Customizing Particular Shapes
Customizing Text as a Shape
Customizing a Polygon
Customizing a Line as an Arrow
Advanced Topics for Shapes
Creating a Custom Compound Shape
Using Shapes with Maps
Using Pictures in Shapes
Using the Chart Designer
Adding Charts
Opening the Chart Designer
Chart Collection Editors
LabelArea Collection Editor
LegendArea Collection Editor
PlotArea Collection Editor
Light Collection Editor
Series Collection Editor
Chart Designer Toolbar
Applying and Customizing Themes
Assembly Reference
FarPoint.CalcEngine Assembly
FarPoint.Excel Assembly
FarPoint.PDF Assembly
FarPoint.Win Assembly
FarPoint.Win.Chart Assembly
FarPoint.Win.Spread Assembly
GrapeCity.CalcEngine Assembly
GrapeCity.Spreadsheet Assembly
Namespaces
GrapeCity.CalcEngine Namespace
Overview
Classes
BuiltInRichValue
FormattedCellValue
RichValue<T>
VisualizationData
Enumerations
AggregateOption
SizingMode
Interfaces
IFunctionVisualizer
IIntelliSenseFunction
INotSupportedParams
GrapeCity.Core Namespace
Overview
Classes
DocumentProperty
Theme
ThemeColorScheme
ThemeEffectScheme
ThemeFontScheme
Enumerations
BuiltInColorSchemes
BuiltinDocumentProperties
BuiltInFontSchemes
BuiltInThemes
ColorTransformType
ColorType
DocumentPropertyType
KnownColor
SchemeThemeColors
ThemeColors
ThemeFontLanguage
Structures
ColorTransform
SchemeColor
Interfaces
IConvertible<T>
ICustomProperties
ICustomProperty
IDocumentProperties
GrapeCity.Spreadsheet Namespace
Overview
Classes
Authors
BuiltInNumberFormats
CalculationEngine
CellImageAttribute
CellValueChangedEventArgs
ColorStop
DisplayFormat
ExpressionViewCell
Features
RichText
WorksheetOptions
Enumerations
AboveBelow
AlignmentAttributes
AutoFillType
AutoFilterOperator
Behaviors
BorderLineStyle
BordersIndex
BuiltInSlicerStyles
BuiltInStyle
BuiltInTableStyles
CalcFeatures
Calculation
CalculationOnDemandMode
CalendarType
CellDataType
CfValueType
CharacterSet
ChartLocks
ClassicCfRuleType
ColorType
ColumnDataType
Compatibility
ContainsOperator
CustomFilterOperator
CutCopyMode
DatabarAxisPosition
DatabarBorderType
DatabarDirection
DatabarFillType
DatabarNegativeColorType
DataRestrictions
DataValidationErrorStyle
DataValidationOperator
DataValidationType
DateTimeGrouping
DeleteShiftDirection
Direction
DisplayBlanksAs
DisplayValueStyle
DupeUnique
DynamicFilterType
EnableSelection
FilterDataType
FilterOptions
FilterScopes
FindLookIn
FontAttributes
FontFamily
FontStyle
FormatColorEnum
FormatConditionOperator
FormatConditionType
FormatOptions
GradientType
HorizontalAlignment
HyperlinkType
IconSetType
ImeMode
InsertFormatOrigin
InsertShiftDirection
LookAt
ManipulationOptions
MergePolicy
NewRowPosition
NumberFormatConvertMode
Operator
PageBreak
PasteSpecialOperation
PasteType
PatternType
PredefinedNumberFormats
ProtectionMode
ReferenceStyle
SearchDirection
SearchOrder
SheetViewType
SheetVisibility
SortDataOption
SortMethod
SortOn
SortOrder
SortOrientation
SparklineRowCol
SparkScale
SparkType
SpecialCellsValue
SpecialCellType
StyleFormatApplyment
SummaryColumn
SummaryRow
TableStyleElementType
TableStyleSettings
TableType
TextParsingType
TextQualifier
TextReadingOrder
ThemeFont
TimePeriods
TopBottom
TotalsCalculation
UnderlineStyle
UpdateLinks
VerticalAlignment
VerticalTextAlignment
WorkbookLocks
WorksheetLocks
WorksheetSubType
WorksheetType
YesNoCancel
YesNoGuess
Structures
ActionResult<T>
Alignment
AutoFilterColumn
Border
BorderLine
Break
CellProtection
CellReference
CfExecutedResult
CfIcon
CfValue
Color
CustomFilterCriteria
DataValidationExecutedResult
DataValidationSuggestionItem
DateGroupItem
Fill
FormatResult
GradientFillEffect
GradientStop
NumberFormat
Reference
StyleFormat
TableStyleElement
WorksheetReference
Interfaces
IAboveAverage
IAlternatingStyles
IAreas
IArray<T>
IAuthor
IAutoFilter
IAutoFilterOwner
IBorder
IBorders
ICellEditor
ICellRenderer
ICellType
ICharacters
IColorPalette
IColorScale
IColorScaleCriteria
IColorScaleCriterion
IColorStops
IColumnFooter
IColumnHeader
IComment
IComments
ICommentsThreaded
ICommentThreaded
IConditionValue
IDatabar
IDatabarBorder
IDataManager
IFilter
IFilters
IFont
IFormatCondition
IFormatConditions
IFormatter
IGradient
IGraphic
IHyperlink
IHyperlinks
IIconCriteria
IIconCriterion
IIconSetCondition
IInterior
IMedia
IName
INames
INegativeBarFormat
INumFmtSupportCellType
IOutline
IProtection
IRange
Overview
Members
Methods
Activate Method
AddComment Method
AddComment(String) Method
AddComment(RichText) Method
AddCommentThreaded Method
Address Method
Address(Boolean,Boolean,ReferenceStyle,Boolean,CellReference,Boolean) Method
Address(Boolean,Boolean,ReferenceStyle,Boolean,String) Method
Address(Boolean,Boolean,ReferenceStyle,Boolean,IRange) Method
ApplyNumberFormat Method
ApplyStyle Method
ApplyStyle(String) Method
ApplyStyle(BuiltInStyle) Method
ApplyStyleFormat Method
AutoFill Method
AutoFill(String,AutoFillType) Method
AutoFill(Int32,Int32,Int32,Int32,AutoFillType) Method
AutoFilter Method
AutoFilter(Boolean,Boolean) Method
AutoFilter(Int32,Fill) Method
AutoFilter(Int32,Color) Method
AutoFilter(Int32,DynamicFilterType) Method
AutoFilter(Int32,CfIcon) Method
AutoFilter(Int32,Object,AutoFilterOperator,Object) Method
AutoFit Method
BorderAround Method
BorderAround(BorderLineStyle) Method
BorderAround(BorderLineStyle,Color) Method
Calculate Method
Characters Method
Clear Method
ClearHyperlinks Method
Copy Method
Copy(Int32,Int32,ManipulationOptions) Method
Copy(IRange,ManipulationOptions) Method
Copy(String,ManipulationOptions) Method
Copy(Boolean,Boolean) Method
CreateCamera Method
CreateTable Method
Cut Method
DataTable Method
DataTable(String,String) Method
DataTable(CellReference,CellReference) Method
DataTable(IRange,IRange) Method
Delete Method
Dirty Method
End Method
FillDown Method
FillLeft Method
FillRight Method
FillUp Method
Find Method
FindNext Method
FindPrevious Method
GetFullDependents Method
GetFullPrecedents Method
GoalSeek Method
GoalSeek(Double,IRange,Boolean) Method
GoalSeek(Double,String,Boolean) Method
GoalSeek(Double,CellReference,Boolean) Method
Group Method
Insert Method
InsertIndent Method
InsertPictureInCell Method
InsertPictureInCell(String) Method
InsertPictureInCell(Stream) Method
Merge Method
Move Method
Move(Int32,Int32,ManipulationOptions) Method
Move(IRange,ManipulationOptions) Method
Move(String,ManipulationOptions) Method
Offset Method
PastePictureInCell Method
PasteSpecial Method
Range Method
RemoveDuplicates Method
Resize Method
Select Method
Show Method
ShowCard Method
SpecialCells Method
TextToColumns Method
TextToColumns(Int32,Int32,TextParsingType,TextQualifier,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Char,Tuple<Int32,ColumnDataType>[],Char,Char,Boolean) Method
TextToColumns(IRange,TextParsingType,TextQualifier,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Char,Tuple<Int32,ColumnDataType>[],Char,Char,Boolean) Method
TextToColumns(String,TextParsingType,TextQualifier,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Char,Tuple<Int32,ColumnDataType>[],Char,Char,Boolean) Method
Ungroup Method
UnMerge Method
Properties
AllowEdit Property
Areas Property
Borders Property
Cells Property
CellType Property
Column Property
Column2 Property
ColumnCount Property
Columns Property
ColumnWidth Property
Comment Property
CommentThreaded Property
Count Property
CurrentArray Property
CurrentRegion Property
Dependents Property
DirectDependents Property
DirectPrecedents Property
DisplayFormat Property
EntireColumn Property
EntireRow Property
Font Property
FormatConditions Property
FormattedValue Property
Formula Property
Formula2 Property
Formula2R1C1 Property
FormulaArray Property
FormulaR1C1 Property
HasArray Property
HasFormula Property
HasRichDataType Property
HasSpill Property
Height Property
Hidden Property
HorizontalAlignment Property
Hyperlinks Property
IndentLevel Property
Interior Property
Item Property
Item(String) Property
Item(Int32) Property
Item(Int32,Int32) Property
Item(Int32,Int32,Int32,Int32) Property
Item(Reference) Property
Left Property
Locked Property
MergeArea Property
MergeCells Property
MergePolicy Property
Next Property
NumberFormat Property
Orientation Property
OutlineLevel Property
PageBreak Property
Precedents Property
Previous Property
Resizable Property
Row Property
Row2 Property
RowCount Property
RowHeight Property
Rows Property
ShowDetail Property
ShrinkToFit Property
SparklineGroups Property
Style Property
Summary Property
Table Property
Text Property
Top Property
UseStandardHeight Property
UseStandardWidth Property
Validation Property
Value Property
VerticalAlignment Property
Width Property
Worksheet Property
WrapText Property
IReadonlyArray<T>
IRowHeader
ISheet
ISheets
ISheetView
ISort
ISortComparer
ISortField
ISortFields
ISparkAxes
ISparkColor
ISparkHorizontalAxis
ISparkline
ISparklineGroup
ISparklineGroups
ISparkPoints
ISparkVerticalAxis
IStyle
IStyles
ITable
ITableColumn
ITableColumns
ITableRow
ITableRows
ITables
ITableStyle
ITableStyleElement
ITableStyleElements
ITableStyles
ITop10
IUniqueValues
IValidation
IWorkbook
IWorkbooks
IWorkbookSet
IWorksheet
IWorksheets
IWorksheetStyles
IWorksheetView
GrapeCity.Spreadsheet.Charts Namespace
Overview
Classes
ChartCommand.SeriesChartTypeData
ChartElementSelectedEventArgs
ChartElementSelectingEventArgs
ChartStyle
ColorStyle
DisplayUnits
Enumerations
AxisGroup
AxisType
BarDirection
BarGrouping
BarShape
BinsType
CategoryType
ChartCommand.ComboChartType
ChartElementPosition
ChartHitTestType
ChartLocation
ChartProtection
ChartSplitType
ChartType
ColorStyleMethod
CrossBetween
Crosses
DataLabelPosition
DataLabelVisibilities
DisplayUnit
EndStyleCap
ErrorBarDirection
ErrorBarInclude
ErrorBarType
Grouping
LabelAlignment
LayoutMode
LayoutTarget
LegendPosition
MarkerStyle
OfPieType
ParentLabelLayout
PictureFormat
Position
PositionAlignment
QuartileMethod
RadarStyle
RegionLabelLayout
RowCol
ScaleType
ScatterStyle
SizeRepresents
SplitType
TickLabelPosition
TickMark
TimeUnit
TrendlineType
Interfaces
IAxes
IAxis
IAxisTitle
IBoxWhiskerOptions
IChart
IChartArea
IChartFormat
IChartGroup
IChartGroups
IChartObject
IChartObjects
ICharts
IChartTitle
IDataLabel
IDataLabels
IDataTable
IDisplayUnitLabel
IDropLines
IErrorBars
IFloor
IHiLoLines
ILeaderLines
ILegend
ILegendEntries
ILegendEntry
IPlotArea
IPoint
IPoints
ISeries
ISeriesCollection
ISeriesLines
ITickLabels
ITrendline
ITrendlines
IUpDownBars
IWalls
GrapeCity.Spreadsheet.Commands Namespace
Overview
Classes
Command
CommandManager
Enumerations
AutoFilterActions
CellStyleCommand.IncludeStyle
FormatOption
HyperLinkAction
NoteActionsCommand.NoteCommandAction
PictureCommand.PictureStylePreset
PictureCommand.RecolorPreset
RangeActionsCommand.Actions
RangeActionsCommand.MergeOption
RowColumnActionsCommand.Actions
RowColumnActionsCommand.GroupActions
RowColumnCommand.Actions
ShapeActionsCommand.ShapeGlowPreset
ShapeActionsCommand.ShapeGradientPreset
SlicerActionsCommand.Actions
SparklineCommand.SparklineStylePreset
TableActions
ThreadedCommandAction
Delegates
LegacyClipboardCopyCommand.FinalyClipboardCopy
GrapeCity.Spreadsheet.Drawing Namespace
Overview
Classes
ShapeAdjustHandle
ShapeConnectionSite
ShapeEventArgs
ShapeProperties
Enumerations
AlignCommand
AutoShapeType
BuiltInIcons
CalloutAngleType
CalloutDropType
CalloutType
ConnectorDirection
ConnectorType
CopyPictureFormat
EditingType
FillType
FormControl
GeometryFillMode
GradientColorType
GradientStyle
GraphicFrameLocks
GroupShapeLocks
HorizontalAnchor
LightRigDirection
LightRigType
Moving
PathFormat
PictureAppearance
PictureColorType
PictureCompress
PictureEffectType
Placement
PresetGradientType
PresetTextEffect
PresetTextEffectShape
QueryShapeType
ReflectionType
ResizeAnchor
ScaleFrom
SegmentType
SelectionMode
ShadowStyle
ShadowType
ShapeAdjustHandleType
ShapeChangeType
ShapeEditingData.ShapeEditingType
ShapeStyle
ShapeType
Sizing
SoftEdgeType
TextEffectAlignment
TextOrientation
TextureType
VerticalAnchor
ZOrderCommand
Structures
AnchorPoint
HitTestInfo
Point3D
Interfaces
ICalloutFormat
ICamera
IColorFormat
IConnectorFormat
IControlFormat
IDrawingObject
IEffectParameter
IFillFormat
IFreeFormBuilder
IGeometry
IGlowFormat
IGradientStop
IGradientStops
IGraphicObjects
IGroupShape
IGroupShapes
ILineFormat
IPicture
IPictureEffect
IPictureEffects
IPictureFormat
IPictures
IReflectionFormat
IShadowFormat
IShape
IShapeAdjustHandles
IShapeAppearance
IShapeBase
IShapeConnectionSites
IShapeNode
IShapeNodes
IShapeRange
IShapes
ISoftEdgeFormat
ITextEffectFormat
ITextFont
ITextFrame
ITextRange
IThreeDFormat
GrapeCity.Spreadsheet.IO Namespace
Overview
Enumerations
FileFormat
GrapeCity.Spreadsheet.IO.OpenXml Namespace
Overview
Classes
ExportContext
ImportContext
OpenXmlHelper
Enumerations
ExportOptions
ImportOptions
Reason
Structures
Extension
OpenResult
Interfaces
ICellExporter
GrapeCity.Spreadsheet.IO.Pdf Namespace
Overview
Classes
PdfExportContext
Enumerations
PdfAConformanceLevel
GrapeCity.Spreadsheet.Localization Namespace
Overview
Classes
LanguagePackage
Enumerations
LanguagePackageEditingBehaviors
GrapeCity.Spreadsheet.Printing Namespace
Overview
Classes
Document
DocumentPage
DocumentParagraph
PrintingContext
Enumerations
CellComments
HeaderFooterParser.Codes
HeaderFooterParser.Section
Order
PageOrientation
PaperSize
PrintErrors
Structures
TextLine
Interfaces
IMergeCellSupport
IPageSetup
GrapeCity.Spreadsheet.Slicers Namespace
Overview
Enumerations
SlicerCrossFilterType
SlicerItemState
SlicerSort
Interfaces
ISlicer
ISlicerCache
ISlicerCaches
ISlicerData
ISlicerItem
ISlicerItems
ISlicers
GrapeCity.Spreadsheet.UI Namespace
Overview
Classes
UIManager
Enumerations
IntelliSenseItems.ItemType
ParseInputMode
StateType
Structures
IntelliSenseItems.Entry
RichTextLayout.HitTestInfo
GrapeCity.Spreadsheet.WinForms.Ribbon Assembly
GrapeCity.Win.PluginInputMan Assembly
Import and Export Reference
Excel-Formatted Files Import
Workbook Settings Imported
Chart Settings Imported
Sheet Settings Imported
Row and Column Settings Imported
Cell Settings Imported
Border Styles Substituted
Formula Settings Imported
Print Settings Imported
Excel-Formatted Files Export
Component and Sheet Settings Exported
Chart Settings Exported
Row and Column Settings Exported
Cell Settings Exported
Cell-Type Settings Exported
Print Settings Exported
Version Comparison Reference
Object Import from Spread COM
Borders Imported from Spread COM Files
Cell Types Imported from Spread COM Files
Formulas Imported from Spread COM Files
Other Settings Imported from Spread COM Files
Differences in Behavior and Operation
General Differences in Product Design
Inherent Differences Based on Platform
Mapping Actions of COM in .NET
Spread COM File Member Equivalents
Spread COM Property Equivalents in .NET
Spread COM Method Equivalents in .NET
Spread COM Event Equivalents in .NET
TextToColumns Method (IRange)
In This Topic
Overload List
See Also
Parses a column of cells that contain text into several columns.
Overload List
Overload
Description
TextToColumns(Int32,Int32,TextParsingType,TextQualifier,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Char,Tuple<Int32,ColumnDataType>[],Char,Char,Boolean)
TextToColumns(IRange,TextParsingType,TextQualifier,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Char,Tuple<Int32,ColumnDataType>[],Char,Char,Boolean)
TextToColumns(String,TextParsingType,TextQualifier,Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,Char,Tuple<Int32,ColumnDataType>[],Char,Char,Boolean)
Parses a column of cells that contain text into several columns.
See Also
Reference
IRange Interface
IRange Members
