[]
        
(Showing Draft Content)

GC.Spread.Sheets.TableSheet.IGroupByOptions

Interface: IGroupByOptions

Sheets.TableSheet.IGroupByOptions

Hierarchy

Table of contents

Properties

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.

Inherited from

IGroupColumnOptions.allowFilterByList


allowFilterByValue

Optional allowFilterByValue: boolean

Whether show filter by value after opening filer dialog.

Inherited from

IGroupColumnOptions.allowFilterByValue


allowSort

Optional allowSort: boolean

Whether show sort after opening filer dialog.

Inherited from

IGroupColumnOptions.allowSort


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