URLs in the excel file are altered in the generated PDF

Aspose.Cells Product Family
1

Hi,

There are several URLs in the excel. After the excel is converted to pdf using Aspose.Cells 7.4.3.0 , then some of the URLs in the excel are changed and are pointing to different lo0cation from the original.

I am attaching the source file for reference.

Thanks,

Shikha

2

Hi,

Thanks for your posting and using Aspose.Cells for Java.

Please download and try the latest version: Aspose.Cells
for Java v7.4.3.5 It works fine. We have attached the output file for your reference.

If you still find issue, please highlight them in a screenshot with red circles.

3

Hi,

Thanks for your reply.

Actually still the issue is not resolved. If you notice the Back up link (8rth from starting), adjacent to AML Document Templates in EDM Quality, is pointing to `http://aml-poqgmpdocs.amgen.com/Effective/Standard%20Operating%20Procedure/SOP-001131.pdf`

although the original link in the excel is `http://aml-poqgmpdocs.amgen.com/Effective/Standard%20Operating%20Procedure/SOP-013487.pdf`

Can you please look into this?

Also i can see that table columns are split into different pages. All the columns of the table should come into same page right?

I am attaching the screenshot.

Thanks,

Shikha

4

Hi,

Thanks for your posting and using Aspose.Cells for Java.

We were able to observe this issue. We have logged it in our database. We will look into it and resolve this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSJAVA-40535.

The page split is not an issue. Aspose.Cells renders the pdf in the same way as MS-Excel Print Preview. Since, your MS-Excel Print Preview displays the text and links in different pages, hence Aspose.Cells also shows it the same way.

However, you can force to print everything on a single page using the following code.

Java


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


Workbook workbook = new Workbook(filePath);


PdfSaveOptions opts = new PdfSaveOptions();

opts.setOnePagePerSheet(true);


workbook.save(filePath + “.newout.pdf”, opts);

5

Hi,

Thanks for your posting and using Aspose.Cells for Java.

We have fixed this issue.

Please download and try this fix: Aspose.Cells for Java v7.5.0.3 and let us know your feedback.

6

The issues you have found earlier (filed as CELLSJAVA-40535) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.