When I set a hyperlink to a cell in Excel and convert it to PDF using the "Convert to PDF" button in the Microsoft Office Toolbar Add-in, I noticed that the Y-coordinate of the link corresponding to the cell shifts a little as the row goes down (see attached file "pdfxce.pdf"). Around the last line, the Y-coordinate of the link is offset from the text content by almost a full line, so it no longer makes sense as a link.
I verified this just after adding a new user in Windows, so all settings in Windows, Excel, and PDF-XChange Editor PRO are default settings. If any special settings are required, I would appreciate it if you could let me know. Incidentally, when converted to PDF using Excel's Export function, the Y-coordinates of all links correspond to the cells (see attached file "microsoft.pdf").
In the PDF-XChange Editor example above, I know that if I select all the links in the PDF-XChanger Editor and scale them down by 98.3% in the Transform Selection dialog, the Y-coordinates of all links will correspond to their respective text. However, I very much doubt that is the solution.
- The PDF on the left was converted using "Convert to PDF" in the MSOffice Toolbar Add-in.
The PDF on the right was converted using Excel's Export function.
- This is a GIF animation. Click to play.
- PDF-XChange Editor PRO Version: 10.4.3 build 391
- OS Version: Windows 11 Home 23H2 Build 22631.4317
- Microsoft 365 Version 2410 (Build 18129.20116 Click-to-Run)
- PC Model: Lenovo IdeaPad C340-15IWL, HP All-in-One 22-c0xx
