05-27-2022 07:29 AM - last edited on 05-03-2023 12:00 PM by JackLacava
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:
Solved! Go to Solution.
05-27-2022 10:17 AM
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.
05-27-2022 09:33 AM - edited 05-27-2022 09:34 AM
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
05-27-2022 10:08 AM
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
05-27-2022 10:17 AM
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.