I’ve written a small script that converts a given XLSX into a PDF, and it works like a charm, except for one minor thing that I’m very confused about: merged borders have a super tiny bit of space between them.
For reference, here’s the view from within Microsoft Excel 365: grafik.png (723 Bytes)
And after zooming in on the exported PDF created by Aspose.Cells: grafik.png (14.2 KB)
I know this is a super petty complaint, but I’d still like to see this fixed or get a workaround.
PS: I’m also curious why the text isn’t properly vertically centered after PDF export.
@Selbi,
Could you please share your source template file and sample code which you have used for testing? We will use this information to reproduce the issue here and provide assistance accordingly.
I did evaluate your issue a bit. I am afraid, I could not see the issue. I opened your both files into Adobe acrobat and set zoom values, e.g 400%, 800% or above but still could not see the difference or issue. Could you share some screenshots comparing Aspose output Vs Office output taken in Adobe acrobat to highlight the issue, we will check it soon.
We noticed those tiny lines/space (seen only when using higher zoom values) when viewing the file into FireFox. Aspose.Cells generates PDF files to display for Adobe acrobat and it follows Adobe acrobat standards in most cases. But if you still want us to evaluate the issue, we can log a ticket for investigation into our database, please confirm?
@Selbi,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.
This issue has been logged as
CELLSJAVA-43045 – Tiny space in border after converting Excel to PDF
Please try the following sample code, it will figure out your issue:
e.g Sample code:
Workbook workbook = new Workbook("bordertest.xlsx");
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
pdfSaveOptions.setOptimizationType(PdfOptimizationType.MINIMUM_SIZE);
workbook.save(outFile.pdf, pdfSaveOptions);
The output will be better. The option PdfOptimizationType.MINIMUM_SIZE will try to merge some border lines but it does not work for double border line type.
You will see in the output PDF, the tiny space disappears for the first two lines, but does not work for the third line.