quantlib-dev

[Quantlib-dev] Detecting calls from the Function Wizard.

[kimosabe <ka...@ka...>]

Here is a simple solution:

// Detects if UDF is being called from the function wizard.
template<class X>
inline bool in_function_wizard(void)
{
	return !Excel<X>(xlfGetTool, XOPER<X>(4), XOPER<X>(_T("Standard")),
XOPER<X>(1));
}

This uses the library from  http://xll.codeplex.com http://xll.codeplex.com
, but you get the idea. No need to enumerate windows like in the Excel SDK
example. Enjoy!
-- 
View this message in context: http://old.nabble.com/Detecting-calls-from-the-Function-Wizard.-tp34020083p34020083.html
Sent from the quantlib-dev mailing list archive at Nabble.com.

Re: [Quantlib-dev] Detecting calls from the Function Wizard.

[Eric E. <eri...@na...>]

Quoting kimosabe <ka...@ka...>:

>
> Here is a simple solution:
>
> // Detects if UDF is being called from the function wizard.
> template<class X>
> inline bool in_function_wizard(void)
> {
> 	return !Excel<X>(xlfGetTool, XOPER<X>(4), XOPER<X>(_T("Standard")),
> XOPER<X>(1));
> }
>
> This uses the library from  http://xll.codeplex.com http://xll.codeplex.com
> , but you get the idea. No need to enumerate windows like in the Excel SDK
> example. Enjoy!

Thank you.  I think that when our code was first written that trick  
must not have been known.  How does it work?

Regards,
Eric

===================================================
Eric Ehlers
nazcatech sprl | Brussels | http://www.nazcatech.be
* Distributed computing for pricing analytics
* Use Microsoft Excel as a client to the Grid

Re: [Quantlib-dev] Detecting calls from the Function Wizard.

[kimosabe <ka...@ka...>]

Aucune idée monsieur. I never use it myself, but a lot of people have asked
for this functionality.

My unpopular theory is that if you need to use it, then your function is too
slow.


Eric Ehlers-2 wrote:
> 
> Quoting kimosabe <ka...@ka...>:
> 
>>
>> Here is a simple solution:
>>
>> // Detects if UDF is being called from the function wizard.
>> template<class X>
>> inline bool in_function_wizard(void)
>> {
>> 	return !Excel<X>(xlfGetTool, XOPER<X>(4), XOPER<X>(_T("Standard")),
>> XOPER<X>(1));
>> }
>>
>> This uses the library from  http://xll.codeplex.com
>> http://xll.codeplex.com
>> , but you get the idea. No need to enumerate windows like in the Excel
>> SDK
>> example. Enjoy!
> 
> Thank you.  I think that when our code was first written that trick  
> must not have been known.  How does it work?
> 
> Regards,
> Eric
> 
> ===================================================
> Eric Ehlers
> nazcatech sprl | Brussels | http://www.nazcatech.be
> * Distributed computing for pricing analytics
> * Use Microsoft Excel as a client to the Grid
> 
> 
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and 
> threat landscape has changed and how IT managers can respond. Discussions 
> will include endpoint security, mobile security and the latest in malware 
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> QuantLib-dev mailing list
> Qua...@li...
> https://lists.sourceforge.net/lists/listinfo/quantlib-dev
> 
> 

-- 
View this message in context: http://old.nabble.com/Detecting-calls-from-the-Function-Wizard.-tp34020083p34053704.html
Sent from the quantlib-dev mailing list archive at Nabble.com.