If I add an image to a chart (at runtime) and then convert the resulting file into a pdf file, the image is missing. How can I bypass this behavior? I add the image to the chart by the following lines of code:
We have found your mentioned issue after an initial test. We will look into it and get back to you soon. You issue has been registered in our issue tracking system with issue idCELLSNET-12203.
it works basically. But there seems to be a little problem with the positioning of the images left. Please take a look at the attached file. There you can see the location of the label in the generated excel file compared to the image location in the generated pdf file.
Yes, we found that the location of the image in the chart is not the same in the generated pdf file. We will figure it out soon. The issue has been logged into our issue tracking system with an issue id: CELLSNET-12336.
Hi, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
If I call chart.Calculate() before I save the workbook the position of the inserted image is in excel the same as in the pdf file.
Just one more question regarding the AddPictureInChart(int top, int left, …) method. I tried to rearrange the position of the image in the chart. If I change the first parameter called top, the images moves left or right. If I change the second one - called left - the images moves up or down. Is there something mixed up?
We have found your mentioned issue after an initial test. We will look into it and get back to you soon. Your issue has been registered in our issue tracking system with issue id CELLSNET-12442.
Now the parameter seems to work as expected. But there is a new problem with the positioning of the label in pdf. Please take a look at the attached files. You can find there the program, the initial excel file, the used logo as well as both (pdf and xls) generated files. It is clearly evident that there is a difference between xls and pdf.
Related to this topic I got to other points of interest.
It is possible to change the z-Order of the inserted logo? It should overlay the grid lines but it should not be overlay any kind of graph, shown in the chart.
It is possible to place the logo with offset x and y values that refers e.g. to the top left corner of the major grid lines. If I use the existing positioning approach the final position of the logo depends on the chart data. So it could happen, that there are often different logo positions throughout a long presentation.
the provided version doesn’t fix the problem completely. The image alignment fits only the top Gridline but it doesn’t fit the value axis. The picture is placed some centimeter to the right of the value axis.
Do you also consider the mentioned z-Order problem?
a)The picture is placed some
centimeter to the right of the value axis.
Could you create your desired chart in MS Excel and post it here? We will check it soon.
b) z-Order problem
The z-order should be same as the order of inserting shapes. If the grid lines are a part of the chart and not a shape in the chart’s shapes, we can change the display order of the chart’s object. We just work as MS Excel.
Please find attached a sample excel file that shows the desired logo position. I would like to use a small offset to place the logo to the top left corner of the plot area (independent of the plot area size).
Today I realized that my understanding of the z-Order arrangement of objects depends on the used excel version. I always tried to insert the logo as an image an place it in the chart. But the source file that I use as a template for our new report system created with excel 2007. There the logo is inserted as a background image and then shrunk to the needed size (this option seems to be not available in excel 2003).
By the way, I believe that I can solve this problem with a small workaround. I know that there is free place on the top left or right of the diagram. So I can decide the correct label position in my chart. It is possible to determine the top right corner of the plot area, too?