topic Re: Export Sheet as image not working propiertly in QlikView

Export Sheet as image not working propiertly

Tue, 29 Apr 2014 08:35:26 GMT

Hi,

I'm trying to do a macro to copy paste sheets into PPT and I'm finding an issue on this.

I've noticed that depending on the resolution of the screen the image that is pasted in PPT is changing. For exmple if the resolution is lower the image is croped.

I did the same manually (without macro) right clicking the sheet I want to copy and pasting it to PPT and nothing changes.

Did someone have this issue already?

Thanks

Re: Export Sheet as image not working propiertly

vijetas42 — Tue, 29 Apr 2014 09:02:22 GMT

Hi,

may be you haven't set the parameters like
with PPSlide.Shapes.Paste

.Left = 40

.Top = 130

.Width = 100

.Height = 275

end with

Re: Export Sheet as image not working propiertly

Tue, 29 Apr 2014 09:06:15 GMT

The problem is that the image is cropped just after paste. I mean, it is cropped in the clipboard already...

Re: Export Sheet as image not working propiertly

vijetas42 — Tue, 29 Apr 2014 09:19:03 GMT

HI,

You mean to say that you are not getting whole sheet image properly?

Re: Export Sheet as image not working propiertly

Tue, 29 Apr 2014 09:31:24 GMT

Exactly, I'm getting a partial image normally loosing the rightmost ot bottom part.

Re: Export Sheet as image not working propiertly

vijetas42 — Tue, 29 Apr 2014 09:46:08 GMT

Hi,

Instead of printing the full screen you should think on either create a report, which keeps then all necessary contents in a structured way or to send bookmarks or you can directly go to file->print sheet option and check once the print preview

Re: Export Sheet as image not working propiertly

Tue, 29 Apr 2014 09:49:00 GMT

I don't want to make a PDF report cause is a mess working with complex objects.

I need a support to be able to check the data offline so If I don't want a PDF I need a PPT and I'm fingind this issue...