Gauge in straight table not copied with automation

[happydays1967]

Hi, I have an application that contains several straight tables with a linear gauge for expression. I have automated export to Power Point, using vbscript macro in QlikView. My issue now is, when I manually copy the bitmap image of the table to clipboard and paste it in PowerPoint, the gauge shows. However, doint the same through automation copies the image of the table, but wihtout the gauge. In stead it is just a blank cell in the table.

I have used the GetApplication.WaitForIdle and also have tried GetApplication.Sleep 2000, both of which do not make any difference

....

'Restore the chart

if oChart.IsMinimized then

     oChart.Restore

end if

'wait for graph to calculate

oDoc.GetApplication.WaitForIdle

'and wait a little more, just to be sure

oDoc.GetApplication.sleep 2000

'Copy to clipboard

oChart.CopyBitMapToClipBoard

.... (paste image in PPT etc......

Could not find a similar issue with a solution here. Anyone experiencing the same?

QV 11.0.11440.0 SR2  32 bit on win7 64

All suggestions/help is welcome!

Thanks in advance,

Hans Peter

[marcus_sommer]

It sounds quite strange - maybe you put the WaitForIdle and/or Sleep between the copy- and paste-statement, too. Further you should look to the background-color from the chart maybe it's transparent which could cause problems - set it for testing to white.

- Marcus

[happydays1967]

Thanks, I will give it a try and post results

HP

[gchampion]

I've got exactly the same problem.

Exporting in PNG/JPEG automatically a straight table that contains Gauge or Minichart. Column that contains minichart or Gauge doesn't appear in the the Excel (column are empty).

Did you solve it ?

[happydays1967]

Nope, tried all suggestions, but to no avail. Thankfully it is only for one report, so for now I replace it manually.

Open to any suggestions!

HP