FW: Fwd: Excel Addin problem.

[eric.ehlers]

Apparently the message below that i sent yesterday didn't get
through because the sourceforge mailing lists appear to be blocking
mail from gmail? ...

Hi Jim

There's an outstanding issue with functions not being unregistered
when the addin is unloaded, as mentioned in a previous thread Excel's
xlfUnregister function is broken. I'm aware of a workaround which
involves re-registering a dummy hidden function and that might be a
solution.

But I'm not sure that's the issue you're referring to -
- If you stop and restart Excel, does that resolve the problem?
- Are you trying to keep two different versions of QuantLibAddin
available concurrently on one machine? Or are you talking about a
permanent one-off upgrade from an older version to a newer one?
- Are you loading the XLL via the addin manager or with File/Open?

If you could send me instructions for recreating the problem I'll try
to provide a fix.

Regards,
Eric

On 1/27/06, zheng wang wrote:
>
>
> zheng wang wrote:
>
>
> I am running into a problem in using the quantlib addin, which is not
> removing the old copy when the new version is loaded. does anyone have
> information on how to fix the problem?
> Thanks.
> -Jim

[Daniele De Francesco-2]

I couldn't the previous thread about xlfUnregister.
May I ask which version of Excel was mentioned there? We are currently
able to use it in versions 97 and 2002, and I'm very curious to know if
it's broken only in other versions or those too.

Thanks!

[hidden email] wrote:

> Apparently the message below that i sent yesterday didn't get
> through because the sourceforge mailing lists appear to be blocking
> mail from gmail? ...
>
> Hi Jim
>
> There's an outstanding issue with functions not being unregistered
> when the addin is unloaded, as mentioned in a previous thread Excel's
> xlfUnregister function is broken. I'm aware of a workaround which
> involves re-registering a dummy hidden function and that might be a
> solution.
>
> But I'm not sure that's the issue you're referring to -
> - If you stop and restart Excel, does that resolve the problem?
> - Are you trying to keep two different versions of QuantLibAddin
> available concurrently on one machine? Or are you talking about a
> permanent one-off upgrade from an older version to a newer one?
> - Are you loading the XLL via the addin manager or with File/Open?
>
> If you could send me instructions for recreating the problem I'll try
> to provide a fix.
>
> Regards,
> Eric
>
> On 1/27/06, zheng wang wrote:
>  >
>  >
>  > zheng wang wrote:
>  >
>  >
>  > I am running into a problem in using the quantlib addin, which is not
>  > removing the old copy when the new version is loaded. does anyone have
>  > information on how to fix the problem?
>  > Thanks.
>  > -Jim

[eric ehlers]

Hi Daniele

My understanding is that xlfUnregister is broken for all versions of
Excel.  A workaround is to first re-register the function as a hidden
function, after which xlfUnregister can be used to successfully
unregister the function.  This is now implemented in CVS for the next
release of ObjectHandler/QuantLibAddin.

Is it possible that this same workaround is in use at your site?  If
not could you explain how you unregister functions?

Regards,
Eric

On 1/31/06, Daniele De Francesco <[hidden email]> wrote:

> I couldn't the previous thread about xlfUnregister.
> May I ask which version of Excel was mentioned there? We are currently
> able to use it in versions 97 and 2002, and I'm very curious to know if
> it's broken only in other versions or those too.
>
> Thanks!
>
> [hidden email] wrote:
> > Apparently the message below that i sent yesterday didn't get
> > through because the sourceforge mailing lists appear to be blocking
> > mail from gmail? ...
> >
> > Hi Jim
> >
> > There's an outstanding issue with functions not being unregistered
> > when the addin is unloaded, as mentioned in a previous thread Excel's
> > xlfUnregister function is broken. I'm aware of a workaround which
> > involves re-registering a dummy hidden function and that might be a
> > solution.
> >
> > But I'm not sure that's the issue you're referring to -
> > - If you stop and restart Excel, does that resolve the problem?
> > - Are you trying to keep two different versions of QuantLibAddin
> > available concurrently on one machine? Or are you talking about a
> > permanent one-off upgrade from an older version to a newer one?
> > - Are you loading the XLL via the addin manager or with File/Open?
> >
> > If you could send me instructions for recreating the problem I'll try
> > to provide a fix.
> >
> > Regards,
> > Eric
> >
> > On 1/27/06, zheng wang wrote:
> >  >
> >  >
> >  > zheng wang wrote:
> >  >
> >  >
> >  > I am running into a problem in using the quantlib addin, which is not
> >  > removing the old copy when the new version is loaded. does anyone have
> >  > information on how to fix the problem?
> >  > Thanks.
> >  > -Jim
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
> _______________________________________________
> Quantlib-users mailing list
> [hidden email]
> https://lists.sourceforge.net/lists/listinfo/quantlib-users
>