[]
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