GrapeCity.Documents.Excel.IPivotField.ShowAllItems

ShowAllItems Property

ShowAllItems

Gets or sets whether all items in the PivotTable report are displayed, even if they do not contain summary data.

The default value is false. When this property is true, items without summarized values are still shown for the PivotField.

Declaration

bool ShowAllItems { get; set; }

Property ShowAllItems As Boolean

Examples

worksheet.Range["A1:B5"].Value = new object[,] {
    {"Category", "Amount"},
    {"Fruit", 120},
    {"Fruit", 80},
    {"Vegetables", 95},
    {"Vegetables", 60}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B5"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "SalesPivot");
IPivotField field = pivotTable.PivotFields["Category"];
field.ShowAllItems = true;
bool showAllItems = field.ShowAllItems;