Namespace: Report

GC.Spread.Report

Table of contents

Classes

• ReportSheet
• TemplateSheet

Interfaces

• IColumnLayoutSetting
• IConditionRuleCellType
• IConditionRuleDataColumnType
• IConditionRuleFormulaType
• IConditionRuleParameterType
• IConditionRuleValueType
• IDataCell
• IDataCellBase
• IDataColumn
• IField
• IFilter
• IFilterConditionAndRelationType
• IFilterConditionOrRelationType
• IGroupBin
• IPaginationSetting
• IParameterChangedArgs
• IReportOptions
• IRowLayoutSetting
• ITemplateCellCommonSetting
• ITemplateOptions
• IWriteBackRule

Type aliases

• Binding
• CellAddress
• ConditionRule
• ConditionRuleOperator
• DataEntrySetting
• FilterCondition
• FilterConditionFormulaRule
• Formula
• GroupCell
• InitParametersUIFunctionType
• LayoutSetting
• ListCell
• OnChangeFunctionType
• PaginationOrder
• RenderMode
• SheetNameGenerator
• SortOption
• SpillDirection
• StaticCell
• SummaryAggregate
• SummaryCell
• TemplateCell

Type aliases

Binding

Ƭ Binding: string

---

CellAddress

Ƭ CellAddress: string

---

ConditionRule

Ƭ ConditionRule: { column: string ; operator: ConditionRuleOperator } & IConditionRuleValueType | IConditionRuleCellType | IConditionRuleDataColumnType | IConditionRuleParameterType | IConditionRuleFormulaType

---

ConditionRuleOperator

Ƭ ConditionRuleOperator: "Equal" | "NotEqual" | "GreaterThanOrEqual" | "GreaterThan" | "LessThanOrEqual" | "LessThan" | "StartWith" | "NotStartWith" | "EndWith" | "NotEndWith" | "Contains" | "NotContains" | "In" | "NotIn"

---

DataEntrySetting

Ƭ DataEntrySetting: IWriteBackRule[]

---

FilterCondition

Ƭ FilterCondition: ConditionRule | FilterConditionFormulaRule | IFilterConditionAndRelationType | IFilterConditionOrRelationType

---

FilterConditionFormulaRule

Ƭ FilterConditionFormulaRule: Object

Type declaration

Name	Type
formula	string

---

Formula

Ƭ Formula: string

---

GroupCell

Ƭ GroupCell: IDataCellBase & { bins?: IGroupBin[] ; formula?: Formula ; type: "Group" }

---

InitParametersUIFunctionType

Ƭ InitParametersUIFunctionType: (sheet: Worksheet) => void

Type declaration

▸ (sheet): void

description The callback when parameterUI sheet is rendering.

Parameters

Name	Type	Description
sheet	Worksheet	The init parametersUI sheet, users can update the parameterUI sheet here.

Returns

void

---

LayoutSetting

Ƭ LayoutSetting: IRowLayoutSetting | IColumnLayoutSetting

---

ListCell

Ƭ ListCell: IDataCellBase & { spillMode?: "Insert" | "Overwrite" ; type: "List" }

---

OnChangeFunctionType

Ƭ OnChangeFunctionType: (sheet: ReportSheet, changedArgs: IParameterChangedArgs) => void

Type declaration

▸ (sheet, changedArgs): void

description The callback when the parameterUI value changed.

Parameters

Name	Type	Description
sheet	ReportSheet	The parametersUI bound reportSheet.
changedArgs	IParameterChangedArgs	The changed parameter values.

Returns

void

---

PaginationOrder

Ƭ PaginationOrder: "DownThenOver" | "OverThenDown"

---

RenderMode

Ƭ RenderMode: "Design" | "PaginatedPreview" | "Preview"

---

SheetNameGenerator

Ƭ SheetNameGenerator: (pageIndex: number) => string

Type declaration

▸ (pageIndex): string

Parameters

Name	Type
pageIndex	number

Returns

string

---

SortOption

Ƭ SortOption: { asc: string } | { desc: string } & { list?: string[] }

---

SpillDirection

Ƭ SpillDirection: "Horizontal" | "Vertical" | "None"

---

StaticCell

Ƭ StaticCell: Object

Type declaration

Name	Type
autoExpand?	"Both" | "Horizontal" | "Vertical" | "None"
pin?	"None" | "Row" | "Column" | "Both"
showCollapseButton?	boolean
type	"Static"

---

SummaryAggregate

Ƭ SummaryAggregate: "Sum" | "Avg" | "Max" | "Min" | "Count"

---

SummaryCell

Ƭ SummaryCell: IDataCellBase & { aggregate: SummaryAggregate ; type: "Summary" }

---

TemplateCell

Ƭ TemplateCell: ListCell | GroupCell | SummaryCell | StaticCell & ITemplateCellCommonSetting