Cell Members
In This Article
#Properties
Name | Description |
---|---|
Alignment | Provides access to cell alignment. Inherited from Formatting. |
Areas |
Provides access to the ranges that comprise a complex (union) range.
Inherited from Cell |
Array |
Gets or sets the array formula associated with the cell or cell range.
Inherited from Cell |
Array |
Gets or sets the array formula in the invariant culture.
Inherited from Cell |
Borders | Provides access to cell borders. Inherited from Formatting. |
Bottom |
Gets the index of the row that includes the bottom edge of the cell range.
Inherited from Cell |
Column |
Gets the number of columns in the cell range.
Inherited from Cell |
Column |
Gets the index of the column that contains the current cell. |
Column |
Gets or sets the width of columns that contain this cell range.
Inherited from Cell |
Column |
Gets 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 Cell |
Current |
Gets a range with non-empty cells surrounded by empty rows and columns.
Inherited from Cell |
Dependents |
Gets a list of ranges (cells) whose formulas refer to the current range or cell, directly or indirectly (at any level).
Inherited from Cell |
Direct |
Gets a list of ranges (cells) whose formulas use the current range or cell.
Inherited from Cell |
Direct |
Gets a list of ranges (cells) that are directly referred to in the formulas in the current cell or range.
Inherited from Cell |
Display |
Returns a cell’s displayed value. |
Dynamic |
Gets or sets the dynamic array formula associated with the cell or cell range.
Inherited from Cell |
Dynamic |
Gets or sets the dynamic array formula in the invariant culture.
Inherited from Cell |
Existing |
Gets the existing cells in the current cell range.
Inherited from Cell |
Fill | Provides access to cell background. Inherited from Formatting. |
Fill |
Gets or sets the cell background color.
Inherited from Cell |
Flags | Provides 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. |
Font | Provides access to the cell font. Inherited from Formatting. |
Formula |
Gets or sets the formula contained in the cell or cell range.
Inherited from Cell |
Formula |
Gets or sets the range formula in the invariant culture.
Inherited from Cell |
Has |
Determines whether the current cell or cell range intersects a range filled with a legacy array formula.
Inherited from Cell |
Has |
Checks whether the current cell range contains data.
Inherited from Cell |
Has |
Determines whether the current cell or cell range intersects a range filled with a dynamic array formula.
Inherited from Cell |
Has |
Determines whether all cells in the range contain a formula.
Inherited from Cell |
Has |
Indicates whether or not the cell value is prefixed with a single quote. |
Has |
Gets a value indicating whether a cell contains rich formatted text.
Inherited from Cell |
Image |
Obtains information about an image embedded in the cell. |
Is |
Indicates whether a numeric value contained in the cell is displayed as a date and time value. |
Is |
Determines whether the range is created by merging cells.
Inherited from Cell |
Is |
Indicates whether the current cell is the top left cell in the array formula range. |
Is |
Indicates 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 Cell |
Item[Int32] |
Gets an individual cell by its index in the range of cells.
Inherited from Cell |
Left |
Gets the index of the column that includes the left edge of the cell range.
Inherited from Cell |
Name |
Gets or sets the name of the cell range.
Inherited from Cell |
Number |
Specifies a number format for a numeric cell value in the invariant culture. Inherited from Formatting. |
Number |
Specifies a number format for a numeric cell value based on the current (local) culture. Inherited from Formatting. |
Parsed |
Gets or sets the expression tree from which the formula entered in the cell is built. |
Precedents |
Gets a list of ranges (cells) that are used by a formula in the current cell or range.
Inherited from Cell |
Protection | Provides access to options which are in effect when the worksheet is protected. Inherited from Formatting. |
Right |
Gets the index of the column that includes the right edge of the cell range.
Inherited from Cell |
Row |
Gets the number of rows in the cell range.
Inherited from Cell |
Row |
Gets or sets the height of rows that contain this cell range.
Inherited from Cell |
Row |
Gets the index of the row that contains the current cell. |
Style |
Gets or sets the style applied to the current range of cells.
Inherited from Cell |
Tag | Gets or sets custom data associated with the cell. |
Top |
Gets the index of the row that includes the top edge of the cell range.
Inherited from Cell |
Value |
Gets or sets a cell value.
Inherited from Cell |
Worksheet |
Gets the worksheet that contains the cell range.
Inherited from Cell |
#Methods
Name | Description |
---|---|
Begin |
Locks the Formatting object. Prevents visual updates until the End method calls.
Inherited from Formatting. |
Begin |
Starts modifying the cell range formatting.
Inherited from Cell |
Calculate() |
Forces recalculation of the current cell range.
Inherited from Cell |
Contains |
Determines whether the current cell range contains the specified range.
Inherited from Cell |
Copy |
Copies the source range of cells and pastes the specified part of the copied data into the current cell range.
Inherited from Cell |
Copy |
Copies the source range of cells and pastes the specified part of the copied data into the current cell range.
Inherited from Cell |
Copy |
Copies the specified range of cells into the current range.
Inherited from Cell |
End |
Unlocks the Formatting object after you call Begin . It also causes an immediate visual update.
Inherited from Formatting. |
End |
Finalizes the modification of the cell range formatting after calling the Cell |
Equals |
Determines whether or not the specified object is equal to the current Formatting instance. Inherited from Formatting. |
Exclude |
Excludes the specified cell or cell range from the current range.
Inherited from Cell |
Get |
Gets the entire range filled with an array formula, if the cell belongs to that range. |
Get |
Creates the data source from the current cell range.
Inherited from Cell |
Get |
Creates the data source from the current cell range using the specified options.
Inherited from Cell |
Get |
Returns a defined name associated with the current range.
Inherited from Cell |
Get |
Returns a defined name declared in the specified scope and associated with the current cell range.
Inherited from Cell |
Get |
Gets the entire range filled with a dynamic array formula, if the cell belongs to that range. |
Get |
Returns an enumerator that iterates through the collection.
Inherited from IEnumerable |
Get |
Gets cell content as a string in HTML format. |
Get |
Gets cell content as a string in HTML format. Allows you to specify export options. |
Get |
Returns merged ranges intersecting the current cell range.
Inherited from Cell |
Get |
Returns the cell range that covers the current range and does not contain the intersecting ranges.
Inherited from Cell |
Get |
Returns the copy of the source range with its reference replaced by the absolute reference.
Inherited from Cell |
Get |
Returns the copy of the source range with its reference replaced by the relative reference.
Inherited from Cell |
Get |
Gets the relative cell or cell range reference in the A1 reference style.
Inherited from Cell |
Get |
Gets the cell or cell range reference in the A1 reference style.
Inherited from Cell |
Get |
Gets the relative cell or cell range reference in the R1C1 reference style.
Inherited from Cell |
Get |
Gets the cell or cell range reference in the R1C1 reference style.
Inherited from Cell |
Get |
Gets the rich text string contained in a cell.
Inherited from Cell |
Get |
Gets cell content as a string in RTF format. |
Get |
Gets cell content as a string in RTF format. Allows you to specify export options. |
Intersect |
Returns the cell range that is the intersection of the current and specified ranges.
Inherited from Cell |
Is |
Determines whether the current range intersects with the specified range.
Inherited from Cell |
Move |
Moves a range to a specified location.
Inherited from Cell |
Offset |
Returns a cell range that is a given number of rows and columns from the current range.
Inherited from Cell |
Resize |
Resizes the current cell range.
Inherited from Cell |
Search |
Performs a search in the cell range using specified options.
Inherited from Cell |
Search |
Performs a search in the cell range using the default parameters.
Inherited from Cell |
Set |
Sets all inside borders of the cell range.
Inherited from Cell |
Set |
Assigns the rich formatted text to a cell.
Inherited from Cell |
Set |
Converts the specified object to the cell value.
Inherited from Cell |
Set |
Parses the supplied string and creates a cell value to assign it to the cells in the current range.
Inherited from Cell |
Set |
Parses the supplied string and creates a cell value to assign it to the cells in the current range.
Inherited from Cell |
Union |
Creates a complex range that is the union of multiple ranges.
Inherited from Cell |
See Also