The ODS EXCEL destination with the SHEET_NAME= suboption might not generate the correct worksheet names in an Excel file.

This issue occurs when the worksheet name is a name that is followed by a space and a number. The worksheets do not display the correct numbers but instead impose a consecutive number order within the worksheet names.

For example, you submit code with the following syntax:

In the XLS file, you would expect to see the first worksheet name as “Rule 3” and the second worksheet name as “Rule 2.” However, instead, the first worksheet name is “Rule 3” and the second worksheet name is “Rule 4.”

A workaround is to add an underscore character within the worksheet name in the SHEET_NAME= suboption (for example, 'Rule_3'). When the underscore characters are in place, the numerals are not changed to increment consecutively within the names of the worksheets.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for this issue for ODS Templates 9.4_M6 is available at:

A fix for this issue for ODS Templates 9.4_M4 is available at: