Globals object in a spreadsheet rule

[sudarshan]

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: 

[NidhiMangtani]

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

[sudarshan]

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

[NidhiMangtani · Accepted solution]

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.