Govert van Drimmelen

UDF in-sheet IntelliSense

4

I develop [Excel-DNA](https://github.com/Excel-DNA/), an Excel integration project similar to excel-d, but for the .NET languages. One of the extensions I've made is an add-in that allows in-sheet IntelliSense for UDF...

Support packing and loading of native and mixed assemblies and other files

1

Currently the packing mechanism only supports managed libraries, which can be loaded from memory without extracting to a file on disk. It would be convenient to support mixed and native...

Add support for new .NET 6 types

1

From this discussion: https://groups.google.com/g/exceldna/c/JtWnyEyJeM0 • Support for ValueTask return on ExcelFunction. (Need to convert ValueTask to Task using the "AsTask()" method) • Include DateOnly (native struct on .net 6.0) in...

Install expression formatter

2

This expression formatter looks useful: http://geekswithblogs.net/mrsteve/archive/2016/02/29/friendly-readable-expression-trees-debug-visualizer.aspx

Automatic wrapper generation for object handles

1

Object handles wrappers provide constructor and access functions for object instances (in contrast with the static methods currently supported by Excel-DNA). It would be convenient to generate these wrappers. One...

Support for type conversions in params array expansion

3

From this forum post: https://groups.google.com/d/topic/exceldna/l-grehDBLng/discussion. Currently we only support params arrays of primitive types - the expansion does not integrate with other type conversions. In preference to the suggested implementation...

Is this possible? See this discussion: https://groups.google.com/g/exceldna/c/34BpWR6iNqw

This comment on StackOverflow suggests that it doesn't: https://stackoverflow.com/questions/29279908/how-to-get-exceldna-work-with-r-net/29289258?noredirect=1#comment123852454_29289258

Create an async/IObservable Ping function

1

Motivated by [a recent Stackoverflow discussion](http://stackoverflow.com/questions/29866839/ping-function-makes-the-whole-excel-table-slow-unresponsive), I thought this would be a nice sample function to discuss the async / IObservable features.

Document behaviour of built-in functions with complex criteria

1

See https://exceljet.net/formula/xlookup-with-complex-multiple-criteria and https://groups.google.com/g/exceldna/c/bwXlP-OXfPM If seems that a formula like ``` =XLOOKUP(1,(LEFT(B5:B16)="x")*(C5:C16="east")*NOT(MONTH(D5:D16)=4),B5:E16) ``` is evaluated differently in Dynamic-Array aware Excel vs older Excel. In particular, the LEFT and MONTH functions...