Namespace: Report

GC.Spread.Report

Table of contents

Classes

• ReportSheet
• TemplateSheet

Interfaces

• IColumnLayoutSetting
• IConditionRuleCellType
• IConditionRuleDataColumnType
• IConditionRuleFormulaType
• IConditionRuleParameterType
• IConditionRuleValueType
• IDataCell
• IDataCellBase
• IDataColumn
• IEntityFieldInfo
• IFailedRecord
• IField
• IFilter
• IFilterConditionAndRelationType
• IFilterConditionOrRelationType
• IGroupBin
• IPaginationSetting
• IParameterChangedArgs
• IRecord
• IReportOptions
• IReportSheetDataChangedEventArgs
• IReportSheetDataChangingEventArgs
• IReportSheetRecordsSubmittedEventArgs
• IReportSheetRecordsSubmittingEventArgs
• IRowLayoutSetting
• ITemplateCellCommonSetting
• ITemplateOptions
• IWriteBackRule

Type aliases

• Binding
• CellAddress
• Change
• ChartCell
• ConditionRule
• ConditionRuleOperator
• DataEntrySetting
• DataType
• FieldState
• 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

---

Change

Ƭ Change: Object

property {GC.Spread.Report.IRecord[]} records - 更新的和插入的记录。

property {GC.Spread.Report.IRecord[]} deleteRecords - 删除的记录。

property rule - 报告表数据条目写回规则。

Type declaration

Name	Type	Description
deleteRecords	IRecord[]	删除的记录。
records	IRecord[]	更新的和插入的记录。
rule	IWriteBackRule	报告表数据条目写回规则。

---

ChartCell

Ƭ ChartCell: Object

Type declaration

Name	Type
chartPreviewVisible?	boolean
dataChartName	string
type	"Chart"

---

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

---

DataType

Ƭ DataType: number | string | Date | boolean

---

FieldState

Ƭ FieldState: "normal" | "new" | "updated" | "deleted"

---

FilterCondition

Ƭ FilterCondition: ConditionRule | FilterConditionFormulaRule | IFilterConditionAndRelationType | IFilterConditionOrRelationType

---

FilterConditionFormulaRule

Ƭ FilterConditionFormulaRule: Object

Type declaration

Name	Type
formula	string

---

Formula

Ƭ Formula: string

---

GroupCell

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

---

InitParametersUIFunctionType

Ƭ InitParametersUIFunctionType: (sheet: Worksheet) => void

Type declaration

▸ (sheet): void

description 当参数面板渲染时回调。

Parameters

Name	Type	Description
sheet	Worksheet	初始化参数面板，用户可以在此更新参数面板。

Returns

void

---

LayoutSetting

Ƭ LayoutSetting: IRowLayoutSetting | IColumnLayoutSetting

---

ListCell

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

---

OnChangeFunctionType

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

Type declaration

▸ (sheet, changedArgs): void

description 当参数面板值更改时回调。

Parameters

Name	Type	Description
sheet	ReportSheet	参数面板绑定的报告表。
changedArgs	IParameterChangedArgs	更改的参数值。

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"
initialExpansionState?	"Expanded" | "Collapsed"
pin?	"None" | "Row" | "Column" | "Both"
preserveFormulaInExport?	boolean
showCollapseButton?	boolean
type	"Static"

---

SummaryAggregate

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

---

SummaryCell

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

---

TemplateCell

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