Formatting CubeQuery Items

  To modify a font format:

1. Select an item and select Format, then Font.

   The Font tab of the Properties dialog box opens.

2. Select font, style, size, or effects and click OK.

  To modify the style of an item:

1. Select an item and select Format, then Style.

   A submenu of styles is opens.

2. Select a style:

   • Bold

   • Italics

   • Underline

   • Overline

   • Double Overline

3. Click Select.

  To modify a number format:

1. Select a data cell and select Format, then Number.

   The Number tab of the Properties dialog box opens.

2. Select a Formatting Locale, Choose a locale.

3. From the Category field, select a date type. Valid options are:

   • All

   • Number

   • Currency

   • Percentage

   • Date

   • Time

   • Custom

   The available number formats depends on the formatting locale and category. If you select a custom category, an edit box enables you can enter a custom number format.

4. Select a format.

5. Click OK.

  To justify text horizontally and vertically, choose a data cell and on the shortcut menu, and select Justify.

Available justification selections include:

  To modify row or column borders, choose a row or column and on the shortcut menu, select Borders.

Available border styles include:

  To modify the row height:

1. Select the row header, and on the shortcut menu, select Row height.

   The Row height dialog box is displayed.

2. In the Row height (pixels) field, specify the height of the row in pixels.

   In general the greater the number of pixels, the greater amount of detail in the rendered image.

3. Click OK.

  To modify the column width:

1. Select the column header, and on the shortcut menu, select Column Width field.

   The Column width dialog box is displayed.

2. In the Column width (pixels) field, specify the width of the column in pixels.

   In general the greater the number of pixels, the greater amount of detail in the rendered image.

3. Click OK.

  To auto-size the text in a cell horizontally, choose a row or a column, and select Format , then Auto-Size Width.

Auto-sizing by width is useful for displaying horizontal values without truncation.

  To auto-size the text in a cell vertically, choose a row or a column, and select Format, then Auto-Size Height.

Auto-sizing by height is useful for displaying vertical values without truncation.

  To display the name of the data layout values as corner labels, select Format, then Corner Labels and on the shortcut menu, specify the position in which to place the corner label.

Valid corner label positions are:

  To export the CubeQuery section, select Format, then Export Properties.

For more information, see Defining Export Properties for HTML in the Pivot and OLAP Sections.