Click or drag to resize

CellStyleObject Class

RepresentsCellStyleObject
Inheritance Hierarchy
System Object
Spire.Xls CellStyleObject
Spire.Xls CellStyle

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public class CellStyleObject : IStyle, 
	IExtendedFormat, IExcelApplication, IOptimizedUpdate

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
Methods
Name Description
Public method BeginUpdate
This method should be called before several updates to the object will take place.
Public method EndUpdate
This method should be called after several updates to the object took place.
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object .)
Protected method Finalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object .)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object .)
Public method GetThemeColor
Get the theme color.
Public method GetType
Gets the Type of the current instance.
(Inherited from Object .)
Protected method MemberwiseClone
Creates a shallow copy of the current Object .
(Inherited from Object .)
Public method SetThemeColor
Set the theme color.
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
See Also