Version

Search Results

RightBorderStyle Property

Gets or sets the right border style. Syntax Property Value The right border style. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException The value assigned is not defined in the CellBorderLineStyle enumeration. Remarks If the border style is set to a non-default value and the RightBor...

Rotation Property

Gets or sets the rotation of the cell content in degrees. Syntax Property Value The rotation of the cell content in degrees. Remarks Cell text rotation, in degrees; 0 – 90 is up 0 – 90 degrees, 91 – 180 is down 1 – 90 degrees, and 255 is vertical.

SetFormatting Method

Copies all cell format properties to from the specified cell format. Syntax Parameters source The cell format from which to copy the properties.

ShrinkToFit Property

Gets or sets the value indicating whether the cell content will shrink to fit the cell. Syntax Property Value The value indicating whether the cell content will shrink to fit the cell. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException The value assigned is not defined in the Excel...

Style Property (IWorksheetCellFormat)

Gets or sets the parent WorkbookStyle of the format. Syntax Property Value A WorkbookStyle instance if this is a cell or differential format, or null if this is a style format. Exceptions Exception Description System.InvalidOperationException The value assigned is non-null and the format is a style format. System....

TopBorderColorInfo Property

Gets or sets the top border color. Syntax Property Value The top border color. Remarks If the border color is set to a non-default value and the TopBorderStyle is set to Default, it will be resolved to Thin.

TopBorderStyle Property

Gets or sets the top border style. Syntax Property Value The top border style. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException The value assigned is not defined in the CellBorderLineStyle enumeration. Remarks If the border style is set to a non-default value and the TopBorderCol...

VerticalAlignment Property (IWorksheetCellFormat)

Gets or sets the vertical alignment of the content in a cell. Syntax Property Value The vertical alignment of the content in a cell. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException The value assigned is not defined in the VerticalCellAlignment enumeration.

WrapText Property

Gets or sets the value which indicates whether text will wrap in a cell. Syntax Property Value The value which indicates whether text will wrap in a cell. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException The value assigned is not defined in the ExcelDefaultableBoolean enumeration...

LimitedValueDataValidationRule Class

Base class for all data validations rules which prevent certain values form being applied to a cell. Syntax