Search results

PivotActionInfo API in JavaScript (ES5) Pivotfieldlist API control

Defines the unique information of the current UI action performed such as sorting, filtering, drill, editing, report manipulation, summarization, etc.

Properties

calculatedFieldInfo

ICalculatedFieldSettings

Defines the selected calculated field’s settings that used to create new calculated fields from the bound data source or using simple formula with basic arithmetic operators in the pivot table.

conditionalFormattingInfo

IConditionalFormatSettings[]

Defines the current condition formatting settings that used to change the appearance of the pivot table value cells with different style properties such as background color, font color, font family, and font size based on specific conditions.

drillInfo

IDrillOptions

Defines the selected field’s drilled members settings that used to display the headers to be either expanded or collapsed in the pivot table.

editInfo

PivotEditInfo

Defines the edited information such as current edit type, action and its edited record information such as edited data, previous data and index positions of before editing performed.

exportInfo

PivotExportInfo

Defines the export information such as current export type and its additional settings such as page size, orientation, header, footer, etc.

filterInfo

IFilter

Defines the selected field’s filter settings with either selective or conditional-based filter members that used to be displayed in the pivot table.

numberFormattingInfo

IFormatSettings[]

Defines the current format settings that used to display the values with specific format that used to be displayed in the pivot table.

reportName

string | PivotReportInfo

Defines the report name that used to create, load, rename save and save as current report.

sortInfo

ISort

Defines the selected field’s sort settings to order their members either in ascending or descending that used to be displayed in the pivot table.

toolbarInfo

PivotToolbarInfo

Defines the current toolbar information such as current display options and its settings such as chart settings, grid settings, etc.

valueSortInfo

IValueSortSettings

Defines the current value sort settings from current pivot report.