[Bug 64256] New: Chart PIE

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 64256] New: Chart PIE

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64256

            Bug ID: 64256
           Summary: Chart PIE
           Product: POI
           Version: 4.1.x-dev
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

Created attachment 37116
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=37116&action=edit
image bugs and image google sheets

By opening an xlsx file generated with apache poi-ooxml 4.1.2, it enters
recovery mode by deleting the pie chart.
Instead on google sheets it works!!!!!

Bye
Francesco

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 64256] Chart PIE

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=64256

--- Comment #1 from Francesco Baldi <[hidden email]> ---
this is the code implemented:


private Integer generateChart(XSSFSheet worksheet, String seriesChart, String
keyChart, ExcelChart excelChart, Integer indexRow, String xAxis) {
                // ExcelChart
                //
excelChart=sheetData.getClass().getAnnotation(ExcelChart.class)
                XSSFDrawing drawing = worksheet.createDrawingPatriarch();
                Integer startChart = indexRow;
                indexRow += excelChart.sizeRow();
                logger.debug("Start Chart: " + startChart);
                XSSFClientAnchor anchor = drawing.createAnchor(0, 0, 0, 0, 0,
startChart, excelChart.sizeColumn(), indexRow);

                XSSFChart chart = drawing.createChart(anchor);

                XDDFChartLegend legend = chart.getOrAddLegend();
                legend.setPosition(excelChart.legendPosition());
                XDDFCategoryAxis bottomAxis =
chart.createCategoryAxis(excelChart.categoryAxis());
                XDDFValueAxis leftAxis =
chart.createValueAxis(excelChart.valueAxis());
                logger.debug("-----------------xAxis: " + xAxis);
                XDDFDataSource<String> xs =
XDDFDataSourcesFactory.fromStringCellRange(worksheet,
CellRangeAddress.valueOf(xAxis));
                XDDFChartData chartData =
chart.createData(excelChart.chartTypes(), bottomAxis, leftAxis);
                XDDFChartData.Series series = null;
                logger.debug("------------seriesChart: " + seriesChart);
                series = chartData.addSeries(xs,
XDDFDataSourcesFactory.fromNumericCellRange(worksheet,
CellRangeAddress.valueOf(seriesChart)));
                series.setTitle(keyChart, null);
                series.setShowLeaderLines(true);

                chartData.setVaryColors(true);

                chart.plot(chartData);

                return indexRow;

        }

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]