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