GrapeCity.Documents.Excel.LayoutFormType

LayoutFormType Enum

Specifies how PivotTable items are displayed for a field.

Use this enum with LayoutForm to show items in either tabular form or outline form. Tabular displays the field in tabular form, and Outline displays the field in outline form.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum LayoutFormType

Public Enum LayoutFormType

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Category", "Amount"},
    {"Beverages", 100},
    {"Beverages", 200},
    {"Snacks", 150}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:B4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["D1"], "SalesPivot");
IPivotField field = pivotTable.PivotFields["Category"];
field.Orientation = PivotFieldOrientation.RowField;
field.LayoutForm = LayoutFormType.Outline;

Fields

Name	Description
Outline	The LayoutSubtotalLocation property specifies where the subtotal appears in the PivotTable report.
Tabular	Default.