Excel-DNA / Excel-DNA/ExcelDna
Function returns a #VALUE! when it should return #NAME?
Open
- Dominant language
- C#
- Stars
- 1.5k
- Forks
- 292
- Avg merge
- 20d 12h
- Merged PRs (30d)
- 1
Description
Hello guys!
In Excel:
`=HelloWorld(TRUF)`
Returns `"Hello World!"` even if parameter `TRUF` returns `#NAME?` in Function Argument Window (`Ctrl + A`).
`=HelloWorld(TRUF)` should return `#NAME?`.
C# Code:
```C#
using ExcelDna.Integration;
public static class MyFunctions
{
[ExcelFunction(Description = "Hello world")]
public static string HelloWorld(
[ExcelArgument("True or False?")] bool foo)
{
return "Hello World!";
}
}
```
Thanks
Contributor guide
Assessment
This issue has not been assessed yet.