Edit Title dialog

Use this dialog to change the worksheet title that is displayed at the top of a worksheet. For example, you might want to display the worksheet name and current date at the top of a worksheet.

For more information, see:

"What are worksheets?"

"How to create or edit a worksheet title"

"How to display or hide a worksheet title"

Font

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

Size

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

Color

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

Formatting buttons

Use these buttons to change font style and text alignment options for the text selected in the Title field. For example, use the B button to embolden text or use the U button to underline text.

Background color

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

Title

Use this field to enter the text that you want to display at the top of the worksheet. You can enter text and text variables into the Title field up to a total maximum length of 4096 characters (language dependent).

Note: The worksheet title displayed at runtime can be more than 4096 characters (e.g. if text variables are displayed).

This text is also displayed when you print or export the worksheet.

Hint: To cut and paste a title into the Title field, click inside the Title field and paste in the text. For example, on a Windows client click Ctrl + v to paste text.

Insert

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

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 Current Date variable on a worksheet, the date value is updated each time the worksheet is displayed, printed, or exported. For example, if you insert the Current Date variable into a worksheet title, the worksheet title might display 'January 1 2003' if you access the worksheet on January 1st.

Notes

• On a new worksheet, the default title text is 'Double-click here to edit the title', which you can change if you want to display a worksheet title. You need to either change the title text or hide the worksheet title.

• If you do not change the default title, the Title field displays 'Empty title'. You can also clear the default title text and display an empty title on the worksheet. For example, you might want to deploy a worksheet to Discoverer Plus users with an empty title field into which they can add text.

• If you want to hide the worksheet title, clear the Title check box on the options dialog (for more information, see "How to display or hide a worksheet title").

• When you insert the Current date and Current time text variables into the Title field, you display the date and time on the Discoverer Web server.

• If the worksheet was created in Discoverer Desktop with worksheet exceptions applied, you can insert the Exceptions text variable into the Title field.

• 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.