Interface: IGroupByOptions

Sheets.TableSheet.IGroupByOptions

Hierarchy

• IGroupColumnOptions

  ↳ IGroupByOptions

Table of contents

Properties

• caption
• conditionalFormats
• field
• headerFit
• headerStyle
• spacing
• style
• summaryFields
• validator
• width

Properties

caption

• Optional caption: string

Inherited from

IGroupColumnOptions.caption

conditionalFormats

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

Inherited from

IGroupColumnOptions.conditionalFormats

field

• field: string

headerFit

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

the header fit mode, default is normal

Inherited from

IGroupColumnOptions.headerFit

headerStyle

• Optional headerStyle: HeaderStyleOptions

the column header style

Inherited from

IGroupColumnOptions.headerStyle

spacing

• Optional spacing: IGroupSpacingOptions

style

• Optional style: StyleOptions

Inherited from

IGroupColumnOptions.style

summaryFields

• Optional summaryFields: IGroupSummaryFieldOptions[]

validator

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

Inherited from

IGroupColumnOptions.validator

width

• Optional width: number

Inherited from

IGroupColumnOptions.width