Version

Search Results

DiagonalBorderStyle Property

Gets or sets the diagonal border style. Syntax Property Value The diagonal 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 Di...

Fill Property (IWorksheetCellFormat)

Gets or sets the fill of the cell. Syntax Property Value The fill of the cell.

Font Property

Gets or sets the default font formatting. Syntax Property Value The default font formatting. Remarks This font formatting is just the default font used in the cell. This can be overridden by strings on a character by character basis by using the FormattedString class.

FormatOptions Property

Gets or sets the groups of properties provided by the format. Syntax Remarks For style formats, this value indicates which properties should be used in the format when applying the style to a cell. All other groups of properties will return a default value. For cell and differential formats, this value indicates w...

FormatString Property

Gets or sets the number format string. Syntax Property Value The number format string. Exceptions Exception Description System.ArgumentException The assigned value is an invalid format string and Workbook.ValidateFormatStrings is True. Remarks For more information on excel format strings, consult Microsoft Excel h...

Indent Property

Gets or sets the indent in units of average character widths. Syntax Property Value The indent in units of average character widths or -1 to use the default indent. Exceptions Exception Description System.ArgumentOutOfRangeException The assigned value is not -1 and is outside the valid indent level range of 0 and ...

LeftBorderColorInfo Property

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

LeftBorderStyle Property

Gets or sets the left border style. Syntax Property Value The left 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 LeftBorder...

Locked Property

Gets or sets the valid which indicates whether the cell is locked in protected mode. Syntax Property Value The valid which indicates whether the cell is locked in protected mode. Remarks The Locked valid is used in Excel file only if the associated Worksheet or Workbook is protected. Otherwise the value is ignored...

RightBorderColorInfo Property

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