Click or drag to resize

CellStyleObject Properties

The CellStyleObject type exposes the following members.

Properties
Name Description
Public property Borders
Returns aBorders collection that represents the borders of a style or a range of cells (including a range defined as part of a conditional format).
Public property BuiltIn
True if the style is a built-in style.
Public property Color
Gets or sets the cell shading color.
Public property FillPattern
Gets or Sets fill pattern type.
Public property Font
Returns a Font object that represents the font of the specified object. Read-only.
Public property FormulaHidden
True if the formula will be hidden when the worksheet is protected.
Public property HorizontalAlignment
Returns or sets the horizontal alignment for the specified object.
Public property IncludeAlignment
True if the style includes the AddIndent, HorizontalAlignment, VerticalAlignment, WrapText, and Orientation properties.
Public property IncludeBorder
True if the style includes the Color, KnownColor, LineStyle, and Weight border properties
Public property IncludeFont
True if the style includes the Background, Bold, Color, KnownColor, FontStyle, Italic, Name, OutlineFont, Shadow, Size, Strikethrough, Subscript, Superscript, and Underline font properties.
Public property IncludeNumberFormat
True if the style includes the NumberFormat property.
Public property IncludePatterns
True if the style includes the Color, KnownColor, InvertIfNegative, Pattern, PatternColor, and PatternKnownColor interior properties.
Public property IncludeProtection
True if the style includes the FormulaHidden and Locked protection properties.
Public property IndentLevel
Returns or sets the indent level for the style.
Public property Interior
Get interior object for this extended format.
Public property IsFirstSymbolApostrophe
If true then first symbol in cell is apostrophe.
Public property IsInitialized
Indicates whether style is initialized (differs from Normal style). Read-only.
Public property IsModified
Returns the style has been modified
Public property JustifyLast
Represents justify text alignment
Public property KnownColor
Gets or sets the cell shading excel color.
Public property Locked
True if the object is locked; False if the object can be modified when the sheet is protected.
Public property Name
Returns or sets the name of the object. Read-only String.
Public property NumberFormat
Returns or sets the format code for the object.
Public property NumberFormatIndex
Gets or Sets format index.
Public property NumberFormatLocal
Returns or sets the format code for the object as a string in the language of the user.
Public property NumberFormatSettings
Returns object that describes number format. Read-only.
Public property Parent
Get the parent.
Public property PatternColor
Returns or sets the color of the interior pattern.
Public property PatternKnownColor
Returns or sets the excel color of the interior.
Public property ReadingOrder
Returns or sets the reading order for the specified object.
Public property Rotation
The text orientation. Can be an integer value from 1 to 180 degrees
Public property ShrinkToFit
True if text automatically shrinks to fit in the available column width.
Public property VerticalAlignment
Returns or sets the vertical alignment of the specified object.
Public property WrapText
True if Microsoft Excel wraps the text in the object.
Top
See Also