Formula editor issue?

Apr 19, 2012 at 1:56 PM

Hi,

 

I have an UDF exposed that take not arguments. From Excel 2010 when I insert the function I am prompted with the Formula Editor, I click OK and every thing work fine.

Why the Formula editor show up when I call an UDF that has no arguements? Do you know way to prevent this?

Thanks for any help,

[

ExcelFunction(Description = "Get the current substance list from ASPRO", Category ="my category")]

 public static string GetCurrentSubstanceList() { return "some data"; }

Coordinator
Apr 19, 2012 at 2:11 PM

Hi,

This is an old bug in the Excel C API. If you have a Microsoft account manager, please report it to them - that might encourage the Excel team to fix this for a future version of Excel.

The only workaround is to have no Description for your function.

-Govert

Apr 19, 2012 at 2:28 PM

thanks for the quick reply, this is a bummer! You workaround  work! I need to decide what is more improtant, no description vs the formula editor

Stephane