UDF returns #VALUE! when regional language setting not English!?

  • Thread starter Thread starter Andrew Wiles
  • Start date Start date
A

Andrew Wiles

I have an automation add-in which works fine on my UK English configuration.
If I change the regional language settings in the control panel to Danish the
UDF fails and returns #VALUE!.

I have simplified this problem down to the point where the UDF is simply
returning a string so the problem cannot (I think) be in the UDF processing.

I am somewhat stumped as to where to go to resolve this problem.

Any thoughts?

Configuration is Excel 2007 on Vista x64
 
What's the code of your UDF and how exactly do you call it? With what values?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have an automation add-in which works fine on my UK English configuration.
| If I change the regional language settings in the control panel to Danish the
| UDF fails and returns #VALUE!.
|
| I have simplified this problem down to the point where the UDF is simply
| returning a string so the problem cannot (I think) be in the UDF processing.
|
| I am somewhat stumped as to where to go to resolve this problem.
|
| Any thoughts?
|
| Configuration is Excel 2007 on Vista x64
 
Nick

The important bits of the simplified code is as crude as follows. I removed
pretty much everything during my attempts to isolate the problem.

.....
using Extensibility;

[ClassInterface(ClassInterfaceType.AutoDual)]
public class I4XLFunctionLibrary : Extensibility.IDTExtensibility2
{

.....

public object I4XLQueryValue(string queryRef)
{
m_excelApp.Volatile(Type.Missing);
return "ABC";
}

I'm don't think that it will mak a dfference but the add-in is registered by
adding a Key to the registry under
HKLM\Software\Microsoft\Office\Excel\Addins and providing values for
Description, FriendlyName and importantly LoadBehavior=3
 
Back
Top