Documents for Excel, Java Edition Documentation
com.grapecity.documents.excel Package / IPivotField Interface

In This Topic
    IPivotField Interface Methods
    In This Topic

    For a list of all members of this type, see IPivotField members.

    Public Methods
     NameDescription
     MethodOverloaded. Establishes automatic field-sorting rules for PivotTable reports.  
     MethodDeletes all filters currently applied to the PivotField. This includes deleting all filters from the PivotFilters collection of the PivotField and removing any manual filtering applied to the PivotField as well. If the PivotField is in the Report Filter area, the item selected will be set to the default item.  
     MethodProvides an easy way to set the Visible property to True for all items of a PivotField in PivotTables, and to empty the HiddenItemsList and VisibleItemsList collections in OLAP PivotTables.  
     MethodRetrieves a value that indicates whether any manual filtering is applied to Pivotfield.  
     MethodReturns the name of the data field used to sort the specified PivotTable field automatically.  
     MethodReturns the order used to sort the specified PivotTable field automatically.  
     MethodGets the current page's index showing for the page field (valid only for page fields). The valid value is based on zero. "-1" indicates "All" or "Multiple Items".  
     MethodGets whether the specified field can be dragged to the column position. The default value is True.  
     MethodGets whether the specified field can be dragged to the data position. The default value is True.  
     MethodGets whether the field can be hidden by being dragged off the PivotTable report. The default value is True.  
     MethodGets whether the field can be dragged to the page position. The default value is True.  
     MethodGets whether the field can be dragged to the row position. The default value is True.  
     MethodGets whether the field can have multiple items selected in the page field. The default value is false.  
     MethodGets the function used to summarize the PivotTable field (data fields only).  
     MethodGets if a blank row is inserted after the specified row field in a PivotTable report. The default value is False.  
     MethodGets whether or not a PivotField is compacted(items of multiple PivotFields are displayed in a single column) when rows are selected.  
     MethodReturns the way the specified PivotTable items appear í¬ in table format or in outline format.  
     MethodGets the position of the PivotTable field subtotals in relation to (either above or below) the specified field.  
     MethodGets the name of the object.  
     MethodGets the format code for the object.  
     MethodGets the location of the field in the specified PivotTable report.  
     MethodReturns a collection of all the visible and hidden items in the specified field.  
     MethodGets the position of the field (first, second, third, and so on) among all the fields in its orientation (Rows, Columns, Pages, Data).  
     MethodGets whether item labels are repeated in the PivotTable for the specified PivotField.  
     MethodGets if all items in the PivotTable report are displayed, even if they doní»t contain summary data. The default value is False.  
     MethodReturns the specified objectí»s name as it appears in the original source data for the specified PivotTable report. This might be different from the current item name if the user renamed the item after creating the PivotTable report.  
     MethodGets a combination of all the showing subtotal types in the specified PivotField. Valid only for nondata fields.  
     MethodSets the current page's index showing for the page field (valid only for page fields). The valid value is based on zero. "-1" indicates "All" or "Multiple Items".  
     MethodSets whether the specified field can be dragged to the column position. The default value is True.  
     MethodSets whether the specified field can be dragged to the data position. The default value is True.  
     MethodSets whether the field can be hidden by being dragged off the PivotTable report. The default value is True.  
     MethodSets whether the field can be dragged to the page position. The default value is True.  
     MethodSets whether the field can be dragged to the row position. The default value is True.  
     MethodSets whether the field can have multiple items selected in the page field. The default value is false.  
     MethodSets the function used to summarize the PivotTable field (data fields only).  
     MethodSets if a blank row is inserted after the specified row field in a PivotTable report. The default value is False.  
     MethodSets whether or not a PivotField is compacted(items of multiple PivotFields are displayed in a single column) when rows are selected.  
     MethodSets the way the specified PivotTable items appear í¬ in table format or in outline format.  
     MethodSets the position of the PivotTable field subtotals in relation to (either above or below) the specified field.  
     MethodSets the name of the object.  
     MethodSets the format code for the object.  
     MethodSets the location of the field in the specified PivotTable report.  
     MethodSets the position of the field (first, second, third, and so on) among all the fields in its orientation (Rows, Columns, Pages, Data).  
     MethodSets whether item labels are repeated in the PivotTable for the specified PivotField.  
     MethodSets if all items in the PivotTable report are displayed, even if they doní»t contain summary data. The default value is False.  
     MethodSets a combination of all the showing subtotal types in the specified PivotField. Valid only for nondata fields.  
    Top
    See Also