SpreadsheetDocument.ShowRowGroupLevel

Syntax:

ShowRowGroupLevel(<Level>)

Parameters:

<Level> (required)

Type: Number.
Level to which you want to expand row groupings.

Description:

Shows row groupings level to the level specified.

Availability:

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

Example:

// SprDocField - spreadsheet document field to display report result
// Button name contains the level
Procedure OpenLevel(Button)
    Level = Number(Mid(Button.Name, 2)) - 1;
    L = SprDocField.RowGroupLevelCount() - 1;
    While L > Level Do
        SprDocField.ShowRowGroupLevel(L);
        L = L - 1;
    EndDo;
    SprDocField.ShowRowGroupLevel(Level);
EndProcedure

    

1C:Enterprise Developer's Community