Formula editor issue?

Apr 19, 2012 at 2:56 PM



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"; }

Apr 19, 2012 at 3:11 PM


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.


Apr 19, 2012 at 3: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