Spread for WPF Overview
Key Features
Getting Started
Quick Start
Designer
Features
- Workbook
- Worksheet
- Column
- Row
- Headers
- Cells
- Cell Types
  - Text Cell
  - Number Cell
  - Mask Cell
  - Date-Time Cell
  - Button Cell
  - Checkbox Cell
  - Combo Box Cell
  - Data Template Cell
  - Image Cell
- Data Binding
- Data Validation
- Conditional Formatting
- Drag and Drop
- Copy and Paste
- Group
- Zoom
- Undo/Redo
- Search Data
- Scroll
- Sort
- Filter
- Table
- Charts
- Formulas and Functions
- File Operations
- Print
Formula Reference
Assembly Reference

Cell Types

Cell types define the type of information that appears in a cell, how that information is displayed, and how the user can interact with it.

Spread WPF processes the values entered in the cell by the cell type. This helps determine the cell value and what is displayed inside it. The Value property of the IRange interface represents the cell value. The Text property of the IRange interface represents the content displayed in the cell.

The following table lists the some of the cell types supported, and how the cell type works with the data, whether formatted (Text) or unformatted (Value).

Cell Type	Sample Input	Formatted Data	Unformatted Data
Text Cell	Any text	String of that text	String of that text
Number Cell	"10000.00"	"10000.00"	10000.00
Mask Cell	"123-45-6789"	"123-45-6789"	"123456789"
Date-Time Cell	"10/29/2002"	"10/29/2002"	Tuesday, October 29, 2002 12:00:00 AM
Image Cell	Picture as data	N/A	N/A
Button Cell	No user input	If a value has been set in the cell through coding or data binding, considers that value.	The value of the Content property of the button cell converted to a string.
Checkbox Cell	True (checked) False (unchecked) Indeterminate (gray)	"1" or "0"	1 or 0
Combo Box Cell	User can select one or more items from the available list of items	If the item is bound to a data source, the value of the field is specified by the SelectedValuePath property of the combo box cell. If the item is unbound, the string is displayed in the item. If the ValueType property is set, the corresponding setting is configured.	The value of the field specified by the ContentPath property of the combo box cell, if the item is bound to a data source. The string is displayed in the field if the field is unbound.

You can refer to the specific cell type to learn how to use and configure various cell types for your worksheets. Each cell type is described with simple examples to help you implement them effectively.