GrapeCity.Documents.Excel.IPivotField.DragToRow

DragToRow Property

DragToRow

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

This property determines whether the field is allowed to be moved to the row area in a PivotTable. The default value is true.

Declaration

bool DragToRow { get; set; }

Property DragToRow 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"];
bool canDragToRow = field.DragToRow;