[]
Sheets.TableSheet.IGroupByOptions
↳ IGroupByOptions
• 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.
IGroupColumnOptions.allowFilterByList
• Optional allowFilterByValue: boolean
Whether show filter by value after opening filer dialog.
IGroupColumnOptions.allowFilterByValue
• Optional allowSort: boolean
Whether show sort after opening filer dialog.
• Optional caption: string
• Optional conditionalFormats: (AverageRuleOptions | CellValueRuleOptions | DataBarRuleOptions | DateOccurringRuleOptions | DuplicateRuleOptions | FormulaRuleOptions | SpecificTextRuleOptions | Top10RuleOptions | UniqueRuleOptions | TwoScaleRuleOptions | ThreeScaleRuleOptions | IconSetRuleOptions)[]
IGroupColumnOptions.conditionalFormats
• field: string
• Optional headerFit: "normal" | "vertical" | "stack"
the header fit mode, default is normal
• Optional headerStyle: HeaderStyleOptions
the column header style
IGroupColumnOptions.headerStyle
• Optional spacing: IGroupSpacingOptions
• Optional style: StyleOptions
• Optional summaryFields: IGroupSummaryFieldOptions[]
• Optional validator: DateValidatorOptions | FormulaListValidatorOptions | FormulaValidatorOptions | NumberValidatorOptions | TimeValidatorOptions | TextLengthValidatorOptions | ListValidatorOptions
• Optional width: number