Using row and column gutters in Universal Report static layout

Row and column gutters are now available in Universal Report static layout for IBM® Planning Analytics TM1® Web.

Row and column gutters auto-expand the report definition as you type or paste content into them, so you do not need to manually adjust named ranges.

When you type or paste content into a row or column gutter, the row and column named ranges detect the new values, then updates the report to incorporate the values in a new row or column. The report fills out the rest of the information in the new row or column, based on the other information in the report. The generated information maintains spacer rows, custom labels, and custom data.

A row gutter defines the far margin of the data. It is the first empty row on the bottom. The named range for the row gutter is tm2\\_0_rg.

The following image shows the row gutter on a report:

A column gutter defines the far margin of the data. It is the first empty column on the right. The named range for the column gutter is tm2\\_0_cg.

The following image shows the column gutter on a report:

The following images show a report auto-expanding once content has been typed into a row gutter:

This process works when you paste multiple cells of content, as long as the row or column gutter cell is included where you are pasting the new content. This process also works with stacked rows and columns.

Manual changes are temporary. Closing and re-opening the report restores the data. If you want to save your changes, you can export the report as a slice and publish the exported report.

For more information on row and column gutters in Universal Report static layout, see Row and column gutters.