Click or drag to resize

StyleArrayWrapper Class

A object contain all styles that are used by range.
Inheritance Hierarchy
System Object
Spire.Xls.Core.Spreadsheet XlsObject
Spire.Xls.Core.Spreadsheet StyleArrayWrapper

Namespace: Spire.Xls.Core.Spreadsheet
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public class StyleArrayWrapper : XlsObject, 
	IExtendedFormat, IExcelApplication, IStyle, IOptimizedUpdate, IExtendIndex

The StyleArrayWrapper type exposes the following members.

Constructors
Name Description
Public method StyleArrayWrapper
Creates object that will contain all styles that are used by range.
Top
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. Read-only Boolean.
Public property Color
Returns or sets the cell shading color.
Public property ExtendedFormatIndex
Gets format index in m_book.InnerFormats.
Public property FillBackground
Gets / sets index of XlsFill background color.
Public property FillBackgroundRGB
Gets / sets XlsFill background color.
Public property FillForeground
Gets / sets index of XlsFill foreground color.
Public property FillForegroundRGB
Gets / sets XlsFill foreground color.
Public property FillPattern
Gets / sets XlsFill pattern.
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. Read/write Boolean.
Public property HorizontalAlignment
Returns or sets the horizontal alignment for the specified object. For all objects, this can be one of the following HorizontalAlignType constants. Read/write HorizontalAlignType.
Public property IncludeAlignment
True if the style includes the AddIndent, HorizontalAlignment, VerticalAlignment, WrapText, and Orientation properties. Read/write Boolean.
Public property IncludeBorder
True if the style includes the Color, ColorIndex, LineStyle, and Weight border properties. Read/write Boolean.
Public property IncludeFont
True if the style includes the Background, Bold, Color, ColorIndex, FontStyle, Italic, Name, OutlineFont, Shadow, Size, Strikethrough, Subscript, Superscript, and Underline font properties. Read/write Boolean.
Public property IncludeNumberFormat
True if the style includes the NumberFormat property. Read/write Boolean.
Public property IncludePatterns
True if the style includes the Color, ColorIndex, InvertIfNegative, Pattern, PatternColor, and PatternColorIndex interior properties. Read / write Boolean.
Public property IncludeProtection
True if the style includes the FormulaHidden and Locked protection properties. Read / write Boolean.
Public property IndentLevel
Returns or sets the indent level for the style. Read/write.
Public property Interior
Returns Interior object that represents the interior of the specified object. Read-only.
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
Gets value indicating whether format was modified, compared to parent format.
Public property JustifyLast
For far east languages. Supported only for format. Always 0 for US.
Public property KnownColor
Returns or sets the color of the interior. The color is specified as an index value into the current color palette.
Public property Locked
True if the object is locked, False if the object can be modified when the sheet is protected. Read/write Boolean.
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. Read / write String.
Public property NumberFormatIndex
Gets / sets index of the number format.
Public property NumberFormatLocal
Returns or sets the format code for the object as a string in the language of the user. Read / write String.
Public property NumberFormatSettings
Returns object that describes number format. Read-only.
Public property Parent
Reference to Parent object. Read-only.
(Inherited from XlsObject .)
Public property PatternColor
Returns or sets the color of the interior pattern as an System.Drawing.Color value.
Public property PatternKnownColor
Returns or sets the color of the interior pattern as an index into the current color palette.
Public property ReadingOrder
Text direction, the reading order for far east versions.
Protected property ReferenceCount
Get quantity of instance references.
(Inherited from XlsObject .)
Public property Rotation
Text rotation angle: 0 Not rotated 1-90 1 to 90 degrees counterclockwise 91-180 1 to 90 degrees clockwise 255 Letters are stacked top-to-bottom, but not rotated. int.MinValue - different rotation angle for different ranges.
Public property ShrinkToFit
True if text automatically shrinks to fit in the available column width. Read/write Boolean.
Public property VerticalAlignment
Returns or sets the vertical alignment of the specified object. Read/write VerticalAlignType.
Public property WrapText
True if Microsoft Excel wraps the text in the object. Read/write Boolean.
Top
Methods
Name Description
Protected method AddReference
Increase the quantity of reference. User must use this method when new wrapper on object is created or reference on object stored.
(Inherited from XlsObject .)
Public method BeginUpdate
This method should be called before several updates to the object will take place.
Protected method CheckDisposed
Checks whether object was disposed and throws exception if it was.
(Inherited from XlsObject .)
Public method Dispose
Dispose object and free resources.
(Inherited from XlsObject .)
Public method EndUpdate
This method should be called after several updates to the object.
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object .)
Protected method Finalize
Destructor. Call dispose method of current object.
(Inherited from XlsObject .)
Protected method FindParent(Type)
This method is used to find parent with specific type.
(Inherited from XlsObject .)
Protected method FindParent( Type )
Find parent of object.
(Inherited from XlsObject .)
Protected method FindParent(Type, Boolean)
This method is used to find parent with specific type.
(Inherited from XlsObject .)
Protected method FindParents
Finds parent objects.
(Inherited from XlsObject .)
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 .)
Protected method OnDispose
Method which can be overriden by users to take any specific actions when object is disposed.
(Inherited from XlsObject .)
Protected method ReleaseReference
Decrease quantity of Reference. User must call this method when freeing resources.
(Inherited from XlsObject .)
Protected method SetParent
Sets parent of the object.
(Inherited from XlsObject .)
Public method SetThemeColor
Set the theme color.
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
Fields
Name Description
Protected field m_bIsDisposed
Flag which indicates if the object was disposed or not.
(Inherited from XlsObject .)
Top
See Also