VISIBLEHIERARCHY

Returns for hierarchy widgets the currently visible rows.

Syntax

VISIBLEHIERARCHY(widget)

• widget - the hierarchy table widget from which only the visible rows should be returned - Value type: widget reference

Remark

• The function returns the currently visible rows, including the level information in the first column.

• The function is for example helpful if a cell style should be applied on a hierarchy widget, see the example below.

Examples

In this example, negative values in a hierarchy should get a red background.

If a direct reference would be used in the formula (#me), the whole hierarchy, including the collapsed rows, would be returned, leading to wrong row positions of the applied cell style.

Therefore VISIBLEHIERARCHY(#me) should be used instead.