Class SheetStyle

Base implementation of

See

ISheetStyle

TODO - defaultFontSize move to theme?

Implements

ISheetStyle

Constructors

constructor

new SheetStyle(docTheme?, indexedColors?, defaultFontSize?): SheetStyle
Parameters
- docTheme: IDocTheme = null
- indexedColors: string[] = null
- defaultFontSize: number = 11
Returns SheetStyle

Methods

_releaseSharedState

_releaseSharedState(state): void
Parameters
- state: SharedCellStyleState
Returns void

_releaseSharedStyles

_releaseSharedStyles(ref): void
Parameters
- ref: any
Returns void

addListener

addListener(listener): RemoveListener
Add a listener for style changes.
Parameters
- listener: ISheetStyleListener
Returns RemoveListener
Implementation of ISheetStyle.addListener

addRecentColor

addRecentColor(color): readonly AdjustedColor[]
Add a color to the mru list. This is used to populate color pickers.

Note - Any color can be added but generally this should be limited to custom/non-themed color
Parameters
- color: AdjustedColor
Returns readonly AdjustedColor[]
Implementation of ISheetStyle.addRecentColor

addSharedStyleRef

addSharedStyleRef(style, ref): ICellStyle
Add a reference for a shared style. This is done to allow styles to be shared. The reference passed is used to track the current style usage. Once it's released or GC'ed the style will be release from the shared pool.
Parameters
- style: ICellStyle
- ref: any
Returns ICellStyle
Remarks
Returns a reference to a new style. If will generally be the same cell style but if the cells style was created from a different styles then a new one will be returned.

Style
The previously created style

Implementation of ISheetStyle.addSharedStyleRef

beginPersist

beginPersist(): IStylesPersistScope
Start persisting styles. This is used during save/load to allow for styles to be references by an id count. This is a stack so multiple begins will need to be matched with an end.

Returns IStylesPersistScope
See
IStylesPersistScope

Implementation of ISheetStyle.beginPersist

clearRecentColors

clearRecentColors(): void
Clears the mru color list

Returns void
Implementation of ISheetStyle.clearRecentColors

createTemporaryStyle

createTemporaryStyle(adjustment, original): ICellStyle
Allows for a non managed style. Useful for tooltips or other transient styles.
Parameters
- adjustment: Partial<{
      alignment: string | CellAlignmentValues | Partial<{
          horizontal: string | ((value, resolveShorthands?) => string);
          indent: string | number | ((value, resolveShorthands?) => string | number);
          justifyLastLine: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          overflow: string | ((value, resolveShorthands?) => string);
          readingDirection: string | ((value, resolveShorthands?) => string);
          relativeIndent: string | number | ((value, resolveShorthands?) => string | number);
          rotation: string | number | ((value, resolveShorthands?) => string | number);
          stacked: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          vertical: string | ((value, resolveShorthands?) => string);
      }> | ((value, resolveShorthands?) => string | CellAlignmentValues);
      border: string | CellBorderValues | Partial<{
          bottom: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          diagonalDown: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          diagonalUp: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          horizontal: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          left: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          right: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          top: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          vertical: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
      }> | ((value, resolveShorthands?) => string | CellBorderValues);
      fill: string | AdjustedColor | SolidFillValues | GradientFillValues | PatternFillValues | NoneFillValues | Partial<{
          val: string | ((value, resolveShorthands?) => string);
          adjustments: any;
          asCSS: any;
          isEqual: any;
          isImmutable: any;
          toHSLA: any;
          toHex: any;
          toJSON: any;
          toRGBA: any;
          toString: any;
      } | {
          color: string | AdjustedColor | Partial<{
              val: (...) | (...);
              adjustments: any;
              asCSS: any;
              isEqual: any;
              isImmutable: any;
              toHSLA: any;
              toHex: any;
              toJSON: any;
              toRGBA: any;
              toString: any;
          }> | ((value, resolveShorthands?) => string | AdjustedColor);
          fillType: string | ((value, resolveShorthands?) => string);
      } | {
          angle: string | number | ((value, resolveShorthands?) => string | number);
          fillTo: string | Rectangle | Partial<{
              bottom: (...) | (...) | (...);
              left: (...) | (...) | (...);
              right: (...) | (...) | (...);
              top: (...) | (...) | (...);
          }> | ((value, resolveShorthands?) => string | Rectangle);
          fillType: string | ((value, resolveShorthands?) => string);
          gradientType: string | ((value, resolveShorthands?) => string);
          stops: string | GradientStop[] | (string | GradientStop | Partial<(...)> | ((value, resolveShorthands?) => ...))[] | ((value, resolveShorthands?) => string | (...)[]);
      } | {
          background: string | AdjustedColor | Partial<{
              val: (...) | (...);
              adjustments: any;
              asCSS: any;
              isEqual: any;
              isImmutable: any;
              toHSLA: any;
              toHex: any;
              toJSON: any;
              toRGBA: any;
              toString: any;
          }> | ((value, resolveShorthands?) => string | AdjustedColor);
          fillType: string | ((value, resolveShorthands?) => string);
          foreground: string | AdjustedColor | Partial<{
              val: (...) | (...);
              adjustments: any;
              asCSS: any;
              isEqual: any;
              isImmutable: any;
              toHSLA: any;
              toHex: any;
              toJSON: any;
              toRGBA: any;
              toString: any;
          }> | ((value, resolveShorthands?) => string | AdjustedColor);
          patternType: string | ((value, resolveShorthands?) => string);
      } | {
          fillType: string | ((value, resolveShorthands?) => string);
      }> | ((value, resolveShorthands?) => string | AdjustedColor | SolidFillValues | GradientFillValues | PatternFillValues | NoneFillValues);
      font: string | FontValues | Partial<{
          extend: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          family: string | ((value, resolveShorthands?) => string);
          familyFallbacks: string | string[] | (string | ((value, resolveShorthands?) => string))[] | ((value, resolveShorthands?) => string | string[]);
          fill: string | AdjustedColor | Partial<{
              val: string | ((value, resolveShorthands?) => ...);
              adjustments: any;
              asCSS: any;
              isEqual: any;
              isImmutable: any;
              toHSLA: any;
              toHex: any;
              toJSON: any;
              toRGBA: any;
              toString: any;
          }> | ((value, resolveShorthands?) => string | AdjustedColor);
          letterSpacing: string | number | ((value, resolveShorthands?) => string | number);
          outline: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          scheme: string | ((value, resolveShorthands?) => string);
          shadow: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          size: string | number | ((value, resolveShorthands?) => string | number);
          strike: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          style: string | ((value, resolveShorthands?) => string);
          underline: string | boolean | ((value, resolveShorthands?) => string | boolean);
          verticalAlign: string | ((value, resolveShorthands?) => string);
          weight: string | number | ((value, resolveShorthands?) => string | number);
      }> | ((value, resolveShorthands?) => string | FontValues);
      namedStyle: string | ((value, resolveShorthands?) => string);
      numberFormat: string | ((value, resolveShorthands?) => string);
      protection: string | CellProtectionValues | Partial<{
          formulaHidden: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          locked: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
      }> | ((value, resolveShorthands?) => string | CellProtectionValues);
      quotePrefix: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
  }> | ICellStyleUpdater
- original: ICellStyle
  (And original values to inherit from)
Returns ICellStyle
Implementation of ISheetStyle.createTemporaryStyle

getBuiltInCellStyle

getBuiltInCellStyle(key): INamedCellStyle
Returns the built in cell style for the given key.
Parameters
- key: string | number
Returns INamedCellStyle
Remarks
Case insensitive; to find the actual name casing use

See
INamedCellStyle.name

Implementation of ISheetStyle.getBuiltInCellStyle

getBuiltInTableStyle

getBuiltInTableStyle(key): ITableStyle
Returns the built in style for the given key.
Parameters
- key: string
  A string of the name of the table.
Returns ITableStyle
Remarks
Case insensitive; to find the actual name casing use

See
INamedCellStyle.name

Implementation of ISheetStyle.getBuiltInTableStyle

getCustomCellStyles

getCustomCellStyles(): INamedCellStyle[]
Returns all customized named cell styles.

Returns INamedCellStyle[]
Remarks
This includes new style names and builtin overrides.

Implementation of ISheetStyle.getCustomCellStyles

getCustomIndexedColors

getCustomIndexedColors(): readonly AdjustedColor[]
Return the customized Indexed colors.

Returns readonly AdjustedColor[]
Implementation of ISheetStyle.getCustomIndexedColors

getCustomTableStyles

getCustomTableStyles(): ITableStyle[]
Returns all customized table styles.

Returns ITableStyle[]
Remarks
This includes new table styles and builtin overrides.

Implementation of ISheetStyle.getCustomTableStyles

getDefaultFontSize

getDefaultFontSize(): number
Themes do not contain font sizes but it is possible to set a default font size at the document or application level.

Returns number
Implementation of ISheetStyle.getDefaultFontSize

getDefaultTableStyle

getDefaultTableStyle(): ITableStyle
Returns the default TableStyle.

Returns ITableStyle
See
setDefaultTableStyle

Implementation of ISheetStyle.getDefaultTableStyle

getIndexedColors

getIndexedColors(): readonly AdjustedColor[]
Return an array of colors that will be used to resolve any colors that use IndexXX or ColorXX as a key.

Returns readonly AdjustedColor[]
Remarks
This will also return a list of colors.

Implementation of ISheetStyle.getIndexedColors

getNamedCellStyle

getNamedCellStyle(name): INamedCellStyle
Returns The named style from either a custom style or a builtin.
Parameters
- name: string
Returns INamedCellStyle
Remarks
Will try to return:
1. The custom style for the name
2. The builtin style for the name.
3. nul if it doesn't exist.
Implementation of ISheetStyle.getNamedCellStyle

getNormalStyle

getNormalStyle(): INamedCellStyle
Convenience mechanism (and slightly faster) way to call getNamedCellStyle('Normal');

Returns INamedCellStyle
Implementation of ISheetStyle.getNormalStyle

getSharedStyle

getSharedStyle(adjustment, original, ref): ICellStyle
Returns a style that is an adjustment of the original. This method also tracks usages of the styles.

If an adjustment of null or has no values then the 'named' style will be returned.

Note - If a style that is being updated is using the same original cell and the same ref. The original style is released.
Parameters
- adjustment: Partial<{
      alignment: string | CellAlignmentValues | Partial<{
          horizontal: string | ((value, resolveShorthands?) => string);
          indent: string | number | ((value, resolveShorthands?) => string | number);
          justifyLastLine: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          overflow: string | ((value, resolveShorthands?) => string);
          readingDirection: string | ((value, resolveShorthands?) => string);
          relativeIndent: string | number | ((value, resolveShorthands?) => string | number);
          rotation: string | number | ((value, resolveShorthands?) => string | number);
          stacked: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          vertical: string | ((value, resolveShorthands?) => string);
      }> | ((value, resolveShorthands?) => string | CellAlignmentValues);
      border: string | CellBorderValues | Partial<{
          bottom: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          diagonalDown: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          diagonalUp: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          horizontal: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          left: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          right: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          top: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          vertical: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
      }> | ((value, resolveShorthands?) => string | CellBorderValues);
      fill: string | AdjustedColor | SolidFillValues | GradientFillValues | PatternFillValues | NoneFillValues | Partial<{
          val: string | ((value, resolveShorthands?) => string);
          adjustments: any;
          asCSS: any;
          isEqual: any;
          isImmutable: any;
          toHSLA: any;
          toHex: any;
          toJSON: any;
          toRGBA: any;
          toString: any;
      } | {
          color: string | AdjustedColor | Partial<{
              val: (...) | (...);
              adjustments: any;
              asCSS: any;
              isEqual: any;
              isImmutable: any;
              toHSLA: any;
              toHex: any;
              toJSON: any;
              toRGBA: any;
              toString: any;
          }> | ((value, resolveShorthands?) => string | AdjustedColor);
          fillType: string | ((value, resolveShorthands?) => string);
      } | {
          angle: string | number | ((value, resolveShorthands?) => string | number);
          fillTo: string | Rectangle | Partial<{
              bottom: (...) | (...) | (...);
              left: (...) | (...) | (...);
              right: (...) | (...) | (...);
              top: (...) | (...) | (...);
          }> | ((value, resolveShorthands?) => string | Rectangle);
          fillType: string | ((value, resolveShorthands?) => string);
          gradientType: string | ((value, resolveShorthands?) => string);
          stops: string | GradientStop[] | (string | GradientStop | Partial<(...)> | ((value, resolveShorthands?) => ...))[] | ((value, resolveShorthands?) => string | (...)[]);
      } | {
          background: string | AdjustedColor | Partial<{
              val: (...) | (...);
              adjustments: any;
              asCSS: any;
              isEqual: any;
              isImmutable: any;
              toHSLA: any;
              toHex: any;
              toJSON: any;
              toRGBA: any;
              toString: any;
          }> | ((value, resolveShorthands?) => string | AdjustedColor);
          fillType: string | ((value, resolveShorthands?) => string);
          foreground: string | AdjustedColor | Partial<{
              val: (...) | (...);
              adjustments: any;
              asCSS: any;
              isEqual: any;
              isImmutable: any;
              toHSLA: any;
              toHex: any;
              toJSON: any;
              toRGBA: any;
              toString: any;
          }> | ((value, resolveShorthands?) => string | AdjustedColor);
          patternType: string | ((value, resolveShorthands?) => string);
      } | {
          fillType: string | ((value, resolveShorthands?) => string);
      }> | ((value, resolveShorthands?) => string | AdjustedColor | SolidFillValues | GradientFillValues | PatternFillValues | NoneFillValues);
      font: string | FontValues | Partial<{
          extend: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          family: string | ((value, resolveShorthands?) => string);
          familyFallbacks: string | string[] | (string | ((value, resolveShorthands?) => string))[] | ((value, resolveShorthands?) => string | string[]);
          fill: string | AdjustedColor | Partial<{
              val: string | ((value, resolveShorthands?) => ...);
              adjustments: any;
              asCSS: any;
              isEqual: any;
              isImmutable: any;
              toHSLA: any;
              toHex: any;
              toJSON: any;
              toRGBA: any;
              toString: any;
          }> | ((value, resolveShorthands?) => string | AdjustedColor);
          letterSpacing: string | number | ((value, resolveShorthands?) => string | number);
          outline: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          scheme: string | ((value, resolveShorthands?) => string);
          shadow: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          size: string | number | ((value, resolveShorthands?) => string | number);
          strike: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          style: string | ((value, resolveShorthands?) => string);
          underline: string | boolean | ((value, resolveShorthands?) => string | boolean);
          verticalAlign: string | ((value, resolveShorthands?) => string);
          weight: string | number | ((value, resolveShorthands?) => string | number);
      }> | ((value, resolveShorthands?) => string | FontValues);
      namedStyle: string | ((value, resolveShorthands?) => string);
      numberFormat: string | ((value, resolveShorthands?) => string);
      protection: string | CellProtectionValues | Partial<{
          formulaHidden: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          locked: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
      }> | ((value, resolveShorthands?) => string | CellProtectionValues);
      quotePrefix: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
  }> | ICellStyleUpdater
- original: ICellStyle
- ref: any
Returns ICellStyle
Adjustment
either a new partial style or a ICellStyleUpdater that

Original
the original style. This is either another SharedStyle which will be used as a template or a NamedStyle. If this is not specified then the normal style will be used.

Ref
This is any object that is used for tracking.

Implementation of ISheetStyle.getSharedStyle

getTableStyle

getTableStyle(name): ITableStyle
Returns The table style. This can be either a custom or a built in table style.
Parameters
- name: string
Returns ITableStyle
Remarks
Will try to return:
1. The custom style for the name
2. The builtin style for the name.
3. null if it doesn't exist.
Implementation of ISheetStyle.getTableStyle

getTheme

getTheme(): IDocTheme
Returns the current theme

Returns IDocTheme
Implementation of ISheetStyle.getTheme

hideOrRemoveNamedCellStyle

hideOrRemoveNamedCellStyle(style): boolean
This will remove a custom styles or hide built-in cell style.
Parameters
- style: string | INamedCellStyle
  The named style or the string name of a named style.
Returns boolean
Returns a flag indicating if the style was removed or hidden.

Implementation of ISheetStyle.hideOrRemoveNamedCellStyle

indexedColorLookup

indexedColorLookup(): IndexedColorLookup
This is available for functions that want to resolve colors using the index color palette.

Returns IndexedColorLookup
Implementation of ISheetStyle.indexedColorLookup

normalize

normalize(values): Partial<CellStyleValues>
Converts a list of SerializableCellStyleValues that contain shorthand values into native values. It will also remove any value that resolve to the same values as the referenced named style (or Normal if this is not specified)
Parameters
- values: 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<CellStyleValues>
Implementation of ISheetStyle.normalize

normalizeBorder

normalizeBorder(original, coords, range): Partial<{
    bottom: string | BorderStroke | Partial<{
        color: string | AdjustedColor | Partial<{
            val: string;
            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: string;
            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: string;
            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: string;
            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: string;
            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: string;
            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: string;
            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: string;
            adjustments: any;
            asCSS: any;
            isEqual: any;
            isImmutable: any;
            toHSLA: any;
            toHex: any;
            toJSON: any;
            toRGBA: any;
            toString: any;
        }>;
        style: string;
    }>;
}>
Given a border rationalize the border edges for a coord with a range.
Parameters
- original: Partial<{
      bottom: string | BorderStroke | Partial<{
          color: string | AdjustedColor | Partial<{
              val: string;
              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: string;
              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: string;
              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: string;
              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: string;
              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: string;
              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: string;
              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: string;
              adjustments: any;
              asCSS: any;
              isEqual: any;
              isImmutable: any;
              toHSLA: any;
              toHex: any;
              toJSON: any;
              toRGBA: any;
              toString: any;
          }>;
          style: string;
      }>;
  }>
- coords: CellCoords
- range: CellRangeCoords
Returns Partial<{
    bottom: string | BorderStroke | Partial<{
        color: string | AdjustedColor | Partial<{
            val: string;
            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: string;
            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: string;
            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: string;
            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: string;
            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: string;
            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: string;
            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: string;
            adjustments: any;
            asCSS: any;
            isEqual: any;
            isImmutable: any;
            toHSLA: any;
            toHex: any;
            toJSON: any;
            toRGBA: any;
            toString: any;
        }>;
        style: string;
    }>;
}>
Implementation of ISheetStyle.normalizeBorder

recentColors

recentColors(): readonly AdjustedColor[]
Returns a list of colors that were added via

Returns readonly AdjustedColor[]
See
addRecentColor

Implementation of ISheetStyle.recentColors

removeCustomCellStyle

removeCustomCellStyle(style): boolean
This will remove a custom cell style.
Parameters
- style: string | INamedCellStyle
  The named style or the string name of a named style.
Returns boolean
true if the style was removed.

Implementation of ISheetStyle.removeCustomCellStyle

removeCustomTableStyle

removeCustomTableStyle(styleName): boolean
This will remove a custom table style.
Parameters
- styleName: string
  A string of the name of the table.
Returns boolean
true if the style was removed.

Remarks
If the style is a built-in style or doesn't exist then this will do nothing and remove false.

Implementation of ISheetStyle.removeCustomTableStyle

resolveColor

resolveColor(str): AdjustedColor
Parses the color using the Theme being used by this style
Parameters
- str: string
Returns AdjustedColor
Implementation of ISheetStyle.resolveColor

schemeLookup

schemeLookup(): SchemeColorLookup
This is available for functions that want to resolve colors for the theme used specifically for this style.

Returns SchemeColorLookup
Implementation of ISheetStyle.schemeLookup

setCustomCellStyle

setCustomCellStyle(name, style, mergeIfExists?): INamedCellStyle
This will add or update a cell style.
Parameters
- name: string
- style: ICellStyle | Partial<{
      alignment: string | CellAlignmentValues | Partial<{
          horizontal: string | ((value, resolveShorthands?) => string);
          indent: string | number | ((value, resolveShorthands?) => string | number);
          justifyLastLine: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          overflow: string | ((value, resolveShorthands?) => string);
          readingDirection: string | ((value, resolveShorthands?) => string);
          relativeIndent: string | number | ((value, resolveShorthands?) => string | number);
          rotation: string | number | ((value, resolveShorthands?) => string | number);
          stacked: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          vertical: string | ((value, resolveShorthands?) => string);
      }> | ((value, resolveShorthands?) => string | CellAlignmentValues);
      border: string | CellBorderValues | Partial<{
          bottom: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          diagonalDown: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          diagonalUp: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          horizontal: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          left: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          right: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          top: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
          vertical: string | BorderStroke | Partial<{
              color: string | AdjustedColor | Partial<(...)> | ((value, resolveShorthands?) => ...);
              style: string | ((value, resolveShorthands?) => ...);
          }> | ((value, resolveShorthands?) => string | BorderStroke);
      }> | ((value, resolveShorthands?) => string | CellBorderValues);
      fill: string | AdjustedColor | SolidFillValues | GradientFillValues | PatternFillValues | NoneFillValues | Partial<{
          val: string | ((value, resolveShorthands?) => string);
          adjustments: any;
          asCSS: any;
          isEqual: any;
          isImmutable: any;
          toHSLA: any;
          toHex: any;
          toJSON: any;
          toRGBA: any;
          toString: any;
      } | {
          color: string | AdjustedColor | Partial<{
              val: (...) | (...);
              adjustments: any;
              asCSS: any;
              isEqual: any;
              isImmutable: any;
              toHSLA: any;
              toHex: any;
              toJSON: any;
              toRGBA: any;
              toString: any;
          }> | ((value, resolveShorthands?) => string | AdjustedColor);
          fillType: string | ((value, resolveShorthands?) => string);
      } | {
          angle: string | number | ((value, resolveShorthands?) => string | number);
          fillTo: string | Rectangle | Partial<{
              bottom: (...) | (...) | (...);
              left: (...) | (...) | (...);
              right: (...) | (...) | (...);
              top: (...) | (...) | (...);
          }> | ((value, resolveShorthands?) => string | Rectangle);
          fillType: string | ((value, resolveShorthands?) => string);
          gradientType: string | ((value, resolveShorthands?) => string);
          stops: string | GradientStop[] | (string | GradientStop | Partial<(...)> | ((value, resolveShorthands?) => ...))[] | ((value, resolveShorthands?) => string | (...)[]);
      } | {
          background: string | AdjustedColor | Partial<{
              val: (...) | (...);
              adjustments: any;
              asCSS: any;
              isEqual: any;
              isImmutable: any;
              toHSLA: any;
              toHex: any;
              toJSON: any;
              toRGBA: any;
              toString: any;
          }> | ((value, resolveShorthands?) => string | AdjustedColor);
          fillType: string | ((value, resolveShorthands?) => string);
          foreground: string | AdjustedColor | Partial<{
              val: (...) | (...);
              adjustments: any;
              asCSS: any;
              isEqual: any;
              isImmutable: any;
              toHSLA: any;
              toHex: any;
              toJSON: any;
              toRGBA: any;
              toString: any;
          }> | ((value, resolveShorthands?) => string | AdjustedColor);
          patternType: string | ((value, resolveShorthands?) => string);
      } | {
          fillType: string | ((value, resolveShorthands?) => string);
      }> | ((value, resolveShorthands?) => string | AdjustedColor | SolidFillValues | GradientFillValues | PatternFillValues | NoneFillValues);
      font: string | FontValues | Partial<{
          extend: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          family: string | ((value, resolveShorthands?) => string);
          familyFallbacks: string | string[] | (string | ((value, resolveShorthands?) => string))[] | ((value, resolveShorthands?) => string | string[]);
          fill: string | AdjustedColor | Partial<{
              val: string | ((value, resolveShorthands?) => ...);
              adjustments: any;
              asCSS: any;
              isEqual: any;
              isImmutable: any;
              toHSLA: any;
              toHex: any;
              toJSON: any;
              toRGBA: any;
              toString: any;
          }> | ((value, resolveShorthands?) => string | AdjustedColor);
          letterSpacing: string | number | ((value, resolveShorthands?) => string | number);
          outline: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          scheme: string | ((value, resolveShorthands?) => string);
          shadow: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          size: string | number | ((value, resolveShorthands?) => string | number);
          strike: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          style: string | ((value, resolveShorthands?) => string);
          underline: string | boolean | ((value, resolveShorthands?) => string | boolean);
          verticalAlign: string | ((value, resolveShorthands?) => string);
          weight: string | number | ((value, resolveShorthands?) => string | number);
      }> | ((value, resolveShorthands?) => string | FontValues);
      hidden: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
      iLevel: string | number | ((value, resolveShorthands?) => string | number);
      namedStyle: string | ((value, resolveShorthands?) => string);
      numberFormat: string | ((value, resolveShorthands?) => string);
      protection: string | CellProtectionValues | Partial<{
          formulaHidden: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
          locked: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
      }> | ((value, resolveShorthands?) => string | CellProtectionValues);
      quotePrefix: string | Partial<boolean> | ((value, resolveShorthands?) => string | boolean);
  }> | INamedCellStyleUpdater
- mergeIfExists: boolean = false
  If true then the style will be merged with the existing style otherwise is a replace.
Returns INamedCellStyle
the new style after any merges.
Remarks
Case insensitive; for duplicate detection purposes.

Default Value
```
false
```
Implementation of ISheetStyle.setCustomCellStyle

setCustomIndexedColors

setCustomIndexedColors(colors): void
Override the default indexed colors.
Parameters
- colors: readonly AdjustedColor[]
Returns void
Implementation of ISheetStyle.setCustomIndexedColors

setCustomTableStyle

setCustomTableStyle(name, tableStyleValues): ITableStyle
This will add or update a table style.
Parameters
- name: string
  A string of the name of the table.
- tableStyleValues: Partial<{
      fFirstTotalCell?: string | CellStyleValues | 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: ...;
                  style: ...;
              }>;
              diagonalDown: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              diagonalUp: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              horizontal: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              left: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              right: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              top: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              vertical: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
          }>;
          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<(...)>;
              fillType: string;
          } | {
              angle: string | number;
              fillTo: string | Rectangle | Partial<(...)>;
              fillType: string;
              gradientType: string;
              stops: string | (...)[] | (...)[];
          } | {
              background: string | AdjustedColor | Partial<(...)>;
              fillType: string;
              foreground: string | AdjustedColor | Partial<(...)>;
              patternType: string;
          } | {
              fillType: string;
          }>;
          font: string | FontValues | Partial<{
              extend: string | Partial<boolean>;
              family: string;
              familyFallbacks: string | string[];
              fill: string | AdjustedColor | Partial<{
                  val: ...;
                  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>;
      }>;
      firstColumn?: string | CellStyleValues | 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: ...;
                  style: ...;
              }>;
              diagonalDown: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              diagonalUp: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              horizontal: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              left: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              right: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              top: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              vertical: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
          }>;
          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<(...)>;
              fillType: string;
          } | {
              angle: string | number;
              fillTo: string | Rectangle | Partial<(...)>;
              fillType: string;
              gradientType: string;
              stops: string | (...)[] | (...)[];
          } | {
              background: string | AdjustedColor | Partial<(...)>;
              fillType: string;
              foreground: string | AdjustedColor | Partial<(...)>;
              patternType: string;
          } | {
              fillType: string;
          }>;
          font: string | FontValues | Partial<{
              extend: string | Partial<boolean>;
              family: string;
              familyFallbacks: string | string[];
              fill: string | AdjustedColor | Partial<{
                  val: ...;
                  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>;
      }>;
      firstColumnStripe?: string | SizeCellStyleValues | 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: ...;
                  style: ...;
              }>;
              diagonalDown: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              diagonalUp: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              horizontal: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              left: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              right: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              top: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              vertical: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
          }>;
          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<(...)>;
              fillType: string;
          } | {
              angle: string | number;
              fillTo: string | Rectangle | Partial<(...)>;
              fillType: string;
              gradientType: string;
              stops: string | (...)[] | (...)[];
          } | {
              background: string | AdjustedColor | Partial<(...)>;
              fillType: string;
              foreground: string | AdjustedColor | Partial<(...)>;
              patternType: string;
          } | {
              fillType: string;
          }>;
          font: string | FontValues | Partial<{
              extend: string | Partial<boolean>;
              family: string;
              familyFallbacks: string | string[];
              fill: string | AdjustedColor | Partial<{
                  val: ...;
                  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>;
          size?: string | number;
      }>;
      firstHeaderCell?: string | CellStyleValues | 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: ...;
                  style: ...;
              }>;
              diagonalDown: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              diagonalUp: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              horizontal: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              left: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              right: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              top: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              vertical: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
          }>;
          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<(...)>;
              fillType: string;
          } | {
              angle: string | number;
              fillTo: string | Rectangle | Partial<(...)>;
              fillType: string;
              gradientType: string;
              stops: string | (...)[] | (...)[];
          } | {
              background: string | AdjustedColor | Partial<(...)>;
              fillType: string;
              foreground: string | AdjustedColor | Partial<(...)>;
              patternType: string;
          } | {
              fillType: string;
          }>;
          font: string | FontValues | Partial<{
              extend: string | Partial<boolean>;
              family: string;
              familyFallbacks: string | string[];
              fill: string | AdjustedColor | Partial<{
                  val: ...;
                  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>;
      }>;
      firstRowStripe?: string | SizeCellStyleValues | 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: ...;
                  style: ...;
              }>;
              diagonalDown: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              diagonalUp: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              horizontal: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              left: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              right: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              top: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              vertical: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
          }>;
          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<(...)>;
              fillType: string;
          } | {
              angle: string | number;
              fillTo: string | Rectangle | Partial<(...)>;
              fillType: string;
              gradientType: string;
              stops: string | (...)[] | (...)[];
          } | {
              background: string | AdjustedColor | Partial<(...)>;
              fillType: string;
              foreground: string | AdjustedColor | Partial<(...)>;
              patternType: string;
          } | {
              fillType: string;
          }>;
          font: string | FontValues | Partial<{
              extend: string | Partial<boolean>;
              family: string;
              familyFallbacks: string | string[];
              fill: string | AdjustedColor | Partial<{
                  val: ...;
                  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>;
          size?: string | number;
      }>;
      headerRow?: string | CellStyleValues | 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: ...;
                  style: ...;
              }>;
              diagonalDown: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              diagonalUp: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              horizontal: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              left: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              right: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              top: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              vertical: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
          }>;
          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<(...)>;
              fillType: string;
          } | {
              angle: string | number;
              fillTo: string | Rectangle | Partial<(...)>;
              fillType: string;
              gradientType: string;
              stops: string | (...)[] | (...)[];
          } | {
              background: string | AdjustedColor | Partial<(...)>;
              fillType: string;
              foreground: string | AdjustedColor | Partial<(...)>;
              patternType: string;
          } | {
              fillType: string;
          }>;
          font: string | FontValues | Partial<{
              extend: string | Partial<boolean>;
              family: string;
              familyFallbacks: string | string[];
              fill: string | AdjustedColor | Partial<{
                  val: ...;
                  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>;
      }>;
      lastColumn?: string | CellStyleValues | 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: ...;
                  style: ...;
              }>;
              diagonalDown: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              diagonalUp: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              horizontal: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              left: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              right: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              top: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              vertical: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
          }>;
          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<(...)>;
              fillType: string;
          } | {
              angle: string | number;
              fillTo: string | Rectangle | Partial<(...)>;
              fillType: string;
              gradientType: string;
              stops: string | (...)[] | (...)[];
          } | {
              background: string | AdjustedColor | Partial<(...)>;
              fillType: string;
              foreground: string | AdjustedColor | Partial<(...)>;
              patternType: string;
          } | {
              fillType: string;
          }>;
          font: string | FontValues | Partial<{
              extend: string | Partial<boolean>;
              family: string;
              familyFallbacks: string | string[];
              fill: string | AdjustedColor | Partial<{
                  val: ...;
                  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>;
      }>;
      lastHeaderCell?: string | CellStyleValues | 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: ...;
                  style: ...;
              }>;
              diagonalDown: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              diagonalUp: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              horizontal: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              left: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              right: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              top: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              vertical: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
          }>;
          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<(...)>;
              fillType: string;
          } | {
              angle: string | number;
              fillTo: string | Rectangle | Partial<(...)>;
              fillType: string;
              gradientType: string;
              stops: string | (...)[] | (...)[];
          } | {
              background: string | AdjustedColor | Partial<(...)>;
              fillType: string;
              foreground: string | AdjustedColor | Partial<(...)>;
              patternType: string;
          } | {
              fillType: string;
          }>;
          font: string | FontValues | Partial<{
              extend: string | Partial<boolean>;
              family: string;
              familyFallbacks: string | string[];
              fill: string | AdjustedColor | Partial<{
                  val: ...;
                  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>;
      }>;
      lastTotalCell?: string | CellStyleValues | 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: ...;
                  style: ...;
              }>;
              diagonalDown: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              diagonalUp: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              horizontal: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              left: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              right: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              top: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              vertical: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
          }>;
          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<(...)>;
              fillType: string;
          } | {
              angle: string | number;
              fillTo: string | Rectangle | Partial<(...)>;
              fillType: string;
              gradientType: string;
              stops: string | (...)[] | (...)[];
          } | {
              background: string | AdjustedColor | Partial<(...)>;
              fillType: string;
              foreground: string | AdjustedColor | Partial<(...)>;
              patternType: string;
          } | {
              fillType: string;
          }>;
          font: string | FontValues | Partial<{
              extend: string | Partial<boolean>;
              family: string;
              familyFallbacks: string | string[];
              fill: string | AdjustedColor | Partial<{
                  val: ...;
                  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>;
      }>;
      name?: string;
      pivot?: string | Partial<boolean>;
      secondColumnStripe?: string | SizeCellStyleValues | 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: ...;
                  style: ...;
              }>;
              diagonalDown: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              diagonalUp: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              horizontal: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              left: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              right: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              top: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              vertical: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
          }>;
          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<(...)>;
              fillType: string;
          } | {
              angle: string | number;
              fillTo: string | Rectangle | Partial<(...)>;
              fillType: string;
              gradientType: string;
              stops: string | (...)[] | (...)[];
          } | {
              background: string | AdjustedColor | Partial<(...)>;
              fillType: string;
              foreground: string | AdjustedColor | Partial<(...)>;
              patternType: string;
          } | {
              fillType: string;
          }>;
          font: string | FontValues | Partial<{
              extend: string | Partial<boolean>;
              family: string;
              familyFallbacks: string | string[];
              fill: string | AdjustedColor | Partial<{
                  val: ...;
                  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>;
          size?: string | number;
      }>;
      secondRowStripe?: string | SizeCellStyleValues | 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: ...;
                  style: ...;
              }>;
              diagonalDown: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              diagonalUp: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              horizontal: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              left: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              right: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              top: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              vertical: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
          }>;
          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<(...)>;
              fillType: string;
          } | {
              angle: string | number;
              fillTo: string | Rectangle | Partial<(...)>;
              fillType: string;
              gradientType: string;
              stops: string | (...)[] | (...)[];
          } | {
              background: string | AdjustedColor | Partial<(...)>;
              fillType: string;
              foreground: string | AdjustedColor | Partial<(...)>;
              patternType: string;
          } | {
              fillType: string;
          }>;
          font: string | FontValues | Partial<{
              extend: string | Partial<boolean>;
              family: string;
              familyFallbacks: string | string[];
              fill: string | AdjustedColor | Partial<{
                  val: ...;
                  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>;
          size?: string | number;
      }>;
      table?: string | Partial<boolean>;
      totalRow?: string | CellStyleValues | 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: ...;
                  style: ...;
              }>;
              diagonalDown: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              diagonalUp: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              horizontal: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              left: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              right: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              top: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              vertical: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
          }>;
          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<(...)>;
              fillType: string;
          } | {
              angle: string | number;
              fillTo: string | Rectangle | Partial<(...)>;
              fillType: string;
              gradientType: string;
              stops: string | (...)[] | (...)[];
          } | {
              background: string | AdjustedColor | Partial<(...)>;
              fillType: string;
              foreground: string | AdjustedColor | Partial<(...)>;
              patternType: string;
          } | {
              fillType: string;
          }>;
          font: string | FontValues | Partial<{
              extend: string | Partial<boolean>;
              family: string;
              familyFallbacks: string | string[];
              fill: string | AdjustedColor | Partial<{
                  val: ...;
                  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>;
      }>;
      wholeTable?: string | CellStyleValues | 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: ...;
                  style: ...;
              }>;
              diagonalDown: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              diagonalUp: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              horizontal: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              left: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              right: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              top: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
              vertical: string | BorderStroke | Partial<{
                  color: ...;
                  style: ...;
              }>;
          }>;
          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<(...)>;
              fillType: string;
          } | {
              angle: string | number;
              fillTo: string | Rectangle | Partial<(...)>;
              fillType: string;
              gradientType: string;
              stops: string | (...)[] | (...)[];
          } | {
              background: string | AdjustedColor | Partial<(...)>;
              fillType: string;
              foreground: string | AdjustedColor | Partial<(...)>;
              patternType: string;
          } | {
              fillType: string;
          }>;
          font: string | FontValues | Partial<{
              extend: string | Partial<boolean>;
              family: string;
              familyFallbacks: string | string[];
              fill: string | AdjustedColor | Partial<{
                  val: ...;
                  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>;
      }>;
  }>
  the values to set for the table style.
Returns ITableStyle
Remarks
Case insensitive; for duplicate detection purposes.

Implementation of ISheetStyle.setCustomTableStyle

setDefaultFontSize

setDefaultFontSize(fontSize): void
Set the default fontSize. Note - A theme does NOT contain this.
Parameters
- fontSize: number
  The new default font size.
Returns void
Implementation of ISheetStyle.setDefaultFontSize

setDefaultTableStyle

setDefaultTableStyle(styleName): boolean
Set the default table style to use if a table is created without specifying a style.
Parameters
- styleName: string
  A string of the name of the table
Returns boolean
Remarks
The style must exist or the defaultStyle will be set to 'TableStyleMedium2'.

Implementation of ISheetStyle.setDefaultTableStyle

setTheme

setTheme(docTheme): void
Will fire a change event
Parameters
- docTheme: IDocTheme
Returns void
Implementation of ISheetStyle.setTheme

validateStyleName

validateStyleName(name, checkDuplicates?): void
Checks the current name to see if this is a valid sheetName.
Parameters
- name: string
- checkDuplicates: boolean = false
Returns void
Implementation of ISheetStyle.validateStyleName

Class SheetStyle

See

Implements

Index

Constructors

Methods

Constructors

constructor

Parameters

Returns SheetStyle

Methods

_releaseSharedState

Parameters

Returns void

_releaseSharedStyles

Parameters

Returns void

addListener

Parameters

Returns RemoveListener

addRecentColor

Parameters

Returns readonly AdjustedColor[]

addSharedStyleRef

Parameters

Returns ICellStyle

Remarks

Style

beginPersist

Returns IStylesPersistScope

See

clearRecentColors

Returns void

createTemporaryStyle

Parameters

Returns ICellStyle

getBuiltInCellStyle

Parameters

Returns INamedCellStyle

Remarks

See

getBuiltInTableStyle

Parameters

Returns ITableStyle

Remarks

See

getCustomCellStyles

Returns INamedCellStyle[]

Remarks

getCustomIndexedColors

Returns readonly AdjustedColor[]

getCustomTableStyles

Returns ITableStyle[]

Remarks

getDefaultFontSize

Returns number

getDefaultTableStyle

Returns ITableStyle

See

getIndexedColors

Returns readonly AdjustedColor[]

Remarks

getNamedCellStyle

Parameters

Returns INamedCellStyle

Remarks

getNormalStyle

Returns INamedCellStyle

getSharedStyle

Parameters

Returns ICellStyle

Adjustment

Original

Ref

getTableStyle

Parameters

Returns ITableStyle

Remarks

getTheme

Returns IDocTheme