PDF still not accurate - non aligned text & random letters

[John M-S]

Dear Team,

I have just downloaded the latest software 1.71 as the PDF format was not rendering properly. I raised a ticket this about two weeks ago when the new release came out and a ticket was raised. So when the latest version was released, I downloaded it and the problem is still there. 

So if you load a PDF into Affinity Photo, to crop and export as a JPG, it changes some text alignment and leaves ' PDF' initials in a random place on the document. So nothing has changed. I have uploaded a PDF and if you load it into the software at 96 DPI ( or even 72 dpi) when it opens on the interface, the top line is misaligned and there are random PDF letters on the left hand columns. 

Is there any update on this please?

Thank you 

 

John

Juice Range 23-06-2019.pdf

[Alfred]

I don’t know the answer to your question, John, but I strongly suspect that the heading for the first section should say ‘Dessert’, not ‘Desert’! And I think the marked columns should have ticks (check marks) instead of square root symbols.

[Old Bruce]

21 minutes ago, John M-S said:

So if you load a PDF into Affinity Photo, to crop and export as a JPG,

Why not export as a JPEG first then load into Photo to crop or crop in what ever PDF viewer you have and export to JPEG?

[John M-S]

Hi Guys,

 

Thanks Alfred you are quite right, but it didn't answer the issue. Old Bruce, I created an EXCEL spreadsheet and then converted it to PDF, which Excel does. I then loaded it into Affinity Photo to convert to a JPEG and to adjust it to the correct size for the website.  It is when it is loaded into A- Photo that the PDF is changed and the top line spacing is put out and random letters appear. Now this never used to happen in the older versions. A moderator said to weeks ago he would raise the issue on a ticket and the latest version is doing the same thing as the last version. Thanks anyway, but the latest version of Photo is doing something that it shouldn't and never used to.

[Old Bruce]

I noticed that the line with the misaligned text has the PDF letters continued down from the end of that row. Different Font sizes too but I think you need that to fit that sentence in the cell in excel.

[John M-S]

Hi Bruce,

Those PDF letters just appear when you load the PDF into A-Photo, that are not in the original. The font sizes are the same size as those in the lower down in the sheet which are not misaligned, but the top row misaligns and random 'pdf' letters appear once loaded into A-Photo. Now you could say it was something in Excel, apart from the fact these random letters which suddenly appear and  that the misalignment does not show up lower down the sheet.

Now, this never happened in the older versions and is not an issue, until the PDF is loaded into A-Photo. So there attached is an xl version and a PDF version of the same....  

John

Juice Range 23-06-2019.pdf

Juice Range 23-06-2019.xlsx

[Old Bruce]

[John M-S]

HI Bruce,

In Excel, they are both the same font size (they are just capitals) and that font size continues down the sheet. When in Excel, you convert it to a PDF, the PDF reflects the Excel speadsheet and looks the same. Once you load/open that PDF in A-Photo it changes and moves the top lines around and moves those PDF letters across and down as the spacing is changed once loaded into A-Photo.  I have attached how it looks once opened in Photo. What I am saying is that A-Photo is changing the spacing as the document is loaded and even before it is exported as a JPEG. Am I making sense? Am I going mad?  Thanks John

[Old Bruce]

30 minutes ago, John M-S said:

What I am saying is that A-Photo is changing the spacing as the document is loaded and even before it is exported as a JPEG. Am I making sense? Am I going mad?

Yes Photo is changing the spacing. This is because Excel has one set of rules for spacing that font in those Excel cells and Photo has a completely different set of rules for spacing that font plus Photo has no awareness of the cells in the PDF, in fact the PDF has no knowledge there are cells there it just sees a line of text from the left to the right with another row of text below it.

You are making sense and you are not going mad.

Photo is not the best choice for manipulating text but try copying all the cells from  the Excel program and pasting them into a new (appropriately sized) Photo document. It sort of worked here, I don't have all the fonts so the websites were truncated.

[GaryLearnTech]

@John M-S I think your problem is with the formatting of your spreadsheet.  Here's a small part of it opened into the Office 365 version of Excel on my iMac.

You can see that columns B:F are a shade too narrow.  Expanding their width from 6.00 to 7.00 (41 to 47 pixels) provides sufficient space, so that there's no clipping of the titles.

Similarly, the width of column G is too narrow and several of your URLs overflow the available width.  (Additionally, you have a mix of 10pt and 11pt Verdana for the URLs…)

In the attached tweaked version of your spreadsheet, I have "fixed" the column widths and I have tweaked two other aspects: 

1. Your vertical alignment is set to the default of Bottom Align - I have changed this to Middle Align.  Probably not significant with respect to this problem, just my personal taste.
2. You have not applied any alignment to the cells in columns B:F.  By default, Excel left-aligns data if it thinks it's of type text.  If you type in a simple numeral, it automatically right-aligns it.  I have set the cells in these columns to centred.

And it seems to be step #2 that's key to fixing this (in conjunction with the widths).

NB When importing into Affinity Photo, I have to deselect the "Favour editable text over fidelity" checkbox - and it works nicely on my iMac.  The attached Affinity Photo file is the result of the simple import and seems to match your expectations (if I have correctly understood them).

Juice Range 23-06-2019 GLT.afphoto

Juice Range 23-06-2019 GLT.pdf

Juice Range 23-06-2019 GLT.xlsx

[John M-S]

Dear Bruce and Gary, thank you both for your input.

Gary, I quite understand your points. When I open my excel spreadsheet, the columns look correctly spaced and always have. ( I have a 2011 vision of MS Office running on my I Mac)  Double clicking the line will 'auto width'  the column. When I converted the Excel to a PDF they looked correct, it only happened when I imported the document to A-Photo and I think this is where Bruce makes his point, concerning spacing.

But I have opened your adjusted versions Gary and have to say they look just right!!  Just as they used to, many thanks. I am going to have a little play later today.  But I  wanted to thank you for your time, both Bruce and Gary, it is much appreciated.

Regards 

 

John