Edit Title dialog

Use this dialog to edit the worksheet title that is displayed at the top of a worksheet. For example, you might want to display the date at the top of a worksheet. Or you might want to display custom help text for a worksheet in the worksheet title area.

Formatting options that you specify apply to new text that you enter in the Title field or text currently selected in the Title field

Note: If you are editing default Discoverer options (that is, you chose Tools | Options and displayed the Formats tab) you use this dialog to specify the default worksheet title for new worksheets.

For more information, see:

"About worksheet titles and text"

"How to create or edit worksheet titles or text"

"How to display or hide worksheet titles or text"

Font

Use this drop down list to specify a font for the text in the worksheet title area.

Size

Use this drop down list to specify a point size for the text in the worksheet title area.

Color

Use this color pane to specify a color for the text in the worksheet title area.

Use these buttons to change font style and text alignment options for the text in the worksheet title area. For example, use the B button to make text bold or use the U button to underline text.

Note: If you apply a format to a text variable, the format is applied to all characters in that text variable when the value is displayed on the worksheet. In other words, you cannot apply different formats to individual characters in a text variable

Background color

Use this color pane to specify a background color for the text in the worksheet title area. The background color that you specify applies to the whole title area.

Hint: Ensure that the background color is different to the text color.

Title

Use this field to enter the text you want to appear at the top of the worksheet when you display the workbook on screen or print or export the worksheet. You can enter text and text variables up to a total maximum length of 1024 characters.

Note: The worksheet title displayed at run time can be more than 1024 characters (for example, if text variables are displayed).

Insert

Use this button to display a drop down list of text variables (for example, date, time) that you can insert into the worksheet title area.

Hint: Before you insert a text variable, place the cursor inside the Title field in the position at which you want to insert the text variable.

The value of a text variable is updated when a worksheet is displayed, printed, or exported. In other words, if you display the &Time variable on a worksheet, the time value is updated each time the worksheet is displayed, printed, or exported. For example, if you insert the &Time variable into a worksheet title area, the worksheet title area might display '12.00.00 PM' if you print the worksheet at midday and '08.30.00 AM' if you print the worksheet at eight-thirty in the morning.

Notes

To hide the worksheet title area on the current worksheet, clear the Show title check box on the options dialog (for more information, see "How to display or hide worksheet titles or text").
If you include the &Date and &Time text variables in a worksheet title area, the values displayed in the worksheet are the date and time on the Discoverer server. The date and time on the Discoverer server might be different to the date and time on the system running the Web browser where you started Discoverer Plus Relational.
To specify that Discoverer displays a worksheet title area when you create a worksheet, choose Tools | Options and select the Show title check box on the "Options dialog: Sheet tab".