Interface IWorksheetCellFormat

Represents the format for the cell.

Depending on where the format is exposed, it will have a different meaning. For example, a cell's format just applies to itself, but a row or column's format applies to all cells in that row or column. There are also style formats, which can be the parent of other formats, meaning they provide defaults for values not set on the format. And finally, there are differential formats, such as the format for areas in a table, which provide default values for cells which exist in the associated area.

see

WorksheetCell.cellFormat

see

RowColumnBase.cellFormat

see

WorksheetMergedCellsRegion.cellFormat

see

WorkbookStyle.styleFormat

see

WorksheetTable.areaFormats

see

WorksheetTableColumn.areaFormats

see

WorksheetTableStyle.areaFormats

see

WorksheetCell.getResolvedCellFormat

see

RowColumnBase.getResolvedCellFormat

see

WorksheetMergedCellsRegion.getResolvedCellFormat

Hierarchy

  • IWorksheetCellFormat

Properties

_locked$i

_locked$i: Nullable$1<boolean>

_shrinkToFit$i

_shrinkToFit$i: Nullable$1<boolean>

_wrapText$i

_wrapText$i: Nullable$1<boolean>

alignment

bottomBorderColorInfo

bottomBorderColorInfo: WorkbookColorInfo

bottomBorderStyle

bottomBorderStyle: CellBorderLineStyle

diagonalBorderColorInfo

diagonalBorderColorInfo: WorkbookColorInfo

diagonalBorderStyle

diagonalBorderStyle: CellBorderLineStyle

diagonalBorders

diagonalBorders: DiagonalBorders

fill

fill: CellFill

font

formatOptions

formatString

formatString: string

indent

indent: number

leftBorderColorInfo

leftBorderColorInfo: WorkbookColorInfo

leftBorderStyle

leftBorderStyle: CellBorderLineStyle

locked

locked: boolean | null

rightBorderColorInfo

rightBorderColorInfo: WorkbookColorInfo

rightBorderStyle

rightBorderStyle: CellBorderLineStyle

rotation

rotation: number

shrinkToFit

shrinkToFit: boolean | null

style

topBorderColorInfo

topBorderColorInfo: WorkbookColorInfo

topBorderStyle

topBorderStyle: CellBorderLineStyle

verticalAlignment

verticalAlignment: VerticalCellAlignment

wrapText

wrapText: boolean | null

Methods

setFormatting

  • Parameters

    Returns void