Item «Value»

As value you can use a class instance : CL_SALV_TREE or CL_HRPAYNA_GUI_ALV_TREE (for CL_GUI_ALV_TREE exporting).

Of course, the class instance can be used as whole context, or as one of the components which nested in the context.

Note:

The class CL_HRPAYNA_GUI_ALV_TREE inherits all the properties/methods/events of the class CL_GUI_ALV_TREE.

Using of cubclass insted the original CL_GUI_ALV_TREE is due to a technical necessity (the presence of an additional method GET_OUTTAB to getting a table structure ).

Tree formatting is described by the markup of related area in the Excel template .

The area must be marked up according the rules described below.

• The area has at least two horizontal cells and two vertical ones (there may be a greater than 2 cells in any of the directions). The area is divided into four sub-areas, which in the figure marked with white numbers in red circles, and their boundaries are marked with a red dashed line:

• Sub-areas 1 and 2 specifies formatting of the tree header (the row, that displays the column names).

• Sub-areas 3 and 4 specifies formatting of the data rows. Herewith, sub-area 3 specifies formatting of the hierarchy column (the column with tree nodes); sub-area 4 specifies formatting of the other columns (output table columns).

The figure below illustrates all of the above :

OK. However, in the ALV-TREE hierarchy levels have different colors. How to do same in Excel?

It is possible to control the color and other cell formatting options (text: font/size/color etc.) for each level of the hierarchy.

To do this, you need to add more rows to the sub-area 3 and 4. The principle is: each row below (in the markup) describes the formatting of the next hierarchy level of tree (for example, the second row describes the second hierarchy level, the third row - the third level, etc.).

Herewith, the formatting of the last row (of the markup) applies to the corresponding hierarchy level (of the tree) and the following (more deep) hierarchy levels too, if they available. For example, if the last row (of the markup) is third, it describes the third hierarchy level (of the tree), and 4, 5, 6, etc.:

Well, if we want to colorize the columns in a different colors?

It is possible to control the color and other cell formatting options (text: font/size/color etc.) for each column .

To do this, you need to add more columns to the sub-area 2 and 4. The principle is: each column (in the markup) describes the formatting of the corresponding tree column. Herewith, the formatting of the rightmost column (of the markup area) applies to the corresponding tree column and the following columns too, if they available.

It the figure below, we need to colorize ObjectID column to the green gradient, but the address fields (are placed righter then ObjectID) we need to colorize to the gray gradient. To do this, you only need to add formatting the first of the "address" tree columns, because this formatting will spread to the rest "address" columns (they are all placed righter):

Item «Output direction»

The item defines the tree positioning relative to the previous component.

To change output direction you have to press the buttons

This option described in detail in «Pattern» component.

• Structure

If this option is enabled, the hierarchy levels becomes grouped (markers:

appear near each node which has child nodes). Moreover, it is possible to choose the initial state of the nodes in the Excel:

• Header

If this option is enabled, the row that displays the column names appears in the tree.

Note: regardless of this option the markup must contain sub-areas 1 and 2.

• Hierarchy column

If this option is enabled, the column with nodes will be displayed.

Note: regardless of this option the markup must contain sub-areas 1 and 3.

• • • Switching between options:

allows you to select whether the hierarchy column displayed before output table columns, or after them.

• • • Option :

specifies the offset of the node text for each of the next hierarchy level with respect to the previous one. Offset is achieved by adding a certain number of spaces at the beginning of the node text. The offsets option can be disabled by setting the value to 0.

• Other columns

If this option is enabled, the output table columns will be displayed.

Note: regardless of this option the markup must contain sub-areas 2 and 3.

• • Width from fieldcatalog.

    • • • If this option is enabled, width of the tree columns will be taken from actual fieldcatalog of the ALV-Tree (field OUTPUTLEN). Herewith, you are prompted to specify a multiplier by which you can fine-tune width of the column.

        • If this option is disabled, width of the tree columns will be taken from corresponding columns of the Excel-template.

• • • Allow formulas.

      • • if this option is enabled, all values, which beginning with '=' , will be interpreted as formula ( See more details here ).

        • If this option is disabled, values will be inserted to the cell regular way.