Excel sheet naming improvements

The RSVP.EXCEL.XLS2007_SUFFIX_PAGENUMBER advanced property is added for the report service to provide a consistent way of naming Excel sheets. By default, this property is set to true.

This new property, with its default value, introduces the following changes to naming duplicate sheets in Excel reports:

• The suffix _duplicate_increment is added to duplicate sheet names, where the duplicate_increment always starts with 2 for the first duplicate of a given name, and increments by 1 for each subsequent duplicate. For example: Camping Equipment, Camping Equipment_2, Camping Equipment_3 or Products, Products_2, Products_3.
• The prefix s_duplicate_increment (previous behavior) is no longer added to the sheet names.
• The sheet names never exceed the Excel 31 character limit, including the situations when the duplicate sheet naming logic is applied.

The new naming behavior affects the preexisting property RSVP.EXCEL.NUMBEREDSHEETNAMES in the following ways:

• When RSVP.EXCEL.NUMBEREDSHEETNAMES is set to true, its behavior is overwritten.
• When RSVP.EXCEL.NUMBEREDSHEETNAMES is set to false, there are no significant changes in behavior, only fixes and improvements.

Starting with this release, the default value for the RSVP.EXCEL.NUMBEREDSHEETNAMES property is changed to false.

The new duplicate names handling applies also to the RSVP.EXCEL.PAGEGROUP_WSNAME_ITEMVALUE property.

The following two tables show the properties, with their default values, that are used to manage duplicate names in Excel 2007 reports in Cognos® Analytics:

For more information, see Naming duplicate sheets in Excel 2007 reports and Page breaks, page sets, and page layers.