Welcome to MSDN Blogs Sign in | Join | Help

Setting regional settings for PerformancePoint Add-in for Excel

I am reminded that PerformancePoint has been localized for use outside of the English language. A customer a few days ago asked me how to change the settings to Slovenian so that the Add-in for excel works. Here it is.

If a computer’s regional settings are not English (US, UK...) Excel cannot start the add-in. Install the MS Office 2007 language packs for Swedish and Finnish.

1. Install the Multi Language-Pack 2007.  You can purchase  MUI pack from http://buy20.trymicrosoftoffice.com/buyus/product.aspx?family=langpack&culture=en-US

2. Change the Regional Settings to the appropriate Language.

3. In Excel, go to File | Excel Options | Popular | Selected the Language Settings button to change to regional language (Example: Swedish or Finnish). This allows for a localized version of Excel to exist on English OS. Changes will take effect the next time you launch Excel.

Let me know if this works.

Published Saturday, March 15, 2008 2:17 AM by normbi

Comments

Friday, March 14, 2008 11:56 PM by MSDN Blog Postings » Setting regional settings for PerformancePoint Add-in for Excel

# MSDN Blog Postings » Setting regional settings for PerformancePoint Add-in for Excel

PingBack from http://msdnrss.thecoderblogs.com/2008/03/14/setting-regional-settings-for-performancepoint-add-in-for-excel/

Saturday, March 15, 2008 8:49 AM by netterdotter

# re: Setting regional settings for PerformancePoint Add-in for Excel

This is a horrible design flaw in PPS. Regional settings shouldn't have anything to do with the UI language of software. It's a completely different concept.

In the Nordic countries English OS and Excel is very common (among our customers a clear majority don't use localized software). The regional settings used are naturally still local.

Having to install MUI packs or change your regional settings to get PPS to work is simply not acceptable. The alternative to install for example the Finnish language plug-in gives you a nice mixed language UI in Excel. That's not good, and probably not even allowed due to licensing?

I really hope this gets fixed in SP1...

Monday, March 17, 2008 10:44 PM by normbi

# re: Setting regional settings for PerformancePoint Add-in for Excel

Thank you for the feedback. The PerformancePoint team is investigating a solution that may be provided after SP1.

Thursday, May 15, 2008 2:11 PM by patbaum

# re: Setting regional settings for PerformancePoint Add-in for Excel

This is a known issue, but we we’re not able to deal with it in V1 due to its complexity and when the issue was found.

Unfortunately the issue/bug here is in the Excel PIAs (primary interop assemblies) and outside of our code.

The PIAs are what allow our add-in to communicate with Excel/Office. (for example a call such as “get/set cursor” so our add-in can change the cursor to an hourglass)

When we make a call such as this we have to pass a “Regional Locale” so that Excel/Office know what resource to use. The problem is that a number of the PIAs have a bug where they always default to the OS Regional Locale and disregard what we pass in.

The “fix” on our side (which we’ve done in our V2 code base) was to write code that checks what call are broken, catalog those calls, and then wrap them in an alternate custom method

The workaround till then is to install the MUI pack or keep the regional setting set to the same as the Office install language.

Anonymous comments are disabled
 
Page view tracker