When exporting chart as image from a workbook or to a file,
the format of the element inside the cart are not correctly converted.
See workboot and saved images
Windows 10 64 bits
Locale FR
chart.setChartType(ExcelChartType.Column3DClustered)
for (int i = 0; i < s.getPointNumber(); i++) {
final ChartDataPoint dp = s.getDataPoints().get(i);
dp.getDataLabels().setPosition(DataLabelPositionType.Automatic);
if (data.getFontName() != null && !data.getFontName().isBlank()) {
dp.getDataLabels().setFontName(data.getFontName());
}
}
Workbook workbook = new Workbook();
workbook.loadFromFile("dd0287fe-3894-4ebe-8b20-388293077842_charts.xlsx");
ExcelFont font = workbook.createFont();
font.setFontName("Calibri");
for (int j = 1; j < workbook.getWorksheets().getCount();j++){
Chart chart = workbook.getWorksheets().get(j).getCharts().get(0);
for (int i = 0; i < chart.getSeries().getCount();i++){
ChartSerie s = chart.getSeries().get(i);
s.getDataPoints().getDefaultDataPoint().getDataLabels().getTextArea().setFont(font);
}
}