GetActiveSheetObjects returns ubound=-1 on ajax client

carolinnolte — Mon, 11 Mar 2013 12:36:35 GMT

Hi,

i need a little help.

What I want to do: I have a table which should open another tab on click in the table.

What I tryed: I used the document field event trigger to call a macro to do the stuff I need. In that macro I check if the click orginates from that table or from another sheet object (listbox, current selections), in that case nothing should be done.

My macro snippet:

objs=ActiveDocument.ActiveSheet.GetActiveSheetObjects

if ok = true then

'do my stuff

end if

I publish that on the Server and it works fine when I use IE and the Plugin, but if I use another browser or IE with full browser version it does not work.

Somehow there is no active sheet object, ubound(objs) returns -1

Any ideas how to solve my problem?

Thanks

for each obj in objs
     if obj.GetObjectId() = "Document\CH89" then
          ok = true
     end if
next

Re: GetActiveSheetObjects returns ubound=-1 on ajax client

carolinnolte — Wed, 13 Mar 2013 09:26:37 GMT

I found a workaround for my issue:

I duplicated the monitored field and added the field event trigger to that field. My table uses the duplicated field as dimension. If I click the table the macro is executed. So I don't need to check which sheet object is currently active.

topic Re: GetActiveSheetObjects returns ubound=-1 on ajax client in QlikView

GetActiveSheetObjects returns ubound=-1 on ajax client

Re: GetActiveSheetObjects returns ubound=-1 on ajax client