Export Discoverer Report In French and Spain MS Excel 2007 And Retain The Formatting Using Discoverer 10g Plus/Viewer.

Hi All

One of my customer in France and Spain  found this issue:
Can't Export Discoverer Report In  French and Spain  MS Excel 2007 And Retain The Formatting Using Discoverer 10g Plus/Viewer.

In my computer I have English version of Excel 2007 and it's working perfect.

I believe this issue is occurring as user do not have the French and Spanish languages installed in his Apps database and so discoverer server is defaulting to English.
I checked the Doc ID 453549.1 - French Excel Cannot Open Exported Apps Workbooks With Macros Enabled:


According to Bug 5907966: FRENCH EXCEL CANNOT OPEN EXPORTED APPS WORKBOOKS WITH MACROS ENABLED
this issue is because French Language is not installed on the Apps Database so discoverer server is defaulting to English.


ER: Bug 4420451: NLS: APPS: DISCO BEHAVES WRONGLY WHEN CONNECTED WITH NON-APPS INSTALLED LANG
was opened inorder to try to fix multiple issues happening when using Non-English Discoverer with an Apps Database that doesn't have that Non-English Language installed.


Solution:
Installing the French Language on the Apps Database resolves this issue.
Or as a workaround, English Discoverer and English Excel can be used.



'Install the French language on the apps database' means installing the French language on the oracle Application server.

Doc ID 1065186.6 -'HOW TO HAVE WORKBOOKS DISPLAY IN FRENCH AND OTHER LANGUAGES?' , would help you in understanding about this.

Can the languages be added to exist Application?

As per my research , this is not possible. The languages available for an OracleAS instance must be selected at install time. So to add additional languages,you need to re-install the OracleAS instance.


SOLUTION DESCRIPTION:
=====================


To have a language other than English, choose it in the Oracle installer: 
When the installation begins, in the panel Oracle Installations Settings, you 
are asked for the name of the company, the Oracle default home and the language.

All are available on the CD; the installer always installs files for English 
and the language you choose at the installation.


Then, change your registry entry NLS_LANG in Hkey_local_machine/software/Oracle 
from American_america.xxxx into French_france.xxxx or whatever language you
choose.  Launch Discoverer.


Good Luck ..