Back to Devexpress

Cell Properties

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

latest14.3 KB
Original Source

Cell Properties

A single cell 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.
ColumnIndexGets the index of the column that contains the current cell.
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.
DisplayTextReturns a cell’s displayed value.
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.
HasQuotePrefixIndicates whether or not the cell value is prefixed with a single quote.
HasRichTextGets a value indicating whether a cell contains rich formatted text. Inherited from CellRange.
ImageInfoObtains information about an image embedded in the cell.
IsDisplayedAsDateTimeIndicates whether a numeric value contained in the cell is displayed as a date and time value.
IsMergedDetermines whether the range is created by merging cells. Inherited from CellRange.
IsTopLeftCellInArrayFormulaRangeIndicates whether the current cell is the top left cell in the array formula range.
IsTopLeftCellInDynamicArrayFormulaRangeIndicates whether the current cell is the top left cell in the dynamic array formula range.
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.
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.
ParsedExpressionGets or sets the expression tree from which the formula entered in the cell is built.
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.
RowIndexGets the index of the row that contains the current cell.
StyleGets or sets the style applied to the current range of cells. Inherited from CellRange.
TagGets or sets custom data associated with the cell.
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

Cell Interface

Cell Members

DevExpress.Spreadsheet Namespace