Modifying Column Widths in a Summary
When Monarch Classic generates a summary, it sets the width of each key field column and item field column according to its column width in the Table window. The column width for each measure is initially set to 14 characters.
-
Go to Summary Design.
-
Select a Summary from the Summaries selector. The Summary's properties are displayed on the Summary Window.
-
Do one of the following:
-
If you wish to view and edit all fields, select All Fields from the Summary Design ribbon.
-
If you wish to view just keys, items, or measures, select Keys, Items, or Measures respectively from the Summary Design ribbon.
-
-
Select a field from the fields selector and enter a new column width in the Width box of the General tab that displays.
If you modify the width of a column that contains strings or dates such that the column is not wide enough to accommodate a value, the value is truncated on screen.
If you modify the width of a column that contains numbers such that the column is not wide enough to accommodate a value, the value displays as pound signs (####).
Note: The column width setting affects only the appearance of data on screen; the underlying data is not affected.
-
Choose Accept to accept the new column width.
Column widths for across key columns
All of the columns generated for a key field whose values are spread across a summary are related, so they share a single column width setting. Because column widths for across keys do not have an effect on columns in an across summary, this control is disabled when the key is an across key. See Displaying Key Values Across.
Mouse shortcut
The mouse provides a faster method of changing column widths. Move the mouse pointer to the right edge of the column title. The mouse pointer will become a resizing handle. Click down and drag left or right to resize the column. Although faster, this method is less precise.
Automatically adjusting column widths
Monarch Classic also includes an Autosize Column widths feature that you can use to adjust the width of a column to match the width of its data and its column title. For details, see Automatically Adjusting Column Widths in the Summary Window.
© 2024 Altair Engineering Inc. All Rights Reserved.