topic Function not working : ActiveDocument.GetSheetObject("CH01").CopyTableToClipboard in QlikView

Function not working : ActiveDocument.GetSheetObject("CH01").CopyTableToClipboard

Mon, 19 Apr 2010 19:42:16 GMT

This function does not work on a server using AJAX (ZFC) client ( V9 SR3).

ActiveDocument.GetSheetObject("CH01").CopyTableToClipboard true

Is it a bug or a known "feature" ?

Is there any replacement function available in that case ?

Thanks

Philippe

Function not working : ActiveDocument.GetSheetObject("CH01").CopyTableToClipboard

Oleg_Troyansky — Mon, 19 Apr 2010 20:39:42 GMT

This is a "client side" API (think about it, you want to copy the chart into the clipboard of your client computer, right?) Those APIs cannot be supported under AJAX.

Under AJAX, you'll have to get things done via Server-side APIs only, or perhaps Actions (not sure to what extent they will work on AJAX, but it worth a try...)

Re. :Re: Function not working : ActiveDocument.GetSheetObject("CH01").CopyTableToClipboard

Tue, 20 Apr 2010 03:33:35 GMT

Thanks Oleg for the answer , Now I still have a problem.

How can I copy the contains of a chart table into an excel spreadsheet using a Macro.

I cannot do an export because the contains of the excel workbook is stored into different sheets with their proper name.

Thanks again

Philippe