Click or drag to resize

IExtendedFormat Interface

Represents an extended format interface for Excel applications, inheriting from IExcelApplication.

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public interface IExtendedFormat : IExcelApplication

The IExtendedFormat type exposes the following members.

Properties
Name Description
Public property Borders
Returns borders object for this extended format.
Public property Color
Returns or sets the cell shading color.
Public property FillPattern
Gets / Sets XlsFill pattern.
Public property Font
Returns font object for this extended format.
Public property FormulaHidden
True if formula is hidden.
Public property HorizontalAlignment
Horizontal alignment.
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
Indent level.
Public property IsFirstSymbolApostrophe
If true then first symbol in cell is apostrophe.
Public property IsModified
Gets a value indicating whether the object has been modified.
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 cell is locked.
Public property NumberFormat
Returns or sets the format code for the object. Read / write String.
Public property NumberFormatIndex
Gets / Sets format index.
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
Gets the parent object of the current instance.
(Inherited from IExcelApplication .)
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.
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.
Public property ShrinkToFit
True - shrink content to fit into cell.
Public property VerticalAlignment
Vertical alignment.
Public property WrapText
True - Text is wrapped at right border.
Top
Methods
Name Description
Public method GetThemeColor
Get the theme color.
Public method SetThemeColor
Set the theme color.
Top
See Also