Ok, I'm pretty sure this is an Aspose bug.
All the other chart types, including the multi-series charts (stacked, high-low-close, candlestick...) export to excel as expected.
Aspose's demo code (available here) does not include a bubble chart example.
They recently released an update (Feb 27, 2013), tho' I don't see any bubble-chart related fixes.
http://www.aspose.com/docs/display/cellsnet/Introduction+to+Charts++and++its+Types
We currently use version 7.3.2, while the latest is 7.4.1. I've checked 7.4.1 into trunk for testing.
This also needs to be tested for Excel-2003 format and not just Excel-2007 format.
http://www.aspose.com/docs/display/cellsnet/Introduction+to+Charts++and++its+Types
We currently use version 7.3.2, while the latest is 7.4.1. I've checked 7.4.1 into trunk for testing.
This also needs to be tested for Excel-2003 format and not just Excel-2007 format.
An easy way to reproduce the issue with Aspose's own demo code:
[1] Get their demo code, available here. I used the Offline Java Demos, since the "Aspose.Cells Java Demos" code uses the old api & doesn't compile without heavy modification.
[2] Find AreaChart.java (in src\com\aspose\cells\demos\Workbooks\ChartTypes\AreaCharts)
[3] Compile
[a] either create a new project
[b] or copy AreaChart's methods into ADS (this is what I did)
[4] Execute AreaChart.CreateStaticReport(). This will output an Area chart.
[5] Now, change this line:
chartIndex = sheet.getCharts().add(ChartType.AREA, 5, 1, 29, 10);
to
chartIndex = sheet.getCharts().add(ChartType.BUBBLE, 5, 1, 29, 10);
[6] The bubble chart does not appear in excel.
[7] If you change ChartType to COLUMN_STACKED or STOCK_HIGH_LOW_CLOSE or any other chart type, it works. But Bubble does not work.
An easy way to reproduce the issue with Aspose's own demo code:
[1] Get their demo code, available here. I used the Offline Java Demos, since the "Aspose.Cells Java Demos" code uses the old api & doesn't compile without heavy modification.
[2] Find AreaChart.java (in src\com\aspose\cells\demos\Workbooks\ChartTypes\AreaCharts)
[3] Compile
[a] either create a new project
[b] or copy AreaChart's methods into ADS (this is what I did)
[4] Execute AreaChart.CreateStaticReport(). This will output an Area chart.
[5] Now, change this line:
chartIndex = sheet.getCharts().add(ChartType.AREA, 5, 1, 29, 10);
to
chartIndex = sheet.getCharts().add(ChartType.BUBBLE, 5, 1, 29, 10);
[6] The bubble chart does not appear in excel.
[7] If you change ChartType to COLUMN_STACKED or STOCK_HIGH_LOW_CLOSE or any other chart type, it works. But Bubble does not work.
It is also worth noting that the bubble chart fails to export in the v12 build from 10/22/2012 (using an aspc.jar of size 4,438 KB).
However, the bubble chart exports successfully in the build from 01/30/2012 (using an aspc.jar of size 2,924 KB). This build uses the old Aspose API.
It is also worth noting that the bubble chart fails to export in the v12 build from 10/22/2012 (using an aspc.jar of size 4,438 KB).
However, the bubble chart exports successfully in the build from 01/30/2012 (using an aspc.jar of size 2,924 KB). This build uses the old Aspose API.
I've logged an issue w/ aspose. Will communicate the outcome.
I've logged an issue w/ aspose. Will communicate the outcome.
Aspose has acknowledged this as a bug:
Aspose has acknowledged this as a bug:
Hi Matt, Aspose has posted an update. Please refer to the prior link and let us know whether that works for you or not.
Hi Matt, Aspose has posted an update. Please refer to the prior link and let us know whether that works for you or not.
Issue #8400 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 31650 |
No time estimate |
Ok, I'm pretty sure this is an Aspose bug.
All the other chart types, including the multi-series charts (stacked, high-low-close, candlestick...) export to excel as expected.
Aspose's demo code (available here) does not include a bubble chart example.
They recently released an update (Feb 27, 2013), tho' I don't see any bubble-chart related fixes.