topic Re: Bug in CopyTextToClipboard in QlikView

Bug in CopyTextToClipboard

Thu, 30 May 2013 01:08:12 GMT

Using the QlikView API seems to produce erratic results. I'm making this call, which should be pretty simple;

ActiveDocument.GetSheetObject("TB15").CopyTextToClipboard

If I'm in the script module editor and click "Check" it works just fine and copies the data from the Table control to the clipboard. If I place a button on my screen with an action of "Run Macro" is does not work. Is there a trick to make this work like it should? I'm starting to see the API portion of QV is not very reliable.

Thanks,
Scott

Re: Bug in CopyTextToClipboard

EduardoAlexandredeFrancisco — Thu, 13 Feb 2014 12:40:06 GMT

using

CopyTableToClipboard

Re: Bug in CopyTextToClipboard

Sun, 15 Mar 2015 21:14:56 GMT

A couple years ago, we had large pastes causing a QlikView export to Excel to choke.

We discovered that if the end user already had another instance(s) of Excel running when using the CopyTableToClipBoard function, Excel didn't do its normal initialization and would not flush the Office 24page Clipboard. (Which is separate from the single page System clipboard.) So large pastes would choke if the Office Clipboard was already populated data from earlier copy/paste operations.

We also found that the vb command to clear the Office Clipboard was not reliable nor was the workaround of pushing 24 single cell clips.

We fell back to requiring users to close Excel before exporting.

Perhaps there is a better way?