Problem with DateTime function

Add-in Express™ Support Service
That's what is more important than anything else

Problem with DateTime function
Changed behavior after upgrading from adxnet-v706-b4084-vs-pro to adxnet-v801-b4350-vs-pro 
Henri Pellemans


Guest


Hi at ADX,

I recently upgraded from adxnet-v706-b4084-vs-pro to adxnet-v801-b4350-vs-pro.

I use VS2010 Pro, Excel 2010 and Win7 PRO 64-bit, all with SPs.

Now I have a changed behavior in the following. I have a lot of XLL UDFs in which I use the DateTime type, a simple example: 



Public Shared Function tomorrow(ByVal today As DateTime) As DateTime
       Return today.AddDays(1)
End Function


If I put this function in a single Excel cell, say A2, and I put a date in A1, then "=tomorrow(A1)" generates the correct day.

If I name cell A1 by the name "today" then "=tomorrow(today)" also generates the correct day.

If I name the entire row 1 by the name "today" then "=tomorrow(today)" generates an error #EMPTY (in fact I get an error message in the Dutch language)

This happens in ADX for .NET version 8, not in version 7. I never had such a problem with version 7.

Has something changed in ADX? Or am I missing something?

Best regards,

Henri
Posted 05 Feb, 2016 09:17:57 Top
Andrei Smolin


Add-in Express team


Posts: 18825
 Joined: 2006-05-11
Hello Henri,

I try to reproduce this issue. What function and parameter descriptors do you have for that function?

Henri Pellemans writes:
If I name the entire row 1 by the name "today" then "=tomorrow(today)" generates an error


How do you handle passing a lot of values (I assume every cell in that row may contain a date or Null) to the function accepting a single parameter?


Andrei Smolin
Add-in Express Team Leader
Posted 08 Feb, 2016 08:08:35 Top
Henri Pellemans


Guest


Hi Andrei,

I will send you an Excel sheet, probably tomorrow.

I have not set any function / parameter descriptors.

Best regards,

Henri
Posted 09 Feb, 2016 05:50:51 Top
Andrei Smolin


Add-in Express team


Posts: 18825
 Joined: 2006-05-11
Ok. Will wait.


Andrei Smolin
Add-in Express Team Leader
Posted 09 Feb, 2016 06:07:07 Top
Henri Pellemans


Guest


I just have sent an Excel file and 2 VS2010 projects to you. I added a reference to this thread.

I could reproduce the issue easily.

Henri
Posted 09 Feb, 2016 11:46:54 Top
Andrei Smolin


Add-in Express team


Posts: 18825
 Joined: 2006-05-11
Hello Henri,

I've reproduced the issue. We are looking into it. I'll let you know about our results when I have any.


Andrei Smolin
Add-in Express Team Leader
Posted 10 Feb, 2016 06:56:46 Top
Andrei Smolin


Add-in Express team


Posts: 18825
 Joined: 2006-05-11
Henri,

In a couple of minutes I'll send you an email containing a download link for an assembly that fixes this issue and instructions on how to install the assembly.


Andrei Smolin
Add-in Express Team Leader
Posted 10 Feb, 2016 07:21:35 Top
Henri Pellemans


Guest


Hi Andrei, I downloaded the zip file. I will let you know the results.

Henri
Posted 10 Feb, 2016 09:36:46 Top