OBIEE 11g: Extra % Character At The End Of Cell Value When Exported To Excel 2007 And 2003 (Doc ID 2084367.1)

Last updated on JANUARY 05, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.150714 and later
Information in this document applies to any platform.

Symptoms

Recently migrated to OBIEE 11.1.1.7.150714.  The cell value data type in Excel showed as custom #,##0.00% which made the cell value to display % but did not store % in the cell in the older versions when exported to Excel.

But, in OBIEE 11.1.1.7.150714, the cell value data type in excel showing as Percentage%, which makes the cell value store a % in the cell.

This change in data type is causing a break in the dependent macro reader.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms