Back to Devexpress

Column Properties

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

latest13.8 KB
Original Source

Column Properties

A single column 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.
GroupLevelGets the grouping level of the affected column.
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.
HeadingGets the column heading.
IndexGets the zero-based index of the column within the worksheet’s ColumnCollection.
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]Provides access to an individual cell located at the intersection of the current column and the specified row.
Item[String]Provides access to an individual cell located at the intersection of the current column and the specified row.
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.
VisibleGets or sets whether the column is visible or hidden.
WidthGets or sets the column width.
WidthInCharactersGets or sets the column width in characters of the default font specified by the built-in Normal style.
WidthInPixelsGets or sets the column width in pixels.
WorksheetGets the worksheet that contains the cell range. Inherited from CellRange.

See Also

Column Interface

Column Members

DevExpress.Spreadsheet Namespace