Even a simple globals.getObject("_ex") throws a object reference not found error. Is the use of the globals object prohibited inside a spreadsheet rule?
Error log when this spreadsheet rule is used:
But if I comment out line number 24, the error log becomes:
Solved! Go to Solution.
Try holding the object returned by getobject in a datatable or a string,
Dim dt As DataTable = globals.GetObject("Example")
Check if dt has any rows then access the same
Or in a string
Dim sGlobalObject As String = globals.GetObject("Example").ToString
Check if string is not null then use it.
Hope this helps.
Upon trying this I am still facing the same issue, the updated code:
The code is still failing when either trying to perform either a set or get operation on the globals object
This same piece of code works perfectly when executed in an extensibility rule. The only solution I can think of for this is to perform the global operations in an extensibility rule and return the object back to the spreadsheet by referencing it.