Click or drag to resize
ExcelViewOptionsOutlineColumnButtonsRight Property
Gets or sets whether outline column buttons are displayed on the right side of groups.

Namespace: GemBox.Spreadsheet
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 41.3.30.1000
Syntax
public bool OutlineColumnButtonsRight { get; set; }

Property Value

Type: Boolean
Remarks
This property is simply written to Excel file and has no effect on behavior of this library. For more information on worksheet protection, consult Microsoft Excel documentation.
Examples

Following code creates two horizontal groups and one vertical group. Horizontal groups have outline button above (default is below), while vertical group is collapsed.

static void GroupingAndOutline(ExcelWorksheet ws)
{
    ws.Cells[0, 0].Value = "Grouping and outline example:";

    //Vertical grouping.
    ws.Cells[2, 0].Value = "GroupA Start";
    ws.Rows[2].OutlineLevel = 1;
    ws.Cells[3, 0].Value = "A";
    ws.Rows[3].OutlineLevel = 1;
    ws.Cells[4, 1].Value = "GroupB Start";
    ws.Rows[4].OutlineLevel = 2;
    ws.Cells[5, 1].Value = "B";
    ws.Rows[5].OutlineLevel = 2;
    ws.Cells[6, 1].Value = "GroupB End";
    ws.Rows[6].OutlineLevel = 2;
    ws.Cells[7, 0].Value = "GroupA End";
    ws.Rows[7].OutlineLevel = 1;
    // Put outline row buttons above groups.
    ws.ViewOptions.OutlineRowButtonsBelow = false;

    //Horizontal grouping (collapsed).
    ws.Cells["E2"].Value = "Gr.C Start";
    ws.Columns["E"].OutlineLevel = 1;
    ws.Columns["E"].Hidden = true;
    ws.Cells["F2"].Value = "C";
    ws.Columns["F"].OutlineLevel = 1;
    ws.Columns["F"].Hidden = true;
    ws.Cells["G2"].Value = "Gr.C End";
    ws.Columns["G"].OutlineLevel = 1;
    ws.Columns["G"].Hidden = true;
    ws.Columns["H"].Collapsed = true;
}
See Also