Skip to content
Spreadsheet Editor

Style$1

type Style$1 = {
bold?: boolean;
borderBottomColor?: Color;
borderBottomStyle?: BorderStyle;
borderLeftColor?: Color;
borderLeftStyle?: BorderStyle;
borderRightColor?: Color;
borderRightStyle?: BorderStyle;
borderTopColor?: Color;
borderTopStyle?: BorderStyle;
color?: Color;
extendsStyle?: string;
fillColor?: Color;
fontFamily?: string;
fontScheme?: "major" | "minor";
fontSize?: PixelValue;
horizontalAlignment?: HAlign;
italic?: boolean;
numberFormat?: string;
patternColor?: Color;
patternStyle?: PatternStyle;
pivotButton?: boolean;
shrinkToFit?: boolean;
textRotation?: integer;
underline?: Underline;
verticalAlignment?: VAlign;
wrapText?: boolean;
};
Property Type Default value Description
bold? boolean undefined Indicates whether the text is bold. Default false
borderBottomColor? Color undefined Bottom border color.
borderBottomStyle? BorderStyle undefined Bottom border style. Default "none"
borderLeftColor? Color undefined Left border color.
borderLeftStyle? BorderStyle undefined Left border style. Default "none"
borderRightColor? Color undefined Right border color.
borderRightStyle? BorderStyle undefined Right border style. Default "none"
borderTopColor? Color undefined Top border color.
borderTopStyle? BorderStyle undefined Top border style. Default "none"
color? Color undefined The color used to render text. Default "#000"
extendsStyle? string undefined Name of the named style this style inherits from (e.g. “Percent”, “Heading 1”). Refers to a key in Workbook.namedStyles. When absent, the style inherits from the default style (typically “Normal”).
fillColor? Color undefined The cell’s background color. Default "#FFFFFF"
fontFamily? string undefined The name of the font family used to render text, e.g. "Arial". Default "Calibri"
fontScheme? "major" | "minor" undefined Identifies the font scheme, if any, to which this style’s font belongs. When set, the Style.fontFamily property is ignored and the font is instead resolved by the workbook theme. "major" maps to the theme’s heading font and "minor" to the body font. The actual typeface is determined by the theme’s ThemeFontCollection at render time. When the theme changes, an application is expected to update the fonts associated with a scheme automatically. It is an error to set this when a workbook has no theme. See - Workbook.theme - Theme.fontScheme - ThemeFontScheme - ThemeFontCollection
fontSize? PixelValue undefined The font size in pixels. Default 11
horizontalAlignment? HAlign undefined Horizontal alignment of the cells [text] content. Default "general"
italic? boolean undefined Indicates whether the text is italic. Default false
numberFormat? string undefined Formatting directions for rendering the cell’s value to text.
patternColor? Color undefined The color of a cell’s background fill. Default "#000000"
patternStyle? PatternStyle undefined The style of a cell’s background fill. Default "none"
pivotButton? boolean undefined Whether the a cell should appear as a pivot-table button header (typically shown with a dropdown-arrow filter UI, e.g. on “Row Labels” / “Column Labels”). Should be set only on cell styles used in a pivot table’s layout.
shrinkToFit? boolean undefined Indicates whether the font-size should be automatically reduced in order to make the contents of the cell visible.
textRotation? integer 0 The degrees to which the cell text should be rotated. Values range from 0 to 180, and 255 to indicate vertical text. The origin of the rotation is the first letter of the text. Min 0 Max 255
underline? Underline undefined Text underline decoration type. Default "none"
verticalAlignment? VAlign undefined Vertical alignment of the cells [text] content. Default "bottom"
wrapText? boolean undefined Indicates whether text should be wrapped when it exceeds the cell’s width. Default false