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
- CELLSJAVA-40960: Chart formatting - grid lines
- CELLSJAVA-40961: Chart formatting - graph lines
- CELLSJAVA-40962: Rendering of #N/A value
- CELLSJAVA-40963: Unwanted values on the chart bottom axis
- CELLSJAVA-40964: Changed Chart Axis value
- CELLSJAVA-40965: Merging of the title cells
I am unable to see your attachment (404 error).
I am using Java for this implementation, not .NET. I have tried the 8.2.0 version of the product and all problems persist. Including the missing symbols.
Right, I have run that test already. I still have the symbol rendering issues. I’ve attached the resulting pdf
I am operating on RedHat version 4.1.2-46 64bit. My JDK version is 1.7. I cannot provide the font files, but I have attached a list of the fonts we have available.
- Download the aforesaid fonts from this link.
- Place them in any accessible directory.
- Specify the font location using the statement CellsHelper.setFontDir(location to the fonts) at the start of your application.
- Load the spreadsheet in an instance of Workbook & save it back in the PDF format.
- Check the PDF properties for embedded font list.
Thanks for using Aspose.Cells for Java.
We have fixed the following issues
(CELLSJAVA-40962 - Aspose.Cells renders the #N/A value differently than MS Excel)
(CELLSJAVA-40965 - Cells run into each other in the PDF)
Please download and try this fix: Aspose.Cells for Java v184.108.40.206 and let us know your feedback.
This is the screenshot of my fonts
I was mistaken about the CELLSJAVA-40965 issue, my pdf looks the same as yours.
java.io.File f = new java.io.File(fontLocation + “arial.ttf”);
ArrayList fonts = new ArrayList();
fonts.add(fontLocation + “arial.ttf”);
Workbook book = new Workbook(input);
I was not. I am not sure how to demonstrate my problems to you since I have followed all the steps you have sent me, but the issue still persists.
System.setProperty(“Aspose.Cells.FontDirExc”, “C:/Users/Babar Raza/Desktop/ariel/”);
Workbook book = new Workbook(“D:/temp/AnimalExample.xlsx”);
- PDF generated with this code.
- PDF generated with code recently provided.