Hello,
I’m using Aspose.cells 8.3.0 for java and am having an issue where I convert an excel document generated by Aspose to PDF (just saving as PDF) and the underlined chart titles do not get converted. Below is the code sample, and I have attached the resulting xlsx and pdf output:
package com.my.test;
import com.aspose.cells.Chart;
import com.aspose.cells.ChartCollection;
import com.aspose.cells.ChartType;
import com.aspose.cells.FontUnderlineType;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;
import org.junit.Test;
public class TestChartTitle {
public void test_chart_title() throws Exception {
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.getWorksheets().get(0);
worksheet.getCells().get(0,0).putValue(“Blue”);
worksheet.getCells().get(1,0).putValue(“Red”);
worksheet.getCells().get(2,0).putValue(“Green”);
worksheet.getCells().get(0,1).putValue(55);
worksheet.getCells().get(1,1).putValue(35);
worksheet.getCells().get(2,1).putValue(10);
ChartCollection charts = worksheet.getCharts();
int chartIndex = charts.add(ChartType.PIE, 10, 0, 20, 5);
Chart chart = charts.get(chartIndex);
chart.getTitle().setText(“My Chart”);
chart.getTitle().getFont().setUnderline(FontUnderlineType.SINGLE);
int seriesNumber = chart.getNSeries().add(“B1:B3”, true);
workbook.save(“C:\temp\chart_test_excel.xlsx”);
workbook.save(“C:\temp\chart_test_pdf.pdf”);
}
}