Regional settings issue for client

[Demesh]

Hi!

We are currently having an issue where the remote app has different regional settings as the Session host it is connected to.

We have a session host which is hosting Excel as remote application, on the session host all regional settings are set to Dutch. Excel works as it should on the session host itself.
When a user connects to Excel using the Remote Desktop app or webclient their Excel application will be with US regional settings. Decimal and numbergrouping symbols and the date are wrong.

The devices of the users itself are also installed with the Dutch regional settings, it only occurs on Remote Applications.

We have forced the regional settings in Dutch with GPO and enabled time zone redirection.

I am looking for advice how we can enforce the session host to use the regional settings set on the session host. 

[#2]

@Demesh 

One possible solution to enforce the session host to use the regional settings set on the session host is to modify the registry settings on the remote desktop session host. Here are the steps you can follow:

1. On the remote desktop session host, open the Registry Editor by typing "regedit" in the Run command box or the Start menu search box.
2. Navigate to the following registry key:HKEY_USERS.DEFAULT\Control Panel\International
3. Check the values of the following registry entries:sDecimal sThousand sShortDate sLongDateMake sure that these values are set to the appropriate Dutch settings. If not, change them to the correct values.
4. If the values of the registry entries are correct, but the problem persists, you can try creating a new registry key called "UserOverrideKey" under the "International" key. Set the value of this key to "1". This will force the session host to use the regional settings of the user who is connecting to it.To create the "UserOverrideKey" key, follow these steps:
   • Right-click on the "International" key and select "New" > "DWORD (32-bit) Value".
   • Name the new value "UserOverrideKey".
   • Double-click on the "UserOverrideKey" value and set its value data to "1".
5. Close the Registry Editor and restart the remote desktop session host.

These steps should enforce the session host to use the regional settings set on the session host. If the problem persists, you may need to check the regional settings on the client devices as well to ensure they are set correctly.

It worked in my lab setup , would suggest you to make the changes in lab setup first, test it , then deploy it