Namespace Telerik.Windows.Documents.Spreadsheet.Model

Classes

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SelectionBase 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.

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

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).

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Worksheet 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.

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

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

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

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

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

Structs

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

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

Interfaces

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

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

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

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

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

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

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

Enums

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

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

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

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

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

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

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

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

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

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

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

FontLanguageType Identifies language groups used to select the appropriate theme font.

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

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

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

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

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

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

RadHorizontalAlignment Horizontal text alignment options for cell content within a worksheet.

RadVerticalAlignment Vertical text alignment options for cell content within a worksheet.

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

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

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

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

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

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

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

UnderlineType Specifies the style of underline applied to cell text.