Login  Register

Error calling xlfGetDef Excel API function from Objecthandler's FunctionCall::callerName()

Posted by Slava Mazur on Aug 15, 2008; 6:07pm
URL: http://quantlib.414.s1.nabble.com/Error-calling-xlfGetDef-Excel-API-function-from-Objecthandler-s-FunctionCall-callerName-tp12192.html

Greetings,

Has anyone experienced such a behavior? It happens intermittently for
some spreadsheets in some circumstances and I cannot figure out why.
Also I couldn't find any details about xlfGetDef function.
If anyone knows could you please point me to?

Here are some details.  

The following function call inside FunctionCall::callerName() returns
xName->xltype = 16 meaning error:

Excel(xlfGetDef, &xName, 1, FunctionCall::instance().callerAddress());

The function returns an empty string in such a case. This may result in
duplicate object keys defined in different cells, which is totally
undesirable. So my questions are:

1. Does anyone know why the function fails?
2. Why ObjectHandler doesn't handle a possible error condition?
3. Wouldn't it better to return FunctionCall::instance().callerAddress()
instead of an empty string in such a case?

Thanks,

Slava Mazur




-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev