Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am developing an Qlikview Application and I want the information about all the sheets and objects that are hidden or not.
Is there a way to achieve this ?
Problem arises in using Objects = ss.GetSheetObjects and when I try to extract information from different objects on the sheet i.e copy bitmap to clipboard etc. In the case of the hidden objects it constantly copies the last unhidden objects image to clipboard.
I am using vbscript.
Hii,
I am not sure what you actually want to know.
But as per my understanding you can refer Setting/Document Property/Sheets tab.
It will give you all the information regarding Sheets, Objects which are active and hidden.
Thanks & Regards
Greg
Hi Lokesh,
Maybe Crtl + Alt + E (Expression Overview) helps you.
There's a 'show conditions' option for hidden objects.
Regards
Hi,
Press Ctrl+Alt+D, Go to Sheets tab and you can see all hidden sheets and objects (see below). Or if you want to see all hidden objects then simply press Ctrl+Shift+S.
Yes what are all the objects in the sheet can be seen in Sheet Properties->Shets