You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When something crashes in code executed, might be due to anything really, you generally get ExcelErrorNull returned from the toolkit. This type of error is not recognised as an error by the native =IFERROR( command in Excel.
This can be quite annoying when you want to set up a sheet to be ready to receive data from an adapter or similar, where a simple =IFERROR( do some stuff, "") can be a quite nice way to keep the sheet looking clean without to much hassle.
Would suggest a #VALUE or similar to be returned instead (not sure if there is like `#NULL' or similar that would be an even better fit), basically, something picked up by Excel as being an error.
Description:
When something crashes in code executed, might be due to anything really, you generally get
ExcelErrorNull
returned from the toolkit. This type of error is not recognised as an error by the native=IFERROR(
command in Excel.This can be quite annoying when you want to set up a sheet to be ready to receive data from an adapter or similar, where a simple
=IFERROR( do some stuff, "")
can be a quite nice way to keep the sheet looking clean without to much hassle.Would suggest a
#VALUE
or similar to be returned instead (not sure if there is like `#NULL' or similar that would be an even better fit), basically, something picked up by Excel as being an error.https://github.com/BHoM/Excel_Toolkit/blob/master/Excel_UI/Addin/AddIn_Converts.cs seem to be the main file handling this from my quick search! :)
The text was updated successfully, but these errors were encountered: