AddtionalFormatWrapper module

class AddtionalFormatWrapper.AddtionalFormatWrapper

Bases: CommonWrapper, IInternalAddtionalFormat, IExtendIndex, IStyle

property BackgroundColor: Color

<summary>: Gets or Sets fill background color.

</summary>

property BackgroundKnownColor: ExcelColors

<summary>: Gets or Sets index of fill background excel color.

</summary>

BeginUpdate()

property Borders: IBorders

property BottomBorderColor: OColor

<summary>: Gets or sets bottom border color.

</summary>

property BottomBorderLineStyle: LineStyleType

<summary>: Gets or sets line style of the bottom border.

</summary>

property BuiltIn: bool

Clone(parent: SpireObject) → SpireObject

property Color: Color

<summary>: Gets or sets the cell shading color.

</summary>

property DiagonalBorderColor: OColor

<summary>: Gets or sets diagonal border color.

</summary>

property DiagonalDownBorderLineStyle: LineStyleType

<summary>: Gets or sets line style of the diagonal border.

</summary>

property DiagonalDownVisible: bool

<summary>: Indicates whether diagonal down line is visible.

</summary>

property DiagonalUpBorderLineStyle: LineStyleType

<summary>: Gets or sets line style of the diagonal border.

</summary>

property DiagonalUpVisible: bool

<summary>: Indicates whether DiagonalUp line is visible.

</summary>

EndUpdate()

property ExtendedFormatIndex: int

<summary>: Gets extended format index.

</summary>

property FillPattern: ExcelPatternType

<summary>: Gets or Sets fill pattern type.

</summary>

property Font: IFont

property ForegroundColor: Color

<summary>: Gets or Sets fill foreground color.

</summary>

property ForegroundKnownColor: ExcelColors

<summary>: Gets or Sets fill foreground excel color.

</summary>

property FormulaHidden: bool

<summary>: True if the formula will be hidden when the worksheet is protected.

</summary>

property HorizontalAlignment: HorizontalAlignType

<summary>: Returns or sets the horizontal alignment for the specified object.

</summary>

property IncludeAlignment: bool

<summary>

True if the style includes the AddIndent, HorizontalAlignment,: VerticalAlignment, WrapText, and Orientation properties.

</summary>

property IncludeBorder: bool

<summary>: True if the style includes the Color, KnownColor, LineStyle, and Weight border properties

</summary>

property IncludeFont: bool

<summary>: True if the style includes the Background, Bold, Color, KnownColor, FontStyle, Italic, Name, OutlineFont, Shadow, Size, Strikethrough, Subscript, Superscript, and Underline font properties.

</summary>

property IncludeNumberFormat: bool

<summary>: True if the style includes the NumberFormat property.

</summary>

property IncludePatterns: bool

<summary>

True if the style includes the Color, KnownColor,: InvertIfNegative, Pattern, PatternColor, and PatternKnownColor interior properties.

</summary>

property IncludeProtection: bool

<summary>

True if the style includes the FormulaHidden and Locked protection: properties.

</summary>

property IndentLevel: int

<summary>: Returns or sets the indent level for the style.

</summary>

property Interior: IInterior

property IsFirstSymbolApostrophe: bool

<summary>: If true then first symbol in cell is apostrophe.

</summary>

property IsInitialized: bool

property IsModified: bool

property JustifyLast: bool

<summary>: Represents justify text alignment

</summary>

property KnownColor: ExcelColors

<summary>: Gets or sets the cell shading excel color.

</summary>

property LeftBorderColor: OColor

<summary>: Gets or sets left border color.

</summary>

property LeftBorderLineStyle: LineStyleType

<summary>: Gets or sets line style of the left border.

</summary>

property Locked: bool

<summary>: True if the object is locked; False if the object can be modified when the sheet is protected.

</summary>

property Name: str

property NumberFormat: str

<summary>: Returns or sets the format code for the object.

</summary>

property NumberFormatIndex: int

<summary>: Gets or Sets format index.

</summary>

property NumberFormatLocal: str

<summary>

Returns or sets the format code for the object as a string in the: language of the user.

</summary>

property Parent: SpireObject

property PatternColor: Color

<summary>: Returns or sets the color of the interior pattern.

</summary>

property PatternKnownColor: ExcelColors

<summary>: Returns or sets the excel color of the interior.

</summary>

property ReadingOrder: ReadingOrderType

<summary>: Returns or sets the reading order for the specified object.

</summary>

property RightBorderColor: OColor

<summary>: Gets or sets right border color.

</summary>

property RightBorderLineStyle: LineStyleType

<summary>: Gets or sets line style of the right border.

</summary>

property Rotation: int

<summary>: The text orientation. Can be an integer value from 1 to 180 degrees

</summary>

SetBackgroundThemeColor(type: ThemeColorType, tint: int)

SetThemeColor(type: ThemeColorType, tint: float)

property ShrinkToFit: bool

<summary>: True if text automatically shrinks to fit in the available column width.

</summary>

property TopBorderColor: OColor

<summary>: Gets or sets top border color.

</summary>

property TopBorderLineStyle: LineStyleType

<summary>: Gets or sets line style of the top border.

</summary>

property VerticalAlignment: VerticalAlignType

<summary>: Returns or sets the vertical alignment of the specified object.

</summary>

property Workbook: XlsWorkbook

property WrapText: bool

<summary>: True if Microsoft Excel wraps the text in the object.

</summary>