Table of Contents

Class AddtionalFormatWrapper

Namespace
Spire.Xls.Core.Spreadsheet
Assembly
Spire.XLS.dll
public class AddtionalFormatWrapper : CommonWrapper, IInternalAddtionalFormat, IExtendIndex, IStyle, IExtendedFormat, IExcelApplication, IOptimizedUpdate, ICloneParent
Inheritance
AddtionalFormatWrapper
Implements
Derived
Inherited Members

Constructors

AddtionalFormatWrapper(XlsWorkbook) 

public AddtionalFormatWrapper(XlsWorkbook book)

Parameters

book XlsWorkbook

Fields

m_book 

protected XlsWorkbook m_book

Field Value

XlsWorkbook

Properties

BackgroundColor

Gets or Sets fill background color.

public Color BackgroundColor { get; set; }

Property Value

Color

BackgroundKnownColor

Gets or Sets index of fill background excel color.

public ExcelColors BackgroundKnownColor { get; set; }

Property Value

ExcelColors

Borders 

public IBorders Borders { get; }

Property Value

IBorders

BottomBorderColor

Gets or sets bottom border color.

public OColor BottomBorderColor { get; }

Property Value

OColor

BottomBorderLineStyle

Gets or sets line style of the bottom border.

public virtual LineStyleType BottomBorderLineStyle { get; set; }

Property Value

LineStyleType

BuiltIn 

public bool BuiltIn { get; }

Property Value

bool

Color

Gets or sets the cell shading color.

public Color Color { get; set; }

Property Value

Color

DiagonalBorderColor

Gets or sets diagonal border color.

public OColor DiagonalBorderColor { get; }

Property Value

OColor

DiagonalDownBorderLineStyle

Gets or sets line style of the diagonal border.

public LineStyleType DiagonalDownBorderLineStyle { get; set; }

Property Value

LineStyleType

DiagonalDownVisible

Indicates whether diagonal down line is visible.

public bool DiagonalDownVisible { get; set; }

Property Value

bool

DiagonalUpBorderLineStyle

Gets or sets line style of the diagonal border.

public LineStyleType DiagonalUpBorderLineStyle { get; set; }

Property Value

LineStyleType

DiagonalUpVisible

Indicates whether DiagonalUp line is visible.

public bool DiagonalUpVisible { get; set; }

Property Value

bool

ExtendedFormatIndex

Gets extended format index.

public int ExtendedFormatIndex { get; }

Property Value

int

FillPattern

Gets or Sets fill pattern type.

public ExcelPatternType FillPattern { get; set; }

Property Value

ExcelPatternType

Font 

public IFont Font { get; }

Property Value

IFont

ForegroundColor

Gets or Sets fill foreground color.

public Color ForegroundColor { get; set; }

Property Value

Color

ForegroundKnownColor

Gets or Sets fill foreground excel color.

public ExcelColors ForegroundKnownColor { get; set; }

Property Value

ExcelColors

FormulaHidden

True if the formula will be hidden when the worksheet is protected.

public bool FormulaHidden { get; set; }

Property Value

bool

HorizontalAlignment

Returns or sets the horizontal alignment for the specified object.

public HorizontalAlignType HorizontalAlignment { get; set; }

Property Value

HorizontalAlignType

IncludeAlignment

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

public bool IncludeAlignment { get; set; }

Property Value

bool

IncludeBorder

True if the style includes the Color, KnownColor, LineStyle, and Weight border properties

public bool IncludeBorder { get; set; }

Property Value

bool

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 bool IncludeFont { get; set; }

Property Value

bool

IncludeNumberFormat

True if the style includes the NumberFormat property.

public bool IncludeNumberFormat { get; set; }

Property Value

bool

IncludePatterns

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

public bool IncludePatterns { get; set; }

Property Value

bool

IncludeProtection

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

public bool IncludeProtection { get; set; }

Property Value

bool

IndentLevel

Returns or sets the indent level for the style.

public int IndentLevel { get; set; }

Property Value

int

Interior 

public IInterior Interior { get; }

Property Value

IInterior

IsFirstSymbolApostrophe

If true then first symbol in cell is apostrophe.

public bool IsFirstSymbolApostrophe { get; set; }

Property Value

bool

IsInitialized 

public bool IsInitialized { get; }

Property Value

bool

IsModified 

public bool IsModified { get; }

Property Value

bool

JustifyLast

Represents justify text alignment

public bool JustifyLast { get; set; }

Property Value

bool

KnownColor

Gets or sets the cell shading excel color.

public ExcelColors KnownColor { get; set; }

Property Value

ExcelColors

LeftBorderColor

Gets or sets left border color.

public virtual OColor LeftBorderColor { get; }

Property Value

OColor

LeftBorderLineStyle

Gets or sets line style of the left border.

public virtual LineStyleType LeftBorderLineStyle { get; set; }

Property Value

LineStyleType

Locked

True if the object is locked; False if the object can be modified when the sheet is protected.

public bool Locked { get; set; }

Property Value

bool

Name 

public string Name { get; }

Property Value

string

NumberFormat

Returns or sets the format code for the object.

public string NumberFormat { get; set; }

Property Value

string

NumberFormatIndex

Gets or Sets format index.

public int NumberFormatIndex { get; set; }

Property Value

int

NumberFormatLocal

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

public string NumberFormatLocal { get; set; }

Property Value

string

NumberFormatSettings

Returns object that describes number format. Read-only.

public INumberFormat NumberFormatSettings { get; }

Property Value

INumberFormat

Parent 

public object Parent { get; }

Property Value

object

PatternColor

Returns or sets the color of the interior pattern.

public Color PatternColor { get; set; }

Property Value

Color

PatternKnownColor

Returns or sets the excel color of the interior.

public ExcelColors PatternKnownColor { get; set; }

Property Value

ExcelColors

ReadingOrder

Returns or sets the reading order for the specified object.

public ReadingOrderType ReadingOrder { get; set; }

Property Value

ReadingOrderType

RightBorderColor

Gets or sets right border color.

public virtual OColor RightBorderColor { get; }

Property Value

OColor

RightBorderLineStyle

Gets or sets line style of the right border.

public virtual LineStyleType RightBorderLineStyle { get; set; }

Property Value

LineStyleType

Rotation

The text orientation. Can be an integer value from 1 to 180 degrees

public int Rotation { get; set; }

Property Value

int

ShrinkToFit

True if text automatically shrinks to fit in the available column width.

public bool ShrinkToFit { get; set; }

Property Value

bool

TopBorderColor

Gets or sets top border color.

public OColor TopBorderColor { get; }

Property Value

OColor

TopBorderLineStyle

Gets or sets line style of the top border.

public virtual LineStyleType TopBorderLineStyle { get; set; }

Property Value

LineStyleType

VerticalAlignment

Returns or sets the vertical alignment of the specified object.

public VerticalAlignType VerticalAlignment { get; set; }

Property Value

VerticalAlignType

Workbook 

public XlsWorkbook Workbook { get; }

Property Value

XlsWorkbook

WrapText

True if Microsoft Excel wraps the text in the object.

public bool WrapText { get; set; }

Property Value

bool

Methods

BeginUpdate() 

public override void BeginUpdate()

Clone(object) 

public override object Clone(object parent)

Parameters

parent object

Returns

object

EndUpdate() 

public override void EndUpdate()

GetBackgroundThemeColor(out ThemeColorType, out double) 

public bool GetBackgroundThemeColor(out ThemeColorType type, out double tint)

Parameters

type ThemeColorType
tint double

Returns

bool

GetThemeColor(out ThemeColorType, out double) 

public bool GetThemeColor(out ThemeColorType type, out double tint)

Parameters

type ThemeColorType
tint double

Returns

bool

SetBackgroundThemeColor(ThemeColorType, int) 

public void SetBackgroundThemeColor(ThemeColorType type, int tint)

Parameters

type ThemeColorType
tint int

SetThemeColor(ThemeColorType, double) 

public void SetThemeColor(ThemeColorType type, double tint)

Parameters

type ThemeColorType
tint double