Version

Search Results

DataValidationRule Property

Gets or sets the data validation rule for the WorksheetCell. Syntax Exceptions Exception Description System.ArgumentException Occurs when the value specified is already applied to cells in another worksheet. System.ArgumentException Occurs when the value specified is invalid based on its rule types requirements.

Equals Method (WorksheetCell)

Determines whether the specified object is another WorksheetCell instance which refers to the same location on the same worksheet as this cell. Syntax Parameters obj The instance to check for equality. Return Value True if the cells refer to the same location on the same worksheet; False otherwise.

Formula Property (WorksheetCell)

Gets the formula which has been applied to the cell. Syntax Property Value The formula which has been applied to the cell or null if no formula has been applied. Remarks If a formula has been applied to the cell, getting the Value will return the calculated value of the formula. Note: it is slightly faster to use ...

GetBoundsInTwips() Method

Gets the bounds of the cell in twips (1/20th of a point). Syntax Return Value The bounds of the cell on its worksheet. Remarks The bounds returned by this method are only valid with the current configuration of the worksheet. If any rows or columns before the cell are resized, these bounds will no longer reflect t...

GetBoundsInTwips(PositioningOptions) Method

Gets the bounds of the cell in twips (1/20th of a point). Syntax Parameters options The options to use when getting the bounds of the cell. Return Value The bounds of the cell on its worksheet. Remarks The bounds returned by this method are only valid with the current configuration of the worksheet. If any rows or...

GetBoundsInTwips Method (WorksheetCell)

Gets the bounds of the cell in twips (1/20th of a point). Overload List

GetCellAddressString(WorksheetRow,Int32,CellReferenceMode,Boolean) Method

Gets the string representation of the address of the cell. Syntax Parameters worksheetRow The WorksheetRow of the cell.columnIndex The index of the column of the cell.cellReferenceMode The mode used to generate cell references.includeWorksheetName The value indicating whether to include the worksheet name in the c...

GetCellAddressString(WorksheetRow,Int32,CellReferenceMode,Boolean,Boolean,Boolean) Method

Gets the string representation of the address of the cell. Syntax Parameters worksheetRow The WorksheetRow of the cell.columnIndex The index of the column of the cell.cellReferenceMode The mode used to generate cell references.includeWorksheetName The value indicating whether to include the worksheet name in the c...

GetCellAddressString Method

Gets the string representation of the address of the cell. Overload List

GetHashCode Method (WorksheetCell)

Gets the hash code of the WorksheetCell. Syntax Return Value The hash code of the WorksheetCell.