Hi all,

We are using Excel for reporting in our organization.
Basically there is a Java web application which instantiates Excel 2007 with an XLA. This XLA opens a Report Template(an .xls file, name supplied as command line parameter). The Template has a data sheet where we have multiple ranges and the Report sheet which shows the final report based on the data from the DataSheet. The ReportSheet contains formulas to show the final output. It could contain Charts/Graphs also. The data is fetched from SQL server and is pasted on the Ranges. And finally when all the data is pasted and Macro is run the Template is saved as a Final Report somewhere on the Report Server.

The Excel runs in the background in all this process. There could be multiple instances of Excel running on the same box. The instances run under separate WindowStation.

In this process when we try to Paste Charts/Graphs as Pictures following things are observed.
1. Axes values of the Graphs are changed i.e. if the Axes values are like 0, 5, 10, 15 then the values are changed like 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15
2. The Graph legends are kind of blurred
3. The Category(X) Axes are blurred.
4. Overall the Graph is blurred
In case of PieCharts
5. The values are placed on the chart itself whereas originally they are outside the piechart.
6. The legends are not readable
7. The Piechart is overall blurred.

The code used to paste charts as pictures, when run separately in the Excel application (not in the process) works perfectly and converts graphs to pictures as it is, without any distortion, blurring or skewing.

Why?

Any help appreciated.

Thanks in advance.