Returns for hierarchy widgets the currently visible rows.



  • 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.