Excel-DNA / Excel-DNA/ExcelDna

Function returns a #VALUE! when it should return #NAME?

Open
#157 18 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.