Hello,
I created a COM-Visible assembly in C#.
I aim to use this assembly in Excel-VBA, for number-crunching.
It works perfectly in the "English(US)" regional settings.
It works perfectly in the "French(France)" regional settings for which the language pack is installed.
It works perfectly in the "Dutch(Netherlands)" regional settings for which the language pack is installed.
It fails in the "German(Germany)" regional settings for which the language pack is NOT installed.
It fails in the "French(Belgium)" regional settings for which the language pack is NOT installed.
It fails in the "Dutch(Belgium)" regional settings for which the language pack is NOT installed.
Failure occurs only when the exact type of the method parameters is not used.
If the exact type is passed to the method it always works, independently of the Regional Settings.
Note however that my Assembly does not -logically- need any Regional Settings to be used.
It is just pure number crunching which is involved.
But the numbers can be passed as a Cell (Range) object in some cases.
The funny thing is that there is NO language pack available for "French(Belgium)" or "Dutch(Belgium)".
Of course, asking end-users to change their regional settings is not really a good solution.
(unless the "French(Belgium)" or "Dutch(Belgium)" Regional Setting are really pure cosmetic without real use)
I would be interested to solve the problem somehow at the root instead of changing C# or VBA code.
(This would avoid me headaches!)
Any suggestion welcome!
Thanks
Michel
I created a COM-Visible assembly in C#.
I aim to use this assembly in Excel-VBA, for number-crunching.
It works perfectly in the "English(US)" regional settings.
It works perfectly in the "French(France)" regional settings for which the language pack is installed.
It works perfectly in the "Dutch(Netherlands)" regional settings for which the language pack is installed.
It fails in the "German(Germany)" regional settings for which the language pack is NOT installed.
It fails in the "French(Belgium)" regional settings for which the language pack is NOT installed.
It fails in the "Dutch(Belgium)" regional settings for which the language pack is NOT installed.
Failure occurs only when the exact type of the method parameters is not used.
If the exact type is passed to the method it always works, independently of the Regional Settings.
Note however that my Assembly does not -logically- need any Regional Settings to be used.
It is just pure number crunching which is involved.
But the numbers can be passed as a Cell (Range) object in some cases.
The funny thing is that there is NO language pack available for "French(Belgium)" or "Dutch(Belgium)".
Of course, asking end-users to change their regional settings is not really a good solution.
(unless the "French(Belgium)" or "Dutch(Belgium)" Regional Setting are really pure cosmetic without real use)
I would be interested to solve the problem somehow at the root instead of changing C# or VBA code.
(This would avoid me headaches!)
Any suggestion welcome!
Thanks
Michel
Last edited: