GrapeCity.Documents.Excel.ISlicer.Left

Left Property

Left

Gets or sets the horizontal position of the specified slicer, in points, relative to the upper-left corner of cell A1 on a worksheet.

Use this property to retrieve the current left offset of the slicer on the worksheet.

Declaration

double Left { get; set; }

Property Left As Double

Examples

worksheet.Range["A1:B4"].Value = new object[,] {
    {"Category", "Amount"},
    {"Fruit", 100},
    {"Vegetables", 200},
    {"Fruit", 150}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B4"], true);
ISlicer slicer = workbook.SlicerCaches.Add(table, "Category")
    .Slicers.Add(worksheet, "categorySlicer", "Category", 30, 100, 120, 160);
double left = slicer.Left;