Common formatting options are available for CubeQuery items on the Format and shortcut menus including:
Auto-size Width—By default columns and rows are distributed evenly and without regard to the length of data values, which may be truncated. With the auto-size width feature, you can automatically size any column or rows horizontally to fit the text of the largest value in the column.
Auto-size Height—By default columns and rows are distributed evenly and without regard to the length of data values, which may be truncated. With the auto-size height feature, you can automatically size any column or rows vertically to fit the text of the largest value in the column.
Number Format—Options for changing the way numbers, currency values, and dates are displayed throughout or create new custom formats. See Number Formatting
.
To auto-size the width of a row or column, select the row or column label and choose