XLL Plus for Visual Studio 2010 - Support

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Support Forum

XLL Plus for Visual Studio 2010 AZZEDINE_BOUDEMIA [Switzerland] 03-May-2011 16:53:09

I have an application using XLL+ and I am facing with following issue:
Function having 1 argument as string. When I call this function manually, it works but when I set Calculation Options to Automatic, the passed argument seems to be initialized to null.
XLL Addins settings of the function are as following:
Cache results checked
Create asynchronous version checked
Extension can fail checked.

Issue occurs when we have several cells calling this function with different arguments.

testfunction(arg1, arg2) where arg1 is an int32 and arg2 a string.
Reply

RE: XLL Plus for Visual Studio 2010 support@componentsource.com 04-May-2011 08:46:46

Response from Planatech Support:

Please email the following to support at planatechsolutions.com:

The generated code of the function (please remove any code you have added by hand).

The version number and license number of XLL+ (use the Tools/About XLL+... menu in the XLL Add-ins window of Visual Studio, and click Copy).

The language(s), version(s) and build(s) of Excel under which the problem is occurring.

The version of Visual Studio you are using.

The language and version of the operating system.

Any other information that may be helpful as we try to reproduce the problem.
Reply

RE: RE: XLL Plus for Visual Studio 2010 AZZEDINE_BOUDEMIA [Switzerland] 06-May-2011 08:05:30

1) The generated code of the function:
The RTD cache is used together with Create aynchronous version and Execution can fail.
// Function: Cvgudf.ExCvgMetaDataValue2Async
// Purpose:

//{{XLP_SRC(Cvgudf.ExCvgMetaDataValue2Async)
// NOTE - the FunctionWizard will add and remove mapping code here.
// DO NOT EDIT what you see in these blocks of generated code!

#pragma region Cvgudf.ExCvgMetaDataValue2Async support code
IMPLEMENT_XLLFN3(Cvgudf_ExCvgMetaDataValue2Async,
Cvgudf_ExCvgMetaDataValue2Async_4,
Cvgudf_ExCvgMetaDataValue2Async_12, "RJC", "UJC%",
L"Cvgudf.ExCvgMetaDataValue2Async", 0, L"productId,dat"
L"aName", 0, L"14", 0, L"", 0, L"\0\0", 0, 0, L"{Cvgud"
L"f.ExCvgMetaDataValue2Async,,,{},14,1,0,U,{{0,{produc"
L"tId,Int,0,,,,,,}},{0,{dataName,String,0,,,,,,}}},{},"
L"3,,0,0}", 1)
CXlOper* Cvgudf_ExCvgMetaDataValue2Async_Impl(CXlOper&,
long, const CXlStringArg&);
...
#pragma endregion

CXlOper* Cvgudf_ExCvgMetaDataValue2Async_Impl(CXlOper&
xloResult, long productId, const CXlStringArg& dataName)
{

// Invoke static method Cargill.Eti.Convergence.Udf.Cvgudf.ExCvgMetaDataValue2Async
System::Object^ result__ = Cargill::Eti::Convergence::
Udf::Cvgudf::ExCvgMetaDataValue2Async(to_clr<System
::Int32>(productId), to_clr<System::String^>(
dataName));
xloResult = objectToXl(result__, _T(""));

return xloResult.Ret();
}
// End of generated code
//}}XLP_SRC
2) The version number and license number of XLL+ :
XLL+ for Visual Studio 2010
Version: 6.3.4.831
Build: VS100
3) The language(s), version(s) and build(s) of Excel under which the problem is occurring:
Excel 2007 English version
4) The version of Visual Studio you are using.
Microsoft Visual Studio 2010
Version 10.0.30319.1 RTMRel
Microsoft .NET Framework
Version 4.0.30319 RTMRel
5) The language and version of the operating system
English Windows XP professional version 2002 service Pack 3

Note:Error occurs when we set Calculation Options to Automatic
calling the function one by one, it works.
Reply