API Reference

Class

LegacyXlsCellFormat

Namespace OfficeIMO.Excel.LegacyXls.Model
Assembly OfficeIMO.Excel
Modifiers sealed

Represents a parsed legacy XLS XF cell format.

Inheritance

  • Object
  • LegacyXlsCellFormat

Usage

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Returned or exposed by

Accepted by parameters

Constructors

public LegacyXlsCellFormat(UInt16 styleIndex, UInt16 fontIndex, UInt16 numberFormatId, Boolean isStyle, UInt16 parentStyleIndex, Boolean applyNumberFormat, Boolean applyFont, Boolean applyFill, Byte fillPattern, UInt16 fillForegroundColorIndex, UInt16 fillBackgroundColorIndex, Boolean applyBorder, Boolean applyAlignment, Byte horizontalAlignment, Byte verticalAlignment, Boolean wrapText, Byte textRotation, Byte indent, Boolean shrinkToFit, Byte readingOrder, Boolean applyProtection, Boolean locked, Boolean formulaHidden, Boolean quotePrefix, LegacyXlsBorder border, String numberFormatCode, Boolean isBuiltInNumberFormat, Boolean isDateLike) #

Creates a parsed legacy XLS cell format.

Parameters

styleIndex System.UInt16 requiredposition: 0
Zero-based XF index.
fontIndex System.UInt16 requiredposition: 1
Legacy FontIndex referenced by the XF record.
numberFormatId System.UInt16 requiredposition: 2
Legacy IFmt number format identifier.
isStyle System.Boolean requiredposition: 3
Whether this XF represents a cell style XF rather than a cell XF.
parentStyleIndex System.UInt16 requiredposition: 4
Legacy parent style XF index for cell XF inheritance.
applyNumberFormat System.Boolean requiredposition: 5
Whether the number format facet is owned by this cell XF.
applyFont System.Boolean requiredposition: 6
Whether the font facet is owned by this cell XF.
applyFill System.Boolean requiredposition: 7
Whether the fill facet is owned by this cell XF.
fillPattern System.Byte requiredposition: 8
Legacy fill pattern code.
fillForegroundColorIndex System.UInt16 requiredposition: 9
Legacy foreground fill color index.
fillBackgroundColorIndex System.UInt16 requiredposition: 10
Legacy background fill color index.
applyBorder System.Boolean requiredposition: 11
Whether the border facet is owned by this cell XF.
applyAlignment System.Boolean requiredposition: 12
Whether alignment fields should be projected.
horizontalAlignment System.Byte requiredposition: 13
Legacy horizontal alignment code.
verticalAlignment System.Byte requiredposition: 14
Legacy vertical alignment code.
wrapText System.Boolean requiredposition: 15
Whether text wrapping is enabled.
textRotation System.Byte requiredposition: 16
Legacy text rotation code.
indent System.Byte requiredposition: 17
Legacy indentation level.
shrinkToFit System.Boolean requiredposition: 18
Whether shrink-to-fit is enabled.
readingOrder System.Byte requiredposition: 19
Legacy reading order code.
applyProtection System.Boolean requiredposition: 20
Whether protection fields should be projected.
locked System.Boolean requiredposition: 21
Whether locked protection is enabled.
formulaHidden System.Boolean requiredposition: 22
Whether formula display is hidden when the worksheet is protected.
quotePrefix System.Boolean requiredposition: 23
Whether the cell has a Lotus 1-2-3 quote-prefix marker.
border OfficeIMO.Excel.LegacyXls.Model.LegacyXlsBorder requiredposition: 24
Resolved border formatting, when present.
numberFormatCode System.String requiredposition: 25
Resolved Excel number format code.
isBuiltInNumberFormat System.Boolean requiredposition: 26
Whether the number format id is built in.
isDateLike System.Boolean requiredposition: 27
Whether the number format should be treated as a date/time format.

Properties

public UInt16 StyleIndex { get; } #

Gets the zero-based legacy XF index referenced by cells.

public UInt16 FontIndex { get; } #

Gets the legacy FontIndex referenced by the XF record.

public UInt16 NumberFormatId { get; } #

Gets the legacy IFmt number format identifier.

public Boolean IsStyle { get; } #

Gets whether this XF represents a cell style XF rather than a cell XF.

public UInt16 ParentStyleIndex { get; } #

Gets the parent style XF index referenced by a cell XF.

public Boolean ApplyNumberFormat { get; } #

Gets whether the number format facet is owned by this cell XF instead of inherited from the parent style XF.

public Boolean ApplyFont { get; } #

Gets whether the font facet is owned by this cell XF instead of inherited from the parent style XF.

public Boolean ApplyFill { get; } #

Gets whether the fill facet is owned by this cell XF instead of inherited from the parent style XF.

public Byte FillPattern { get; } #

Gets the legacy fill pattern code.

public UInt16 FillForegroundColorIndex { get; } #

Gets the legacy foreground fill color index.

public UInt16 FillBackgroundColorIndex { get; } #

Gets the legacy background fill color index.

public Boolean ApplyBorder { get; } #

Gets whether the border facet is owned by this cell XF instead of inherited from the parent style XF.

public Boolean ApplyAlignment { get; } #

Gets whether alignment fields should be projected.

public Byte HorizontalAlignment { get; } #

Gets the legacy horizontal alignment code.

public Byte VerticalAlignment { get; } #

Gets the legacy vertical alignment code.

public Boolean WrapText { get; } #

Gets whether text wrapping is enabled.

public Byte TextRotation { get; } #

Gets the legacy text rotation code.

public Byte Indent { get; } #

Gets the legacy indentation level.

public Boolean ShrinkToFit { get; } #

Gets whether shrink-to-fit is enabled.

public Byte ReadingOrder { get; } #

Gets the legacy reading order code.

public Boolean ApplyProtection { get; } #

Gets whether protection fields should be projected.

public Boolean Locked { get; } #

Gets whether locked protection is enabled.

public Boolean FormulaHidden { get; } #

Gets whether formula display is hidden when the worksheet is protected.

public Boolean QuotePrefix { get; } #

Gets whether the cell has a Lotus 1-2-3 quote-prefix marker.

public LegacyXlsBorder Border { get; } #

Gets parsed border formatting, when present.

public String NumberFormatCode { get; } #

Gets the resolved Excel number format code, when known.

public Boolean IsBuiltInNumberFormat { get; } #

Gets whether the number format identifier is built in.

public Boolean IsDateLike { get; } #

Gets whether this cell format should be treated as date/time-like.