Spread.Services Documentation
IPivotField Interface Properties

GrapeCity.Documents.Spread Namespace : IPivotField Interface

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

Public Properties
 NameDescription
 Property Retrieves a value that indicates whether any manual filtering is applied to Pivotfield  
 Property Gets or sets 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".  
 Property Gets or sets whether the specified field can be dragged to the column position. The default value is True.  
 Property Gets or sets whether the specified field can be dragged to the data position. The default value is True.  
 Property Gets or sets whether the field can be hidden by being dragged off the PivotTable report. The default value is True.  
 Property Gets or sets whether the field can be dragged to the page position. The default value is True.  
 Property Gets or sets whether the field can be dragged to the row position. The default value is True.  
 Property Gets or sets whether the field can have multiple items selected in the page field. The default value is false.  
 Property Gets or sets the function used to summarize the PivotTable field (data fields only). This object is read or write.  
 Property Gets or sets the position of the PivotTable field subtotals in relation to (either above or below) the specified field.  
 Property Gets or sets the name of the object (read or write).  
 Property Gets or sets the location of the field in the specified PivotTable report.  
 Property Returns a collection of all the visible and hidden items in the specified field.  
 Property Gets or sets the position of the field (first, second, third, and so on) among all the fields in its orientation (Rows, Columns, Pages, Data).  
 Property Returns 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.  
 Property Gets or sets a combination of all the showing subtotal types in the specified PivotField. Valid only for nondata fields.  
Top
See Also

Reference

IPivotField Interface
GrapeCity.Documents.Spread Namespace