Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

CopyBitmapToClipboard from non-active sheet problem

Hi guys,

I'm developing a macro for transferring charts from Qv to PPoint. Everything works perfectly well with the function CopyBitmapToClipboard on a sheet object unless I try to copy the bitmap from the object on a non-active sheet.

So, CopyBitmapToClipboard successfully copies the object bitmap to clipboard and returns TRUE only for the objects on an active sheet. For the objects on any other sheet the function returns FALSE and does not change the clipboard.

All the examples that I found on the forum use the function only for the objects on the current sheet... Did anybody face this problem? Are there any solutions?

Thanks!

Valera

1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

CopyBitmapToClipboard from non-active sheet problem

OK, the problem has been solved.

In fact, before calling the object's CopyBitmapToClipboard it is necessary to activate the sheet where the object is located and - what is more important - to wait for system idle.

It looks like this:

obj.GetSheet.Activate

ActiveDocument.GetApplication.WaitForIdle

obj.CopyBitmapToClipboard

Valera

View solution in original post

2 Replies
Highlighted
Creator II
Creator II

CopyBitmapToClipboard from non-active sheet problem

OK, the problem has been solved.

In fact, before calling the object's CopyBitmapToClipboard it is necessary to activate the sheet where the object is located and - what is more important - to wait for system idle.

It looks like this:

obj.GetSheet.Activate

ActiveDocument.GetApplication.WaitForIdle

obj.CopyBitmapToClipboard

Valera

View solution in original post

Highlighted
Not applicable

CopyBitmapToClipboard from non-active sheet problem

Could you be so nice and post the whole example. i tried similar but it does not work.

Thank you in advance.

M