Telerik.Windows.Documents.Spreadsheet.Model

Stores a boolean (true or false) value for a cell, rendering as uppercase text in the cell.

Defines the style, color, and thickness of a cell border edge.

Defines line styles for cell borders, including solid, dashed, dotted, and double lines with various thicknesses.

Defines the border styling for all edges of a cell or cell range, including outline, inside, and diagonal borders.

Identifies a specific cell by its row and column indices within a worksheet.

Abstract base for cell index and position classes, providing row and column coordinates with comparison and equality operations.

Defines the merge state of a cell, indicating whether it is standalone, the top-left anchor, or a covered cell in a merged range.

Defines the text orientation of a cell, controlling whether content flows horizontally or vertically.

Defines a rectangular selection of cells within a worksheet, bounded by row and column indices, supporting operations like offset, intersection, and containment checks.

A collection of cell ranges that automatically updates stored ranges when rows or columns are inserted or removed from the worksheet.

A dictionary-backed collection mapping cell ranges to elements, automatically updating ranges when worksheet structure changes.

Abstract base for collections that track and update cell ranges when worksheet structure changes due to insert or remove operations.

A list-backed collection of cell ranges that preserves insertion order and updates ranges when worksheet structure changes.

Event arguments describing a cell range insert or remove operation, including the affected range and operation type.

Represents a reference to a single cell with absolute or relative row and column addressing, used in formulas for cell-based calculations.

Represents a rectangular range of cell references with absolute or relative addressing, used in formulas to reference contiguous cell areas.

Provides operations on a selection of one or more cell ranges, enabling batch setting of values, formatting, formulas, and data validation.

Abstract base for strongly-typed cell value implementations, managing value storage, formatting, and string conversion.

Factory for creating cell value instances from various input types; use to convert strings, numbers, dates, and formulas into appropriate ICellValue implementations.

Number format pattern for displaying cell values; applies format strings to control how numbers, dates, times, and text appear in cells.

Cell value types indicating the content category (empty, number, text, formula, boolean, rich text, or error).

Class
Cells

Provides access to the cells in a worksheet, managing their values, formatting, data validation, and merged ranges with sparse storage.

Collection of chart shapes in a worksheet, providing methods to add and manage data-driven charts.

Specifies what content to clear from cells: all data, only formatting, only values, or only hyperlinks.

Categorizes theme shade steps used to compute tint/shade variations of a base color.

Defines a contiguous range of columns by start and end indices within a worksheet.

A selection of one or more worksheet columns for applying properties, formatting, and operations in batch.

Defines a column width value in worksheet units, indicating whether it is user-defined or auto-calculated.

Event arguments providing the column index range affected by a width change operation.

Class
Columns

Manages all columns in a worksheet, providing access to column properties, widths, and visibility.

Comparison operators used in data validation, conditional formatting, and filtering operations.

Base class for reporting the outcome of copy-paste operations in worksheets.

Specifies the unit of time for date-based operations and calculations.

Represents a named formula or range reference that can be scoped to a workbook or worksheet, providing reusable expressions for cells.

Cell value for cells with no content; use to represent blank or uninitialized cells.

Cell value for formula errors and invalid operations; stores error indicators like #DIV/0!, #REF!, #VALUE!, #N/A, #NAME?, #NUM!, and #NULL!.

Base collection for managing typed subsets of worksheet shapes, enabling filtered access and modification to shapes by type.

Provides a type-filtered view over a workbook's sheet collection, exposing only sheets of a specific type.

Enum
FindBy

Direction for traversing cells during find and replace operations within a worksheet.

Cell content type to search within during find and replace operations.

Configuration for find operations specifying search criteria, scope, direction, and matching rules.

Result of a find operation containing the located cell position and its raw and formatted values.

Search scope specifying whether to search within a single sheet or across the entire workbook.

Identifies language groups used to select the appropriate theme font.

Immutable descriptor for font characteristics including family, size, weight, style, color, and underline used in cell formatting.

Cell value for formula expressions that calculate dynamically; holds the expression tree and recalculates when dependencies change.

Two-color gradient fill for cell backgrounds, blending between Color1 and Color2 along the specified direction.

Defines gradient directions and patterns for two-color fills in cells.

Configures summary row and column placement for row/column outline groups in a worksheet.

Manages hyperlinks attached to cell ranges in a worksheet, tracking links through insert/remove operations.

Immutable descriptor for hyperlink targets, including URL, email, and in-document addresses with optional screen tips.

Defines categories of hyperlink targets (web/file URLs, email addresses, or in-document locations).

Interface
ICellValue

Contract for all cell value implementations providing access to content, type, and formatted display.

Interface
IFill

Marker interface for cell background fill types (PatternFill, GradientFill, or no fill).

Defines font styling properties for cell text including family, size, weight, style, color, and underline.

Interface
ISheet

Defines core properties and layout operations for worksheet and chart sheet types within a workbook.

Interface
ISheetEditor

Defines editor operations and change notifications for switching between sheets in a workbook.

Defines view-specific state for a sheet including tab color and invalidation status.

Defines core properties for a named formula or range reference within a spreadsheet.

Filtered collection of floating images within a worksheet, providing typed access and creation methods for image shapes.

Defines the direction that existing cells shift when new cells are inserted.

Event arguments providing the cell range affected by a merged cell change operation.

Manages a collection of defined names within a workbook or worksheet scope, providing add, remove, and lookup operations.

Collection of notes attached to worksheet cells, supporting visibility control and conversion to threaded comments.

Cell value for numeric data stored as double-precision floating-point; use for numbers, dates, times, and percentages.

Class
Pane

Defines a viewport pane configuration for worksheets with frozen or split rows and columns.

Specifies whether worksheet panes are frozen in place or allow independent scrolling.

Thrown when a string value cannot be parsed as a valid cell value due to format or type mismatch.

Configures what content to paste into a range, controlling which cell properties are copied.

Provides the outcome of a paste operation, indicating success or failure with an optional error message.

Specifies which cell content elements to paste, such as values, formulas, or formatting.

Defines a cell background fill using pattern types, foreground colors, and background colors.

Specifies fill pattern styles for cell backgrounds, such as solid, striped, or crosshatch designs.

Horizontal text alignment options for cell content within a worksheet.

Vertical text alignment options for cell content within a worksheet.

Property value queried from a cell range, indicating whether the value is uniform or mixed (indeterminate) across the range.

Defines the scope of a range insert or remove operation: entire rows, entire columns, or partial cells within rows or columns.

Specifies how cells shift to fill the space after removing cells from a range.

Configures text replacement operations in worksheets, combining find criteria with replacement text.

Base class for ranges of rows or columns, tracking start and end indices for selection and operations.

Encapsulates a reference to a row or column with support for absolute and relative positioning in formulas.

Abstract base for row and column selections, providing property management, outlining, and range-based operations on entire rows or columns.

Encapsulates a row height value with custom or auto-fit sizing, measured in device-independent pixels.

Provides data for the RowHeightChanged event, indicating which rows had their heights modified.

Defines a continuous range of worksheet rows by start and end indices.

Manages a selection of entire rows, providing access to row-specific properties like height, hidden state, and outline level for formatting and manipulation.

Class
Rows

Manages the collection of rows in a worksheet, providing access to row properties, heights, and operations like insert and remove.

Abstract base class for row and column collections, providing shared insertion, removal, and property management functionality.

Abstract base for range-based selections in worksheets, providing property access and modification methods for formatting, borders, and values across one or more cell ranges.

Captures the current selection state in a worksheet, including selected cell ranges, active cell, viewport pane, and selected shapes.

Class
Sheet

Abstract base for all sheet types in a workbook, providing naming, visibility, protection, and layout coordination for derived sheet implementations (Worksheet, future chart sheets).

Ordered collection of sheets in a workbook, managing sheet creation, insertion, removal, visibility, and active sheet tracking with validation and event notifications.

Specifies the type of modification operation performed on a workbook's sheet collection.

Provides data for the SheetCollection.Changed event, indicating which modification occurred and the affected sheet.

Specifies the type of sheet in a workbook, determining its content and layout behavior.

Base class for managing worksheet view state properties including tab color and invalidation tracking.

Specifies the display mode for a worksheet, controlling how content is rendered and laid out.

Specifies the visibility level of a sheet in the workbook, controlling user access and tab display.

Specifies the direction cells shift when inserting or removing content in a worksheet.

Struct
SizeI

Represents a two-dimensional size with integer width and height values for worksheet elements.

Provides constants defining default dimensions, limits, and styling for spreadsheet elements.

Binds a hyperlink target to a cell range, combining location with navigation information.

Defines the scope of a name collection, indicating whether names apply to a specific worksheet or the entire workbook.

Thrown when named range operations fail due to invalid names, duplicate definitions, or scope conflicts.

Cell value for plain text content without formatting; use for strings that should not be parsed as numbers or formulas.

Color value that can originate from a theme or a local override and be resolved to an actual color.

Font family that can be taken from a theme (major/minor) or set locally and resolved at runtime.

Specifies the style of underline applied to cell text.

Base class for row height and column width specifications, storing the dimension value and custom-size flag.

The top-level container for an Excel-compatible spreadsheet document, managing sheets, styles, history, and document-wide settings.

Thrown when an operation requires at least one worksheet but the workbook has none.

Thrown when an operation is attempted on a workbook that has not been properly initialized.

Two-dimensional grid organizing cells into rows and columns with filtering, sorting, formulas, and styling. Use to manage worksheet content, properties, and layout within a workbook.

Associates a cell index with its containing worksheet, linking row and column coordinates to a specific sheet.

Typed collection providing filtered access to worksheets within a workbook, excluding other sheet types.

Abstract base for worksheet entities (cells, rows, columns) that share a common property system for formatting and styling.

Encapsulates a copied range of cells and shapes for clipboard operations and paste actions with format options.

Manages the visible portion and display settings of a worksheet, including zoom, frozen panes, selection, and gridline visibility.

Not finding the help you need?
Contact Support