Freezing Grid Headers

You can select a grid for which you want the row and column heading labels to display when scrolling an HTML report in Planning and Budgeting Cloud Workspace.

  To freeze the row and column headings of a grid:

  1. Select the grid for which you want to freeze the row and column headings.

  2. On Grid Properties – General category, select Freeze Grid Headers.

  3. To unlock rows and columns, select the grid and clear Freeze Grid Headers.

    Note:

    To view the report within the entire area, you must expand the grid size in Reporting Studio.

Browser Behavior When Freezing Grid Headers

Note the behaviors specific to using Internet Explorer and Firefox:

  • Scrolling. In Internet Explorer, the row and column headings are locked; in Firefox, only the column headings are locked.

  • Grid height and width. The height and width set by the designer is visible in HTML preview for both Internet Explorer and Firefox. Scrollbars are only shown when all rows or columns do not display. When Freeze Grid Headers is turned on, the autosize property is ignored.

  • Horizontal scrolling. When the width of the grid exceeds the width of the design, the horizontal scrollbar is shown. However, the behavior of the horizontal scrollbar is different in the two browsers. In Internet Explorer, the row headings are adjusted so that they are always shown; in Firefox, the horizontal scrollbar will scroll all the columns, including the headings.

    Note:

    When using both “Freeze Grid Headers” and “Row Headings Before Column X”, if X is any column greater than A, the horizontal scroll bar is not displayed.

  • Vertical scrollbar position. In Internet Explorer, the vertical scrollbar is shown at the rightmost position in the table. In Firefox, the scrollbar appears underneath the final column heading, cutting into the final column. To accommodate this behavior, an additional column is added to the grid so that the last column is not covered up by the scrollbar.

  • Scrolling speed. Scrolling speed is faster in Firefox because the scrolling is built in and does not require JavaScript as Internet Explorer does.