Use this dialog to edit the worksheet text that is displayed at the bottom of a worksheet. For example, you might want to display the date at the bottom of a worksheet. Or you might want to display custom help text for a worksheet in the worksheet text area.
Formatting options that you specify apply to new text that you enter in the Text field or text currently selected in the Text 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 text for new worksheets.
For more information, see:
Use this drop down list to specify a font for the text in the worksheet text area.
Use this drop down list to specify a point size for the text in the worksheet text area.
Use this color pane to specify a color for the text in the worksheet text area.
Use these buttons to change font style and text alignment options for the text in the worksheet text 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
Use this color pane to specify a background color for the text in the worksheet text area. The background color that you specify applies to the whole text area.
Hint: Ensure that the background color is different to the text color.
Use this field to enter the text you want to appear at the bottom 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 text displayed at run time can be more than 1024 characters (for example, if text variables are displayed).
Use this button to display a drop down list of text variables (for example, date, time) that you can insert into the worksheet text area.
Hint: Before you insert a text variable, place the cursor inside the Text 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 text area, the worksheet text 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.
To hide the worksheet text area on the current worksheet, clear the Show text 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 text 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 text area when you create a worksheet, choose Tools | Options and select the Show text area check box on the "Options dialog: Sheet tab".