Bubble chart image not correct

I am creating charts and embedding them to powerpoint. The bubble chart image which is set to the OLEObject frame is not correct. So, After activation, the scale of the chart and the chart itself looks different. The embeded actual chart is correct, but it appears that tha image is not generated correctly. I am using Aspose.Cells - 4.8.0.12

Hi,

Thanks for providing us the template files.

We have tested the conversion Chart2Image and found the scaling of Value X and Value Y are not correct as you mentioned.
Your issue has been registered into our issue tracking system with an issue id: CELLSNET-11676.
We will update you soon on it.

Thank you.

This is another instance of the issue. Looks like this also is the same issue. In the bubble chart "image", the Legends Overlap, but after activation, the chart looks gud.

Please confirm that this issue is also related.

Hi,

Thank you for considering Aspose.

Please create a sample application with your template file to reproduce the issue and post it here. We will check it soon.

Thank You & Best Regards,

Hi,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. We have fixed your mentioned issue.

Thank You & Best Regards,

The chart plotting issues are resolved. Thanks for the support. I have few more issues related to the bubble chart -

I have chart1.xls

I perform the following steps -

1) Copy the chart frem the chartsheet to the datasheet
Chart chart = workbook.Worksheets[ChartSheet].Charts[0];
ChartShape shp = chart.ChartObject;
workbook.Worksheets[DataSheet].Shapes.AddCopy(shp,RowOffSet, 0, 0, 0);

2) Move it to the desired location on the datasheet

chart.Move(RowOffSet, 0, CHART_SIZE_IN_ROWS + _chartObj.RowOffSet, chartSizeInColumns);


Result is chart2.xls


3) remove the chartsheet

4) Set the legend position at top again - this is to avoid any legend overlap issues

chart.Calculate();
int y = chart.Legend.Y;
int height = chart.Legend.Height;
chart.PlotArea.Y = y + (int)(height * 4000f / chart.ChartObject.HeightPt) + 150;

step 4 is not executed correctly and it messes the chart up. the chart.Legend.Y is 0 and so are the other properties. It gives the messedchart.xls

Can you please look into the issue and suggest.

This is happening with other charts as well. Please suggest.

Hi,

Thank you for considering Aspose.

Please try the attached latest version of Aspose.Cells. We have fixed the bug of setting position of plot area.

Thank You & Best Regards,

In most of the cases it works but there is still an issue in few cases. Attached is one such presentation.

Hi,

Thanks for providing us the template file.

We found the issue after an initial test, we have reopened the issue:CELLSNET-11676. We will keep you updated about the issue.

Thank you.

Hi,

Please try the attached version,

<span style=“font-family: “Arial”,“sans-serif”;”>We have fixed
the scaling issue for bubble chart.


Thank you.

This version does not fix the issue. Infact the chart itself is not visible on activation. Please see the attached.

Looks like there are major issues in 4.8.2.2

I have attached a files

Multiple Bar_old.xls - created using 4.8.1.2

Multiple Bar_new.xls - created using 4.8.2.2. This files openes differently in Excel 2007 and Excel 2003. In Excel 2007, the legends move to bottom left and overlap the chart while in Excel 2003, the chart area is moved down. I suggest you to revert back the changes or to fix these issues.

Hi,

Please post your project(sample codes) how you created the chart(s), so, that we may look into your issue.

Thank you.

The issues you have found earlier (filed as CELLSNET-11676) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.

Hi,

Not Fixed, scale changes after double clicking. Attached is the document for troubleshooting.

Hi,

We found the x/y axis scaling issue as you have mentioned after an initial test, we will figure it out.

Your issue has been logged into our issue tracking system with an issue id: CELLSNET-16129.

Thank you.

Hi,

Is there any updates on this issue. Let me know if you need any inputs on this.

Hi,

We will try to provide you the fix before the end of this week.

Thank you.

Hi,

Please try the attached version.

We have changed the rules of calculating axis scales for bubble chart and fixed this issue.When we checked the bubble charts template file(s) you provided to us, there is some difference comparing to Excel. We think that is not too bad and won’t affect the results either. So, we think this fix would be fine for your needs. Please try it and let us know if it works fine for your scenario.

Thank you.