XLL - Function gives error even if it has been removed

Add-in Express™ Support Service
That's what is more important than anything else

XLL - Function gives error even if it has been removed
 
Roland Grau




Posts: 13
 Joined: 2014-05-05
Hello

We have an XLL that has 37 functions and all went fine so far.
Because of a special use case I had to duplicate the functions - all by designer work.

Right now I have an issue with 2 functions.

This is how I reproduce my issue:
- I undo all my previous work
- I duplicate the XLL static function FunctionA(string a)to FunctionB(string a)
- I add a new function to the designer called FunctionB
-> on starting I get the error: 'xlfRegister' failed. Function name: FunctionB

- I remove the functionB in the designer
- I add another function
-> on starting I get the error: 'xlfRegister' failed. Function name: FunctionB

So I don't get the initial error and I don't see why it keeps me telling about the removed function...

I'm using the version 7.5.4072 professional

I hope you can help me on this.
Thank you
Posted 29 Jul, 2014 10:13:47 Top
Andrei Smolin


Add-in Express team


Posts: 18829
 Joined: 2006-05-11
Hello Roland,

I cannot reproduce this by duplicating the AllSupportedExcelTypes method in a newly created XLL add-in project. If you can reproduce the issue on a sample add-in project, please send it to me. You can find the support email address in {Add-in Express installation folder}\readme.txt. Please make sure your email contains a link to this topic.


Andrei Smolin
Add-in Express Team Leader
Posted 30 Jul, 2014 02:29:00 Top
Andrei Smolin


Add-in Express team


Posts: 18829
 Joined: 2006-05-11
Hello Roland,

Thank you for sending me the project. I've reproduced the issue.

You need to modify your functions in accordance with section My XLL Add-in doesn't show descriptions at http://www.add-in-express.com/docs/net-excel-udf-tips.php#xll-no-descriptions.


Andrei Smolin
Add-in Express Team Leader
Posted 30 Jul, 2014 07:09:12 Top
Roland Grau




Posts: 13
 Joined: 2014-05-05
Hello Andrei

You are right, the parameter names exceeded the limit. It is working now.
But I don't get why 2 original functions threw an error.

Maybe you could improve the error messages or do some extra validation.

Thank you very much!

Regards
Roland
Posted 30 Jul, 2014 10:21:04 Top
Andrei Smolin


Add-in Express team


Posts: 18829
 Joined: 2006-05-11
Ronald,

We will look into this.


Andrei Smolin
Add-in Express Team Leader
Posted 31 Jul, 2014 02:35:56 Top