Configure global formatting options

Formatting is applied to all of the data inserted as a result of using the Workbook wizards.

To configure formatting options:

1. On the Historian tab, in the Publish group, click Options, and then click Options. The Options dialog box appears.

2. Click the Format tab.

3. Configure the column headings.

   • Display heading: Display the column heading for the results in the worksheet.

   • Bold: Display the column heading in a bold font.

   • Italics: Display the column heading in an italicized font.

4. Select the Auto-fit results check box to adjust the worksheet columns so that the entire result text for a column appears.

5. Configure the formatting for numerical values.

   • Number format: If set to General, the numerical value displayed reflects the original value retrieved from the database. If set to Fixed, the retrieved value is rounded to a specified number of decimal places.

   • Decimal places: For a number format of Fixed, the number of decimal places to show for the data value of the currently selected tag. This applies only to analog tags.

6. In the Date/time format list, click the formatting for the timestamps.

   The default date format in your workbook is determined by the default language setting of the SQL Server login. To set the date/time format, do either of the following:

   • Change the default language for a SQL Server login. This will also change the default date format of the SQL Server.

     If the default language of the SQL Server login is not set, the language of the SQL Server instance is set as the default. For example, if you install a U.S. English version of the SQL Server, the default language is set to U.S. English.

   • Override the date/time format for the timestamp by using the Select output cell list option in Step 10 to contain the formatting settings. Then, reference the Date Format cell in your query to control the timestamp format for the returned data values. You can change the Date Format cell to any format you want, and the timestamp column in the query results will reflect the change after you refresh the sheet.

7. In the Result alignment list, click the alignment for the returned data within the worksheet cells.

8. Select the Check that specified tag(s) exist(s) check box to validate that the tag exists in the database prior to the function being executed.

9. Select the Paste format options on worksheet check box to insert the default formatting options in the worksheet.

   Note: The inserted formatting information is not automatically updated if you change the options.

10. In the Select output cell list, specify the location of the worksheet cell(s) that will contain the output. Click on the button to select the cell(s) using your mouse. For more information, see Selecting Cells.

11. Click OK.

    If you select to output the formatting information, it appears in the sheet.