Forum Discussion

sudarshan's avatar
sudarshan
New Contributor III
3 years ago

Globals object in a spreadsheet rule

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 sprea...
Methodology
  • NidhiMangtani's avatar
    NidhiMangtani
    3 years ago

    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.

sudarshan's avatar
sudarshan
New Contributor III

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's avatar
NidhiMangtani
Contributor III
3 years ago

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.