Format Cells page

Previous

Next

---

Use this page to specify font, border, and number format options for selected cells in a crosstab worksheet.

For more information about worksheet formatting, see:

"Worksheet Display page: (Table/Crosstab tools)"

"What is a conditional format?"

"What is a stoplight format?"

Bold

Use this drop down list to select whether to apply or remove the bold format from the selected worksheet cells.

Italic

Use this drop down list to select whether to apply or remove the italic format from the selected worksheet cells.

Underline

Use this drop down list to select whether to apply or remove the underline format from the selected worksheet cells.

Background

Use the color picker to select a background color to apply to the selected worksheet cells.

Font

Use the color picker to select a font color to apply to the selected worksheet cells.

Border

Use this area to select border line styles and border line color formatting for the selected worksheet cells.

Note: This field is only displayed when you use an OLAP connection:

Style

Use this drop down list to select a border line style for the selected worksheet cells.

Note: This field is only displayed when you use an OLAP connection:

Line color

Use this icon to display a color palette where you select a border line color to use for the selected worksheet cells.

Note: This field is only displayed when you use an OLAP connection:

Outline, Bottom, top, Left, Right

Use these rows to set the border specifications to use for all the selected worksheet cells.

Note: This field is only displayed when you use an OLAP connection:

Number

This area displays different content for different number categories.

Note: This field is only displayed when you use an OLAP connection:

Categories

Use this field to select a category, and then Discoverer Viewer displays the appropriate controls. Depending on which category you select, the following controls can be displayed:

Note: This field is only displayed when you use an OLAP connection:

• Negative Numbers

  Use this drop down list to specify a format for negative numbers. This field is displayed for Number and Currency categories.

• Decimal Places

  Use this drop down list to specify the example that has the desired number of decimal places. This field is displayed for Number, Currency, and Percent categories.

• Scale

  Use this drop down list to specify whether to abbreviate numbers. For example, when Thousands is specified in this drop down list, the value 10000 is displayed as 10. This field is displayed for Number and Currency categories.

• Currency Symbol

  Use this drop down list to select the currency symbol for cells. Setting this option does not convert one kind of currency to another. You should be careful to apply the appropriate currency symbol. This field is displayed only for the Currency category.

• Show <letter> for <Scale>

  Select this check box to identify number abbreviations to use in worksheet cells. For example, when Thousands is specified in the Scale drop down list, this check box is labeled Show 'K' for Thousands. If the you select this check box and apply the settings, then the value 10000 is displayed in Discoverer Viewer as 10K. This field is displayed for Number and Currency categories, when Scale is set to a value other than None.

• Use 1000 Separator

  Use this check box to display a comma after the number of thousands. For example, if the Scale is set to None and you select this check box, then the value 10000 is displayed as 10,000. This field is displayed only for the Number category, and is locale (or language) dependent.

• Insert

  Use this drop down list to create a custom format, and then choose Go to add the item to the Edit Custom Format field. This field is displayed only for the Custom category.

• Edit Custom Format

  If you are familiar with Oracle number formatting you can enter an Oracle number format in this field. Alternatively, you can use insert format specifications by using the Insert drop down list. This field is displayed for the Custom category.

Note: Only one category can be applied to a number format at a time. Only the settings in the selected category are applied.

Date

This area displays different content for different date categories.

Categories

Use this field to select a category, and then Discoverer Viewer displays the appropriate controls. Depending on which category you select, the following controls can be displayed:

Note: This field is only displayed when you use an OLAP connection:

• Date Options

  Use this list to select a format for dates. This field is displayed for the Date category.

• Time Options

  Use this list to specify a format for time values. This field is displayed for the Time category.

• Date Time Options

  Use this list to specify a format for date and time values. This field is displayed for the Date & Time category

• Insert

  Use this list to create a custom format, and then choose Go to add the item to the Edit Custom Format field. This field is displayed for the Custom category.

• Edit Custom Format

  If you are familiar with Oracle date formatting you can enter an Oracle date format in this field. Alternatively, you can use insert format specifications by using the Insert drop down list. This field is displayed for the Custom category.

Note: Only one category can be applied to a date format at a time. Only the settings in the selected category are applied.

Notes

• This page uses standard keyboard navigation. If you are not using a mouse, you cannot use the color grids to select a color. Instead, enter RGB values (e.g. #330033 for the color black)