Links are not properly converted from Excel to Pdf

Hi

Links are not converted correctly from Excel to Pdf.
Please find attached an example (Excel with 2 tabs).

Could you investigate?


Kind regards,

Bart Maes
Docbyte

Hi,

Thanks for your posting and using Aspose.Cells.

Please download and try the latest version: Aspose.Cells
for Java v8.3.0.4
it generates correct output file with good links.

I have tested this issue with the latest version with the following code and attached the output pdf with good links generated by it for your reference.

Java


String filePath = “F:\Shak-Data-RW\Downloads\Excel_linken.xlsx”;


Workbook workbook = new Workbook(filePath);


workbook.save(filePath + “.outj.pdf”);

Hi Shakeel

When I test this file with the new Aspose.Cells for
Java 8.3.0.4, the links on the first page are fixed. However, on the second page, the click field of the link has the original width, while only a small piece of the link is visible.


Kind regards,

Bart Maes
Docbyte

Hi,

Thanks for your feedback and sample PDF file.

Docbyte:
Hi Shakeel

.... However, on the second page, the click field of the link has the original width, while only a small piece of the link is visible.


This is due to the fact that in your original file's second sheet, the width of the first column is minimal which does not show the link completely either (you may confirm this by taking the print preview of the second sheet in Ms Excel manually). The best way to cope with it, you may extend the first column width or apply Auto-fit column function so your columns should be extended enough to show the full link, you may add a line before rendering to PDF:
e.g
Sample code:

workbook.getWorksheets().get(1).autoFitColumn(0);

it would work fine for your needs.

Thank you.