Interface ITableElementStyle

Extends cell styles but doesn't have all properties. Do we need to extend and return null (or a default value for these or omit or subclass a narrow class?) Omit

  • font.family
  • font.size
  • font.subscript, font.superscript
  • numberFormat: string;
  • alignment
  • protection
interface ITableElementStyle {
    alignment: CellAlignmentValues;
    border: ICellBorder;
    fill: INoneFill | ISolidFill | IGradientFill | IPatternFill;
    font: IFont;
    isTableElementStyle: true;
    namedStyle: string;
    numberFormat: string;
    protection: CellProtectionValues;
    quotePrefix: boolean;
    hasEmptyStyling(): boolean;
    toJSON(): Partial<{
        alignment: string | CellAlignmentValues | Partial<{
            horizontal: string;
            indent: string | number;
            justifyLastLine: string | Partial<boolean>;
            overflow: string;
            readingDirection: string;
            relativeIndent: string | number;
            rotation: string | number;
            stacked: string | Partial<boolean>;
            vertical: string;
        }>;
        border: string | CellBorderValues | Partial<{
            bottom: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            diagonalDown: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            diagonalUp: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            horizontal: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            left: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            right: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            top: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            vertical: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
        }>;
        fill: string | AdjustedColor | SolidFillValues | GradientFillValues | PatternFillValues | NoneFillValues | Partial<{
            val: string;
            adjustments: any;
            asCSS: any;
            isEqual: any;
            isImmutable: any;
            toHSLA: any;
            toHex: any;
            toJSON: any;
            toRGBA: any;
            toString: any;
        } | {
            color: string | AdjustedColor | Partial<{
                val: string;
                adjustments: any;
                asCSS: any;
                isEqual: any;
                isImmutable: any;
                toHSLA: any;
                toHex: any;
                toJSON: any;
                toRGBA: any;
                toString: any;
            }>;
            fillType: string;
        } | {
            angle: string | number;
            fillTo: string | Rectangle | Partial<{
                bottom: string | number;
                left: string | number;
                right: string | number;
                top: string | number;
            }>;
            fillType: string;
            gradientType: string;
            stops: string | GradientStop[] | (string | GradientStop | Partial<{
                color: ...;
                offset?: ...;
            }>)[];
        } | {
            background: string | AdjustedColor | Partial<{
                val: string;
                adjustments: any;
                asCSS: any;
                isEqual: any;
                isImmutable: any;
                toHSLA: any;
                toHex: any;
                toJSON: any;
                toRGBA: any;
                toString: any;
            }>;
            fillType: string;
            foreground: string | AdjustedColor | Partial<{
                val: string;
                adjustments: any;
                asCSS: any;
                isEqual: any;
                isImmutable: any;
                toHSLA: any;
                toHex: any;
                toJSON: any;
                toRGBA: any;
                toString: any;
            }>;
            patternType: string;
        } | {
            fillType: string;
        }>;
        font: string | FontValues | Partial<{
            extend: string | Partial<boolean>;
            family: string;
            familyFallbacks: string | string[];
            fill: string | AdjustedColor | Partial<{
                val: string;
                adjustments: any;
                asCSS: any;
                isEqual: any;
                isImmutable: any;
                toHSLA: any;
                toHex: any;
                toJSON: any;
                toRGBA: any;
                toString: any;
            }>;
            letterSpacing: string | number;
            outline: string | Partial<boolean>;
            scheme: string;
            shadow: string | Partial<boolean>;
            size: string | number;
            strike: string | Partial<boolean>;
            style: string;
            underline: string | boolean;
            verticalAlign: string;
            weight: string | number;
        }>;
        namedStyle: string;
        numberFormat: string;
        protection: string | CellProtectionValues | Partial<{
            formulaHidden: string | Partial<boolean>;
            locked: string | Partial<boolean>;
        }>;
        quotePrefix: string | Partial<boolean>;
    }>;
}

Hierarchy

Properties

alignment border fill font isTableElementStyle namedStyle numberFormat protection quotePrefix

Methods

hasEmptyStyling toJSON

Properties

Readonly alignment

alignment: CellAlignmentValues

Alignment properties.

See

CellAlignmentValues

border

border: ICellBorder

fill

fill: INoneFill | ISolidFill | IGradientFill | IPatternFill

font

font: IFont

Readonly isTableElementStyle

isTableElementStyle: true

Readonly namedStyle

namedStyle: string

The name of the namedStyle that is being referenced. For named styles this is null or ignored. If this is not specified then all unspecified fields will inherit from the normal style

Readonly numberFormat

numberFormat: string

Format used for

See

Additional we allow for aliases to be set.

Readonly protection

protection: CellProtectionValues

Protection properties.

See

CellProtectionValues

Readonly quotePrefix

quotePrefix: boolean

A boolean value indicating whether the text string in a cell should be prefixed by a single quote mark (e.g., 'text). In these cases, the quote is not stored in the Shared Strings Part.

Methods

hasEmptyStyling

  • hasEmptyStyling(): boolean

  • This is used to determine if the style has rendering artifacts even if there is no content. (For example borders or background)

    Returns boolean

toJSON

  • toJSON(): Partial<{
        alignment: string | CellAlignmentValues | Partial<{
            horizontal: string;
            indent: string | number;
            justifyLastLine: string | Partial<boolean>;
            overflow: string;
            readingDirection: string;
            relativeIndent: string | number;
            rotation: string | number;
            stacked: string | Partial<boolean>;
            vertical: string;
        }>;
        border: string | CellBorderValues | Partial<{
            bottom: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            diagonalDown: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            diagonalUp: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            horizontal: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            left: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            right: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            top: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            vertical: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
        }>;
        fill: string | AdjustedColor | SolidFillValues | GradientFillValues | PatternFillValues | NoneFillValues | Partial<{
            val: string;
            adjustments: any;
            asCSS: any;
            isEqual: any;
            isImmutable: any;
            toHSLA: any;
            toHex: any;
            toJSON: any;
            toRGBA: any;
            toString: any;
        } | {
            color: string | AdjustedColor | Partial<{
                val: string;
                adjustments: any;
                asCSS: any;
                isEqual: any;
                isImmutable: any;
                toHSLA: any;
                toHex: any;
                toJSON: any;
                toRGBA: any;
                toString: any;
            }>;
            fillType: string;
        } | {
            angle: string | number;
            fillTo: string | Rectangle | Partial<{
                bottom: string | number;
                left: string | number;
                right: string | number;
                top: string | number;
            }>;
            fillType: string;
            gradientType: string;
            stops: string | GradientStop[] | (string | GradientStop | Partial<{
                color: ...;
                offset?: ...;
            }>)[];
        } | {
            background: string | AdjustedColor | Partial<{
                val: string;
                adjustments: any;
                asCSS: any;
                isEqual: any;
                isImmutable: any;
                toHSLA: any;
                toHex: any;
                toJSON: any;
                toRGBA: any;
                toString: any;
            }>;
            fillType: string;
            foreground: string | AdjustedColor | Partial<{
                val: string;
                adjustments: any;
                asCSS: any;
                isEqual: any;
                isImmutable: any;
                toHSLA: any;
                toHex: any;
                toJSON: any;
                toRGBA: any;
                toString: any;
            }>;
            patternType: string;
        } | {
            fillType: string;
        }>;
        font: string | FontValues | Partial<{
            extend: string | Partial<boolean>;
            family: string;
            familyFallbacks: string | string[];
            fill: string | AdjustedColor | Partial<{
                val: string;
                adjustments: any;
                asCSS: any;
                isEqual: any;
                isImmutable: any;
                toHSLA: any;
                toHex: any;
                toJSON: any;
                toRGBA: any;
                toString: any;
            }>;
            letterSpacing: string | number;
            outline: string | Partial<boolean>;
            scheme: string;
            shadow: string | Partial<boolean>;
            size: string | number;
            strike: string | Partial<boolean>;
            style: string;
            underline: string | boolean;
            verticalAlign: string;
            weight: string | number;
        }>;
        namedStyle: string;
        numberFormat: string;
        protection: string | CellProtectionValues | Partial<{
            formulaHidden: string | Partial<boolean>;
            locked: string | Partial<boolean>;
        }>;
        quotePrefix: string | Partial<boolean>;
    }>

  • Returns Partial<{
        alignment: string | CellAlignmentValues | Partial<{
            horizontal: string;
            indent: string | number;
            justifyLastLine: string | Partial<boolean>;
            overflow: string;
            readingDirection: string;
            relativeIndent: string | number;
            rotation: string | number;
            stacked: string | Partial<boolean>;
            vertical: string;
        }>;
        border: string | CellBorderValues | Partial<{
            bottom: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            diagonalDown: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            diagonalUp: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            horizontal: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            left: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            right: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            top: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
            vertical: string | BorderStroke | Partial<{
                color: string | AdjustedColor | Partial<{
                    val: ...;
                    adjustments: any;
                    asCSS: any;
                    isEqual: any;
                    isImmutable: any;
                    toHSLA: any;
                    toHex: any;
                    toJSON: any;
                    toRGBA: any;
                    toString: any;
                }>;
                style: string;
            }>;
        }>;
        fill: string | AdjustedColor | SolidFillValues | GradientFillValues | PatternFillValues | NoneFillValues | Partial<{
            val: string;
            adjustments: any;
            asCSS: any;
            isEqual: any;
            isImmutable: any;
            toHSLA: any;
            toHex: any;
            toJSON: any;
            toRGBA: any;
            toString: any;
        } | {
            color: string | AdjustedColor | Partial<{
                val: string;
                adjustments: any;
                asCSS: any;
                isEqual: any;
                isImmutable: any;
                toHSLA: any;
                toHex: any;
                toJSON: any;
                toRGBA: any;
                toString: any;
            }>;
            fillType: string;
        } | {
            angle: string | number;
            fillTo: string | Rectangle | Partial<{
                bottom: string | number;
                left: string | number;
                right: string | number;
                top: string | number;
            }>;
            fillType: string;
            gradientType: string;
            stops: string | GradientStop[] | (string | GradientStop | Partial<{
                color: ...;
                offset?: ...;
            }>)[];
        } | {
            background: string | AdjustedColor | Partial<{
                val: string;
                adjustments: any;
                asCSS: any;
                isEqual: any;
                isImmutable: any;
                toHSLA: any;
                toHex: any;
                toJSON: any;
                toRGBA: any;
                toString: any;
            }>;
            fillType: string;
            foreground: string | AdjustedColor | Partial<{
                val: string;
                adjustments: any;
                asCSS: any;
                isEqual: any;
                isImmutable: any;
                toHSLA: any;
                toHex: any;
                toJSON: any;
                toRGBA: any;
                toString: any;
            }>;
            patternType: string;
        } | {
            fillType: string;
        }>;
        font: string | FontValues | Partial<{
            extend: string | Partial<boolean>;
            family: string;
            familyFallbacks: string | string[];
            fill: string | AdjustedColor | Partial<{
                val: string;
                adjustments: any;
                asCSS: any;
                isEqual: any;
                isImmutable: any;
                toHSLA: any;
                toHex: any;
                toJSON: any;
                toRGBA: any;
                toString: any;
            }>;
            letterSpacing: string | number;
            outline: string | Partial<boolean>;
            scheme: string;
            shadow: string | Partial<boolean>;
            size: string | number;
            strike: string | Partial<boolean>;
            style: string;
            underline: string | boolean;
            verticalAlign: string;
            weight: string | number;
        }>;
        namedStyle: string;
        numberFormat: string;
        protection: string | CellProtectionValues | Partial<{
            formulaHidden: string | Partial<boolean>;
            locked: string | Partial<boolean>;
        }>;
        quotePrefix: string | Partial<boolean>;
    }>

Settings

Member Visibility

Theme

On This Page

alignmentborderfillfontisTableElementStylenamedStylenumberFormatprotectionquotePrefixhasEmptyStylingtoJSON