topic Re: Copy to Clipboard option not working for container object in QlikView

Copy to Clipboard option not working for container object

Anonymous — Tue, 21 Mar 2017 11:58:57 GMT

Hi all,

I am trying to copy the container object using Copy to Clipboard option but not able to copy the container,

Please help me out with this.

R/Murali.

Re: Copy to Clipboard option not working for container object

Anonymous — Tue, 21 Mar 2017 12:16:11 GMT

Hi murli, I have tried copying it as both object and as an image. Both works fine. Can you please add some info to your problem.

Re: Copy to Clipboard option not working for container object

rahulpawarb — Tue, 21 Mar 2017 12:45:43 GMT

Hello Murli,

Please check for Copy/Clone Sheet Objects option present under Security Tab of Sheet Properties (Alt + Ctrl + S). If it is deselected then select it and click OK. Post this you can able to copy the container object.

Please correct me if I misunderstood the scenario.

Regards!

Rahul

Re: Copy to Clipboard option not working for container object

Anonymous — Tue, 21 Mar 2017 12:53:14 GMT

Hi Rahul,

copy/clone option is enabled, still iam not able to copy.

R/Murali.

Re: Copy to Clipboard option not working for container object

Anonymous — Tue, 21 Mar 2017 12:57:14 GMT

Hi Shiva,

find the sample file below.

R/Murali

Re: Copy to Clipboard option not working for container object

stabben23 — Tue, 21 Mar 2017 13:20:20 GMT

Hi,

Your macroname is CopyCNR but you try to trigger macro copy, could that be Your problem?

Re: Copy to Clipboard option not working for container object

stabben23 — Tue, 21 Mar 2017 13:23:56 GMT

I'll think you have made a copy/past from another macro because you dont have the fieldnames in the macro inside the qvw.

Re: Copy to Clipboard option not working for container object

stabben23 — Tue, 21 Mar 2017 13:40:44 GMT

If you do like this you can save a png of the container to a path instead. Also change the trigger in the button to CopyCNR.

Sub CopyCNR
set ContractNr = ActiveDocument.fields("Sales Order ID").GetSelectedValues
If ContractNr.Count=1 Then
ActiveDocument.GetSheetObject("CT01").ExportBitmapToFile "C:\TEST\test.png" 'change path here
Else
Msgbox("Select one value.")
End If
End Sub

Re: Copy to Clipboard option not working for container object

Anonymous — Wed, 22 Mar 2017 06:48:44 GMT

Thanks Staffan, now iam able to copy container object.

R/Murali.