Search results

PivotViewComponent

ej-pivotview represents the Angular PivotView Component.

<ej-pivotview></ej-pivotview>

Properties

allowCalculatedField

boolean

It allows to enable calculated field in PivotView.

allowConditionalFormatting

boolean

It allows to enable Conditional Formatting in PivotView.

allowDeferLayoutUpdate

boolean

If allowDeferLayoutUpdate is set to true, then it will enable defer layout update to pivotview.

allowDrillThrough

boolean

If allowDrillThrough set to true, then you can view the raw items that are used to create a specified value cell in the pivot grid.

allowExcelExport

boolean

If allowExcelExport is set to true, then it will allow the user to export pivotview to Excel file.

allowNumberFormatting

boolean

It allows to enable number formatting popup in pivot table.

allowPdfExport

boolean

If allowPdfExport is set to true, then it will allow the user to export pivotview to Pdf file.

cellTemplate

any

The template option which is used to render the pivot cells on the pivotview. Here, the template accepts either the string or HTMLElement as template design and then the parsed design is displayed onto the pivot cells.

chartSettings

ChartSettingsModel

Configures the features settings of Pivot widget.

dataSourceSettings

DataSourceSettingsModel

It allows the user to configure the pivot report as per the user need.

displayOption

DisplayOptionModel

Configures the settings of displayOption.

editSettings

CellEditSettingsModel

Configures the edit behavior of the Pivot Grid. mode:‘Normal’, allowEditOnDblClick: true, showConfirmDialog: true, showDeleteConfirmDialog: false }

enablePersistence

boolean

Enable or disable persisting component’s state between page reloads.

enableRtl

boolean

Enable or disable rendering component in right to left direction.

enableValueSorting

boolean

It allows to enable Value Sorting in PivotView.

enableVirtualization

boolean

If enableVirtualization set to true, then the Grid will render only the rows and the columns visible within the view-port and load subsequent rows and columns on vertical scrolling. This helps to load large dataset in Pivot Grid.

gridSettings

GridSettingsModel

Configures the features settings of Pivot widget.

groupingBarSettings

GroupingBarSettingsModel

Configures the settings of GroupingBar.

height

string | number

Pivot widget. (Note change all occurrences)

hyperlinkSettings

HyperlinkSettingsModel

Configures the settings of hyperlink settings.

loadOnDemandInMemberEditor

boolean

If loadOnDemandInMemberEditor is set to false, then it will load all the level members from cube when doing member filtering initially. Note: This may cause performance lag based on members count that fetch from cube while the member editor pop-up opens for the first time alone.

locale

string

Overrides the global culture and localization value for this component. Default global culture is ‘en-US’.

maxNodeLimitInMemberEditor

number

It allows to set the maximum number of nodes to be displayed in the member editor.

maxRowsInDrillThrough

number

It allows to set the maximum number of rows to be return while drill through.

pivotValues

IPivotValues

It holds the pivot engine data which renders the Pivot widget.

showFieldList

boolean

It allows to render pivotfieldlist.

showGroupingBar

boolean

Enables the display of GroupingBar allowing you to filter, sort, and remove fields obtained from the datasource.

showToolbar

boolean

It allows to enable/disable toolbar in pivot table.

showTooltip

boolean

Allows to display the Tooltip on hovering value cells in pivot grid.

showValuesButton

boolean

It shows a common button for value fields to move together in column or row axis

spinnerTemplate

string

It allows to customize the spinner.

toolbar

string[]

It allows to set toolbar items in pivot table.

width

string | number

It allows to set the width of Pivot widget.

Methods

addInternalEvents

Register the internal events.

Returns void

bindTriggerEvents

De-Register the internal events.

Returns void

chartExport

Export method for the chart.

Parameter Type Description
type ExportType Defines the export type.
fileName string Defines file name of export document.
orientation (optional) PdfPageOrientation Defines the page orientation on pdf export(0 for Portrait mode, 1 for Landscape mode).
width (optional) number Defines width of the export document.
height (optional) number Defines height of the export document.

Returns void

copy

Copy the selected rows or cells data into clipboard.

Parameter Type Description
withHeader (optional) boolean Specifies whether the column header text needs to be copied along with rows or cells.

Returns void

createCalculatedFieldDialog

Method to open calculated field dialog

Returns void

csvExport

Export PivotGrid data to CSV file.

Parameter Type Description
excelExportProperties (optional) ExcelExportProperties Defines the export properties of the Grid.
isMultipleExport (optional) boolean Define to enable multiple export.
workbook (optional) any Defines the Workbook if multiple export is enabled.
isBlob (optional) boolean If ‘isBlob’ set to true, then it will be returned as blob data.

Returns void

destroy

To destroy the PivotView elements.

Returns void

excelExport

Export Pivot widget data to Excel file(.xlsx).

Parameter Type Description
excelExportProperties (optional) ExcelExportProperties Defines the export properties of the Grid.
isMultipleExport (optional) boolean Define to enable multiple export.
workbook (optional) any Defines the Workbook if multiple export is enabled.
isBlob (optional) boolean If ‘isBlob’ set to true, then it will be returned as blob data.

Returns void

getModuleName

It returns the Module name.

Returns string

getPersistData

Get the Pivot widget properties to be maintained in the persisted state.

Returns string

loadPersistData

Loads pivot Layout

Parameter Type Description
persistData string Specifies the persist data to be loaded to pivot.

Returns void

onPropertyChanged

Called internally if any of the property value changed.

Returns void

pdfExport

Export Pivot widget data to PDF document.

Returns void

printChart

Print method for the chart.

Returns void

refresh

Refreshes the Pivot Table for blazor layoutRefresh is called for other base refresh is called

Returns void

removeInternalEvents

De-Register the internal events.

Returns void

render

Initialize the control rendering

Returns void

renderPivotGrid

Render the UI section of PivotView.

Returns void

requiredModules

To provide the array of modules needed for control rendering

Returns ModuleDeclaration[]

showConditionalFormattingDialog

Method to open conditional formatting dialog

Returns void

updateDataSource

Updates the PivotEngine using dataSource from Pivot View component.

Returns void

Events

aggregateCellInfo

EmitType<AggregateEventArgs>

This allows to change the cell value.

beforeExport

EmitType<BeforeExportEventArgs>

This allows to set properties for exporting.

beginDrillThrough

EmitType<BeginDrillThroughEventArgs>

Triggers when value cell is clicked in the Pivot widget on Editing.

cellClick

EmitType<CellClickEventArgs>

Triggers when cell is clicked in the Pivot widget.

cellSelected

EmitType<PivotCellSelectedEventArgs>

Triggers when cell got selected in Pivot widget.

cellSelecting

EmitType<PivotCellSelectedEventArgs>

Triggers before cell got selected in Pivot widget.

chartSeriesCreated

EmitType<ChartSeriesCreatedEventArgs>

Triggers when chart series are created.

conditionalFormatting

EmitType<IConditionalFormatSettings>

This allows to do changes before conditional formatting apply.

created

EmitType<Object>

Triggers when data source is created in the Pivot View.

dataBound

EmitType<Object>

Triggers when data source is populated in the Pivot View.

destroyed

EmitType<Object>

Triggers when data source is destroyed in the Pivot View.

drill

EmitType<DrillArgs>

Triggers before drill down/ drill up Pivot widget.

drillThrough

EmitType<DrillThroughEventArgs>

Triggers when value cell is clicked in the Pivot widget on Drill-Through.

enginePopulated

EmitType<EnginePopulatedEventArgs>

Triggers after the pivot engine populated and allows to customize the pivot widget.

enginePopulating

EmitType<EnginePopulatingEventArgs>

Triggers before the pivot engine starts to populate and allows to customize the pivot datasource settings.

fetchReport

EmitType<FetchReportArgs>

This allows to fetch the report names from storage.

fieldListRefreshed

EmitType<FieldListRefreshedEventArgs>

This allows to identify each field list update.

hyperlinkCellClick

EmitType<HyperCellClickEventArgs>

Triggers when hyperlink cell is clicked in the Pivot widget.

load

EmitType<LoadEventArgs>

This allows any customization of PivotView properties on initial rendering.

loadReport

EmitType<LoadReportArgs>

This allows to load the report from storage.

newReport

EmitType<NewReportArgs>

This allows to set the new report.

onFieldDropped

EmitType<FieldDroppedEventArgs>

Triggers when a field getting dropped into any axis.

onPdfCellRender

EmitType<PdfCellRenderArgs>

This allows any customization of Pivot cell style while PDF exporting.

removeReport

EmitType<RemoveReportArgs>

This allows to remove the report from storage.

renameReport

EmitType<RenameReportArgs>

This allows to rename the report.

saveReport

EmitType<SaveReportArgs>

This allows to save the report in any storage.

toolbarClick

EmitType<ClickEventArgs>

This allows to change the toolbar items.

toolbarRender

EmitType<ToolbarArgs>

This allows to change the toolbar items.