PivotTableCommand Class

Represents a command for the IPivotTable.

Inheritance

object

Command

PivotTableCommand

ChangeLayoutPivotTableCommand

PivotTableOptionsCommand

Implements

IDisposable

Namespace: GrapeCity.Spreadsheet.Commands.PivotTables

Assembly: GrapeCity.Spreadsheet.dll

Syntax

public abstract class PivotTableCommand : Command, IDisposable

Public MustInherit Class PivotTableCommand
    Inherits Command
    Implements IDisposable

Methods

Name	Description
AddField(IPivotTable, int, PivotFieldOrientation, int)	Add a pivot data field to a PivotTable report or PivotChart report.
AddPivotStyle(IPivotTable, Dictionary<TableStyleElementType, Tuple<StyleFormat, int>>, string, bool, string, bool)	Adds a new style for specified IPivotTable object.
ApplyPivotStyle(IPivotTable, string)	Applies the pivot style of specified IPivotTable object.
AutoGroup(IPivotTable, int)	Automatically groups the pivot fields in a PivotTable.
ChangeField(IPivotTable, int, PivotFieldOrientation, int)	Change a fields of PivotTable report or PivotChart report.
ClearFilters(IPivotTable, int, IPivotFilter)	Initializes a new command to clear filter the IPivotTable by a specific IPivotField.
CreateFieldSettings(IPivotTable, IPivotField, string, ConsolidationFunction, PivotFieldCalculation, NumberFormat, int?, int?)	Initializes a new command to modify GrapeCity.Spreadsheet.Commands.PivotTables.PivotTableCommand.PivotTable value field settings.
CreateFieldSettings(IPivotTable, int, string, ConsolidationFunction?, bool?, LayoutFormType?, bool?, SubtotalLocationType?, bool?, bool?, bool?, string)	Initializes a new command to modify IPivotTable field settings.
CreatePivotTable(IWorkbook, string, string)	Creates a PivotTable report from table.
DeleteField(IPivotTable, PivotFieldOrientation, int)	Remove row, column, page fields, and data fields from a PivotTable report or PivotChart report.
DeletePivotTable(IPivotTable)	Initializes a new command to delete the IPivotTable.
DrillToPivotField(IPivotTable, IPivotField, IPivotItem, string)	Initializes a new command to drill to a specified IPivotField from a IPivotItem.
ExpandCollapsePivotField(IPivotTable, IPivotField, IPivotItem, bool, bool)	Initializes a new command to expand/collapse the IPivotField.
Filter(IPivotTable, int, IndexBitmap)	Initializes a new command to filter the IPivotTable by a specific IPivotField.
Filter(IPivotTable, int, PivotFilterType, object, object, int, bool)	Initializes a new command to filter the IPivotTable by a specific IPivotField with specified criteria.
Group(IRange, double?, double?, double?, PivotGroupPeriods[])	Initializes a new command to group specified range inside IPivotTable.
HideSelectedItems(IRange)	Creates a command that hides the items within the specified range.
KeepOnlySelectedItems(IPivotTable, int, IRange)	Creates a command that filters the specified field to display only the items selected in the given range.
ModifyPivotStyle(IPivotTable, Dictionary<TableStyleElementType, Tuple<StyleFormat, int>>, string, bool, string, bool)	Modifies the pivot style of specified IPivotTable object.
MoveField(IPivotTable, int, PivotFieldOrientation, PivotFieldOrientation, int)	Change a fields of PivotTable report or PivotChart report.
MovePivotField(IPivotTable, IPivotField, IPivotItem, PivotFieldOrientation?, bool?, bool?, bool?, bool?)	Initializes a new command to move to a specified IPivotField or IPivotItem.
Options(IPivotTable)	Initializes a new command to modify GrapeCity.Spreadsheet.Commands.PivotTables.PivotTableCommand.PivotTable options.
PageFilter(IPivotTable, int, int)	Initializes a new command to filter the IPivotTable by a specific IPivotField.
RefreshCaches(Workbook, List<int>)	Get the latest data by refreshing all source in the workbook.
RefreshPivotTable(IPivotTable)	Initializes a new command to refresh the IPivotTable.
Remove(IWorkbook, string)	Removes a pivot style from workbook.
ReplacePivotStyle(IPivotTable, string)	Applies the pivot style of specified IPivotTable object and clear formatting.
SortField(IPivotTable, int, FieldSortType, int, SortType)	Initializes a new command to sort the IPivotField in the IPivotTable.
ToggleDetailFieldItem(IPivotItem)	Initializes a new command to show/hide detail of the IPivotItem.
Ungroup(IRange)	Initializes a new command to ungroup specified range inside IPivotTable.
UpdateDataFieldSettings(IPivotTable, IPivotField, ConsolidationFunction?, PivotFieldCalculation?)	Initializes a new command to modify GrapeCity.Spreadsheet.Commands.PivotTables.PivotTableCommand.PivotTable data field settings.
UpdateFields(IPivotTable, Tuple<int, PivotFieldOrientation>[], Tuple<PivotDataField, string>[])	Update row, column, page fields, and data fields of a PivotTable report or PivotChart report.
UpdatePivotField(IPivotTable, IPivotField, PivotFieldOrientation?, bool?, ConsolidationFunction?, ConsolidationFunction?, PivotFieldCalculation?, bool?)	Initializes a new command to update the IPivotField.
UpdateShowValuesAsSettings(IPivotTable, IPivotField, PivotFieldCalculation, NumberFormat, int?, int?)	Initializes a new command to modify GrapeCity.Spreadsheet.Commands.PivotTables.PivotTableCommand.PivotTable show values as settings.