We are interested in using Aspose Cells to generate PDFs of our reports; however, there are a variety of style and formatting errors when converting the .XLSX files to PDF. We currently have licensing for 8.1.0, but I have also run watermarked versions in 8.1.2 to demonstrate that these issues persist through the current version of the product. These are toy examples, but they demonstrate the formatting issues that we are concerned with. The pdf files with just ____.pdf are 8.1.0 and those that are ____X.pdf are 8.1.2
Animal Example:
- Special Characters: in the xlsx file, we see diamond and delta characters in the title above the chart, however in both AnimalExample.pdf and AnimalExampleX.pdf, we see different characters.
- Chart formatting - gridlines: The secondary vertical gridlines in the pdf versions are not there
- Chart formatting - graph lines: the graphlines for the CATS and MICE datapoints aren’t visible in the pdfs. The dots are not connected, making it difficult to read the trend lines.
- #NA - In the charts below, we have #NA in the cells, but when we print the xlsx files directly, those conver to “-” but they stay as “#NA” in the pdf.
Cheese Example:
- Chart: the value numbers occur on the bottom axis of the chart for Creamy, Firm, Spreadable, Supple, Smooth, and Flaky when they are not supposed to. Additionally, Crumbly has other numbers within the column.
Fruit Example
- Title formatting: the titles of the last two columns run into each other in the PDF but not the xlsx document.
All of the pdf files are generated through the following code:
PdfSaveOptions opt = new PdfSaveOptions(SaveFormat.PDF);
opt.setAllColumnsInOnePagePerSheet(true); //makes each worksheet a page in the pdf
String fname = outFile;
FileOutputStream fos = new FileOutputStream(fname);
wb.save(fos, opt);
fos.close();