VISIBLEHIERARCHY
Returns for hierarchy widgets the currently visible rows.
Returns for hierarchy widgets the currently visible rows.
VISIBLEHIERARCHY(widget)
widget - the hierarchy table widget from which only the visible rows should be returned - Value type: widget reference
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.
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.
