AutoFit Range
The AutoFit Range function adjusts either the column widths or row heights of the range determined by the Apply To settings based on the content of the cells in the range. This can be very useful if the report contains a data group which brings in either headers or textual data that can vary in size.
Settings | |
|---|---|
AutoFit | Column Width Each column in the range is widened based on the cell in the column with the largest amount of data (e.g., the cell with the most characters). |
Row Height Each row in the range is adjusted in height based on the cell in the row with the largest amount of data (e.g., the cell with the most characters). This setting is most effective if the cells are formatted to wrap text. | |
Example
A report template is designed to allow the user to select tags which are displayed in the report. Since tag names will vary in length it is difficult to size the column widths ahead of time. Instead, an AutoFit Range management function is configured to run after the data is retrieved.
If the report data is configured for cell $B$8 with an additional 12 columns, the AutoFit Range function is configured as:
Apply To | |
|---|---|
Cell | $B$8:$N$8 |
Direction | Down |
End | All cells are empty |
Setting | Value |
|---|---|
AutoFit | Column Width |