You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "Le Vinh Dat (Kevin)" <vi...@gmail.com> on 2010/08/18 06:12:58 UTC

Related issues for graph in POI 3.7 beta 2

Hi all,
I'm using POI 3.7  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;
   }
}

Is there any workaround?

Thank you very much :-)
Sincerely yours,
Le Vinh Dat, Kevin