Hi all,
I'm using POI beta 2 and Excel 2003.
It seems that I hit 2 issues related to graph in POI 3.7 beta2.
1) Wrong series detection. Please see the attachment Incorrect series
detection.jpg
+ The title of the fourth series (i.e.: series[3]) is detected as % instead
of inf3.
+ If I remove %, it detects "inf3 correctly.
2) After I removed the series in 1 graph, there was no exception.
chart.removeSeries() even returned true.
However, Excel 2003 kept crashing and restarting when opening the output.
HSSFSeries[] series = chart.getSeries();
// Remove unused series
int num_of_series = series.length;
for(int j=0; j < num_of_series; j++)
{
if(series[j].getSeriesTitle().contains("inf3"))
{
chart.removeSeries(series[j]);
break;
}
}
Thank you very much :-)
Sincerely yours,
Le Vinh Dat, Kevin
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]