Interface: IGroupColumnOptions

Sheets.TableSheet.IGroupColumnOptions

Hierarchy

• IGroupColumnOptions

  ↳ IGroupByOptions

  ↳ IGroupSummaryFieldOptions

  ↳ IGroupSummarySliceFieldOptions

Table of contents

Properties

• allowFilterByList
• allowFilterByValue
• allowSort
• caption
• conditionalFormats
• headerFit
• headerStyle
• showEmptyAs
• showNullAs
• style
• validator
• width

Properties

allowFilterByList

• Optional allowFilterByList: boolean

Whether show filter by list after opening filer dialog. If allowSort, allowFilterByValue and allowFilterByList are all false, not show the filter button in this column.

allowFilterByValue

• Optional allowFilterByValue: boolean

Whether show filter by value after opening filer dialog.

allowSort

• Optional allowSort: boolean

Whether show sort after opening filer dialog.

caption

• Optional caption: string

conditionalFormats

• Optional conditionalFormats: (AverageRuleOptions | CellValueRuleOptions | DataBarRuleOptions | DateOccurringRuleOptions | DuplicateRuleOptions | FormulaRuleOptions | SpecificTextRuleOptions | Top10RuleOptions | UniqueRuleOptions | TwoScaleRuleOptions | ThreeScaleRuleOptions | IconSetRuleOptions | SparklineRuleOptions)[]

headerFit

• Optional headerFit: "normal" | "vertical" | "stack"

the header fit mode, default is normal

headerStyle

• Optional headerStyle: HeaderStyleOptions

the column header style

showEmptyAs

• Optional showEmptyAs: string

The display text for empty string values.

showNullAs

• Optional showNullAs: string

The display text for null or undefined values.

style

• Optional style: StyleOptions

validator

• Optional validator: DateValidatorOptions | FormulaListValidatorOptions | FormulaValidatorOptions | NumberValidatorOptions | TimeValidatorOptions | TextLengthValidatorOptions | ListValidatorOptions

width

• Optional width: number