Back to Devexpress

CellCollection Properties

officefileapi-devexpress-dot-spreadsheet-dot-cellcollection-dot-underscore-properties.md

latest12.7 KB
Original Source

CellCollection Properties

A collection of all cells in a worksheet.

NameDescription
AlignmentProvides access to cell alignment. Inherited from Formatting.
AreasProvides access to the ranges that comprise a complex (union) range. Inherited from CellRange.
ArrayFormulaGets or sets the array formula associated with the cell or cell range. Inherited from CellRange.
ArrayFormulaInvariantGets or sets the array formula in the invariant culture. Inherited from CellRange.
BordersProvides access to cell borders. Inherited from Formatting.
BottomRowIndexGets the index of the row that includes the bottom edge of the cell range. Inherited from CellRange.
ColumnCountGets the number of columns in the cell range. Inherited from CellRange.
ColumnWidthGets or sets the width of columns that contain this cell range. Inherited from CellRange.
ColumnWidthInCharactersGets or sets the width of columns that contain the cell range in characters of the default font specified by the built-in Normal style. Inherited from CellRange.
CurrentRegionGets a range with non-empty cells surrounded by empty rows and columns. Inherited from CellRange.
DependentsGets a list of ranges (cells) whose formulas refer to the current range or cell, directly or indirectly (at any level). Inherited from CellRange.
DirectDependentsGets a list of ranges (cells) whose formulas use the current range or cell. Inherited from CellRange.
DirectPrecedentsGets a list of ranges (cells) that are directly referred to in the formulas in the current cell or range. Inherited from CellRange.
DynamicArrayFormulaGets or sets the dynamic array formula associated with the cell or cell range. Inherited from CellRange.
DynamicArrayFormulaInvariantGets or sets the dynamic array formula in the invariant culture. Inherited from CellRange.
ExistingCellsGets the existing cells in the current cell range. Inherited from CellRange.
FillProvides access to cell background. Inherited from Formatting.
FillColorGets or sets the cell background color. Inherited from CellRange.
FlagsProvides access to flags that control which cell format attributes are specified by the applied cell style and which ones are specified by direct cell formatting. Inherited from Formatting.
FontProvides access to the cell font. Inherited from Formatting.
FormulaGets or sets the formula contained in the cell or cell range. Inherited from CellRange.
FormulaInvariantGets or sets the range formula in the invariant culture. Inherited from CellRange.
HasArrayFormulaDetermines whether the current cell or cell range intersects a range filled with a legacy array formula. Inherited from CellRange.
HasDataChecks whether the current cell range contains data. Inherited from CellRange.
HasDynamicArrayFormulaDetermines whether the current cell or cell range intersects a range filled with a dynamic array formula. Inherited from CellRange.
HasFormulaDetermines whether all cells in the range contain a formula. Inherited from CellRange.
HasRichTextGets a value indicating whether a cell contains rich formatted text. Inherited from CellRange.
IsMergedDetermines whether the range is created by merging cells. Inherited from CellRange.
Item[Int32, Int32]Gets an individual cell by row and column offsets from the top left cell of the current range. Inherited from CellRange.
Item[Int32]Gets an individual cell by its index in the range of cells. Inherited from CellRange.
Item[String]Gets an individual cell by its reference string.
LeftColumnIndexGets the index of the column that includes the left edge of the cell range. Inherited from CellRange.
NameGets or sets the name of the cell range. Inherited from CellRange.
NumberFormatSpecifies a number format for a numeric cell value in the invariant culture. Inherited from Formatting.
NumberFormatLocalSpecifies a number format for a numeric cell value based on the current (local) culture. Inherited from Formatting.
PrecedentsGets a list of ranges (cells) that are used by a formula in the current cell or range. Inherited from CellRange.
ProtectionProvides access to options which are in effect when the worksheet is protected. Inherited from Formatting.
RightColumnIndexGets the index of the column that includes the right edge of the cell range. Inherited from CellRange.
RowCountGets the number of rows in the cell range. Inherited from CellRange.
RowHeightGets or sets the height of rows that contain this cell range. Inherited from CellRange.
StyleGets or sets the style applied to the current range of cells. Inherited from CellRange.
TopRowIndexGets the index of the row that includes the top edge of the cell range. Inherited from CellRange.
ValueGets or sets a cell value. Inherited from CellRange.
WorksheetGets the worksheet that contains the cell range. Inherited from CellRange.

See Also

CellCollection Interface

CellCollection Members

DevExpress.Spreadsheet Namespace