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?
The code:
Error log when this spreadsheet rule is used:
But if I comment out line number 24, the error log becomes:
Yes that should work.
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.
Hi Sudarshan,
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.
Thanks,
Bharti
Hi Bharti,
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.
Thanks
Yes that should work.
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.
