GrapeCity.Spreadsheet.Commands.PivotTables.PivotTableCommand

PivotTableCommand Class

Represents a command for the IPivotTable.

Inheritance

object

Command

PivotTableCommand

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

Properties

Name	Description
UndoSupport	Gets the UndoSupport value indicates whether this command is undoable.

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.
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.
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.