Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
jonnyb
Partner
Partner

how to crop and export sheet to clipboard?

Hi guys,

I want to export a QlikView sheet to ClipBoard with a Macro, but I'm having problems to put a cropped image on the ClipBoard, e.g. I want to cut 100px from the left, 200px from the bottom and 50px from the top.

Thank you in advance

--Macro code

Sub ExportCroppedImgToClipBoard

'Needs to crop the image before I put it in ClipBoard

ActiveDocument.Activesheet.CopyBitmapToClipboard


end sub

regards,

Jonny

1 Reply
jonbrough
Specialist
Specialist

That sounds quite ambitous. You can perform a zoom on the sheet size:

rem ** fit active sheet to window **

ActiveDocument.ActiveSheet.FitZoomToWindow

rem ** apply same zoom to all sheets **

ActiveDocument.ActiveSheet.ApplyZoomToAllSheets

Apparantly there is also a clipboard zoom, though I'm not sure what that does:

set up = ActiveDocument.GetApplication.GetUserPreferences

up.ClipboardZoom = 200

ActiveDocument.GetApplication.SetUserPreferences up

Jonathan