|
Xavier N
Posts: 13
Joined: 2023-09-27
|
Hello Andrei, ADX Team,
Just a quick question about the possibility of integrating the new Excel error values into XLL functions...
When a native Excel function receives an error value as an argument, it returns that error value (the first error value encountered if more than one argument is an error).
For a few years now, Excel has been integrating functions that allow you to manage dynamic tables and manage large volumes of data,.... And new error codes can now be returned (eg: #SPILL, #GETTING_DATA)
In XLL functions developed using Addin Express, the arguments for which an error value is transmitted receive a value of type ADXExcelError (Enum). Addin Express detects the existence of all types of errors but the new error codes are systematically passed as #VALUE and it is not possible to return other error codes than those of the enumeration... Which violates a little the usual practice in Excel (Returns the error code).
Could Addin Express (in a future version) add the following error codes to the ADXExcelError enumeration (and pass them to the function arguments) ?
The new error codes are (Error Message, Int32 value, Excel.XlCVError enum (VBA/.Net) :
- #BLOCKED!, -2146826241, Excel.XlCVError.xlErrBlocked
- #CALC!, -2146826238, Excel.XlCVError.xlErrCalc
- #CONNECTION!, -2146826242, Excel.XlCVError.xlErrConnect
- #FIELD!, -2146826239, Excel.XlCVError.xlErrField
- #GETTING_DATA, -2146826245, Excel.XlCVError.xlErrGettingData
- #SPLILL!, -2146826243, Excel.XlCVError.xlErrSpill
- #UNKNOWN!, -2146826240, Excel.XlCVError.xlErrUnknown
Regards,
Xavier |
|
|
Andrei Smolin
Add-in Express team
Posts: 19096
Joined: 2006-05-11
|
Hello Xavier,
Thank you for pointing us to this!
I've filed this down to our issue-tracking DB under #23915. I expect that the next Add-in Express build - there's no ETA yet - will mark this task as completed.
Regards from Poland (GMT+1),
Andrei Smolin
Add-in Express Team Leader |
|
|
Xavier N
Posts: 13
Joined: 2023-09-27
|
Thanks a lot Andrei (and ADX Team)!
Regards, Xavier |
|
Forums
Topics
Search
Help
Login
Register