GrapeCity.Documents.Excel.IPivotField.DragToPage

DragToPage Property

DragToPage

Gets or sets whether the field can be dragged to the page position.

The default value is true.

Declaration

bool DragToPage { get; set; }

Property DragToPage As Boolean

Examples

worksheet.Range["A1:C4"].Value = new object[,] {
    {"Region", "Product", "Amount"},
    {"East", "Apple", 100},
    {"West", "Pear", 200},
    {"East", "Pear", 150}
};
IPivotCache pivotCache = workbook.PivotCaches.Create(worksheet.Range["A1:C4"]);
IPivotTable pivotTable = worksheet.PivotTables.Add(pivotCache, worksheet.Range["E1"], "SalesPivot");
IPivotField field = pivotTable.PivotFields["Region"];
field.DragToPage = false;
bool canDragToPage = field.DragToPage;