Nested ExcelDna functions give #NAME? when calculating with F9

[lindsayt...@gmail.com]

Hi, hoping someone can help me here :)

I get an error when selecting the contents of a cell using F2 and then clicking F9 when I am using a function that has more than one function nested within it. Usually this should calculate the value and replace the formula with the calculated result. 

Please see my example below:

TestInner1() returns 2 and TestInner2() returns 3, TestOuter(a, b, c, d) multiplies the parameters passed to it.

For B5-B7 I clicked on the cell, F2, then F9 to calculate. As you can see with B6 and B7 (function used shown in the A column) I only pass one of my inner functions as a parameter. This works fine. However as shown in B5, when I pass two of my functions in as parameters then I get an error, #NAME?.

When I debug I can hit breakpoints in my code for the inner and outer functions for both B6 and B7 calculations, however for B5 none of my breakpoints are hit:

We have had great success using ExcelDna, this is just an odd behavior that one of the users noticed and hopefully there's a simple fix.

Thanks in advance,

Lindsay

[lindsayt...@gmail.com]

Any help here would be very much appreciated, thanks!

[Govert van Drimmelen]

--------------------------------------------------

Excel-DNA is now registered on https://github.com/sponsors/Excel-DNA.

Your monthly contribution encourages further development and support.

--------------------------------------------------

 

Hi Lindsay,

 

I can reproduce the problem with the F9 evaluation too.

This looks like an Excel bug when F9-evaluating functions from an .xll add-in.

To confirm this, I checked with a native code add-in sample from the Excel SDK.

So I’m sure Excel-DNA is not involved in this behaviour.

 

To report this to the Excel team can be tricky.

If you have a large corporate account with Microsoft, you might try to work through your account executive.

Otherwise you might try to get a helpful Excel MVP like Charles Williams involved directly.

 

I have not yet had any success reporting such bugs through the Office support channel, or the paid-for Microsoft developer support.

 

-Govert

 

 

From: exce...@googlegroups.com <exce...@googlegroups.com> On Behalf Of lindsayt...@gmail.com
Sent: 7 March 2022 13:47
To: Excel-DNA <exce...@googlegroups.com>
Subject: [ExcelDna] Re: Nested ExcelDna functions give #NAME? when calculating with F9

 

Any help here would be very much appreciated, thanks!

On Wednesday, 2 March 2022 at 14:39:53 UTC+2 lindsayt...@gmail.com wrote:

Hi, hoping someone can help me here :)

 

I get an error when selecting the contents of a cell using F2 and then clicking F9 when I am using a function that has more than one function nested within it. Usually this should calculate the value and replace the formula with the calculated result. 

 

Please see my example below:

 

TestInner1() returns 2 and TestInner2() returns 3, TestOuter(a, b, c, d) multiplies the parameters passed to it.

For B5-B7 I clicked on the cell, F2, then F9 to calculate. As you can see with B6 and B7 (function used shown in the A column) I only pass one of my inner functions as a parameter. This works fine. However as shown in B5, when I pass two of my functions in as parameters then I get an error, #NAME?.

When I debug I can hit breakpoints in my code for the inner and outer functions for both B6 and B7 calculations, however for B5 none of my breakpoints are hit:

 

We have had great success using ExcelDna, this is just an odd behavior that one of the users noticed and hopefully there's a simple fix.

 

Thanks in advance,

Lindsay

 

 

 

--
You received this message because you are subscribed to the Google Groups "Excel-DNA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to exceldna+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/exceldna/898e53ff-c7e4-4bd2-89d8-585a14d676bcn%40googlegroups.com.

[lindsayt...@gmail.com]

Hi Govert,

It works fine when nesting built in Excel functions. As you said, must be an issue just with the xll based UDF's. Probably not enough of an issue to chase Microsoft on it. 

But, once again, thanks for all your effort with ExcelDna!

Regards,

Lindsay

On Monday, 7 March 2022 at 15:26:07 UTC+2 Govert van Drimmelen wrote:

--------------------------------------------------

Excel-DNA is now registered on https://github.com/sponsors/Excel-DNA.

Your monthly contribution encourages further development and support.

--------------------------------------------------

 

Hi Lindsay,

 

I can reproduce the problem with the F9 evaluation too.

This looks like an Excel bug when F9-evaluating functions from an .xll add-in.

To confirm this, I checked with a native code add-in sample from the Excel SDK.

So I’m sure Excel-DNA is not involved in this behaviour.

 

To report this to the Excel team can be tricky.

If you have a large corporate account with Microsoft, you might try to work through your account executive.

Otherwise you might try to get a helpful Excel MVP like Charles Williams involved directly.

 

I have not yet had any success reporting such bugs through the Office support channel, or the paid-for Microsoft developer support.

 

-Govert

Sent: 7 March 2022 13:47
To: Excel-DNA <exce...@googlegroups.com>
Subject: [ExcelDna] Re: Nested ExcelDna functions give #NAME? when calculating with F9

 

Any help here would be very much appreciated, thanks!

On Wednesday, 2 March 2022 at 14:39:53 UTC+2: