1C:Enterprise | 1C:Enterprise Developer's Community

SpreadsheetDocument.RowGroupLevelCount

Syntax:

RowGroupLevelCount()

Returned value:

Type: Number.

Description:

Obtains number of rows grouping levels.

Availability:

Thin client, web-client, server, thick client, external connection, Mobile application (client), Mobile application (server).

Example:

// Example of generating command bar buttons to control
// report result groupings

// SprDocField - spreadsheet document field to display report result
// OpenLevel - processing procedure name
// CommPanel - command bar

If Controls.SprDocField.RowGroupsLevelCount() > 1 Then
    LevelsButton = Controls.CommPanel.Buttons.Add("Levels",
        CommandBarButtonType.Popup,
        NStr("en='Show level'"), );
    Action = New Action("OpenLevel");
    Count = Controls.SprDocField.RowGroupsLevelCount()
    For L = 1 To Count Do
        ButtonName = "B" + String(L);
        LevelsButton.Buttons.Add(ButtonName,
            CommandBarButtonType.Action,
            NStr("en='Level'") + String(L), Action);
    EndDo;
EndIf;