xll functions from the debug build does not work

39 views
Skip to first unread message

László Sleisz

unread,
Aug 13, 2025, 5:47:08 AMAug 13
to Excel-DNA
Hi,

My problem is that if I load the xll from the debug build, the functions does not work it gives back #value in the Excel. If load from the release, it works fine.

The build runs without errors, and the files in debug and release directories similar.
I use VS 2022, net472, ExcelDNA 1.8.0.

I would like to debug my function.

Thanks.

Laszlo

Govert van Drimmelen

unread,
Aug 13, 2025, 6:02:32 AMAug 13
to exce...@googlegroups.com

Hi Laszlo,

 

This is unexpected (it works fine for me and I have not heard of this problem before).

It might be that there are other dependencies of your code that are not in the Debug folder.

Then the code might fail when being Jit-compiled.

But I would expect to see something suspicious in the Debug Output window in Visual Studio if you are debugging Excel and loading the add-in.

 

You could try to add a new class with just a very simple function, and see whether it works.

You can also try to see whether there are exceptions in your code (being returned as #VALUE!) by wrapping the top-level function(s) in a try-catch and returning any exception information.

 

Otherwise, I suggest you start with a simple, new project, check that it works, then work towards your existing project until you see the issue.

 

-Govert

--
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 visit https://groups.google.com/d/msgid/exceldna/d0cb6581-54a2-4465-9bc4-3247473d2a7en%40googlegroups.com.

Reply all
Reply to author
Forward
0 new messages