Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

Issue with fonts from MS Excel

Community Beginner ,
Nov 21, 2024 Nov 21, 2024

I am having a problem with fonts not appearing as they should, specifically using MS Excel.  I have tried using


File->Print->Adobe PDF
File->Print->Microsoft Print to PDF
File->Save as Adobe PDF

 

Within the preferences of Distiller (or directly in Excel), I have it set to Embed all fonts, Embed Open Type Fonts, and Subset embedded fonts when...

 

The results are always the same (see pic 1) despite the PDF properties indicating that the font has been embedded which is the Excel default Aptos Narrow.Screenshot 2024-11-20 121144.jpegexpand imageScreenshot 2024-11-21 111020.pngexpand image

 

I have dropped the fonts from "C:\Users\{USER}\AppData\Local\Microsoft\FontCache\4\CloudFonts" to the following locations:

C:\Program Files (x86)\Common Files\Adobe\Fonts
C:\Program Files (x86)\Adobe\Acrobat 2020\Resource\Font
C:\Program Files\Adobe\Adobe Creative Cloud\ACC\resources\fonts
C:\Program Files\Common Files\Adobe\Fonts

"C:\Windows\Fonts" (though not all of the fonts are properly showing up in that folder, separate issue)

 

and I also added "C:\Users\{USER}\AppData\Local\Microsoft\FontCache\4\CloudFonts" as a font folder within Acrobat Distiller itself.

 

Why o why does this look like a ransom letter with letters cut from different newspapers and magazines?

TOPICS
Create PDFs , General troubleshooting , PDF
1.2K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
1 ACCEPTED SOLUTION
Community Expert ,
Nov 22, 2024 Nov 22, 2024

Your file is technically fine and the font is properly embedded.

However: Aptos has notoriously bad TrueType hinting. It's horrendous. I found others complaining about this problem online.

To be clear, this has less to do with the actual font size you use, but how many pixels are available on the screen at any magnification you display it, which is why it changes depending on your zoom.

btw: You can also see this in Illustrator or InDesign if you zoom in and out.... it's not an Excel-centric issue.

A TrueType rasterizer is usually used to display fonts on the screen, and it will use the embedded hinting for the different sizes used. This hinting is programmed into the font by the designers, for better or for worse. Why it's being applied to only some characters and not others I'm not sure, although the TrueType specs mention that hinting is used on a case by case basis?  For other fonts, with better-designed hints, this might not be an issue. e.g. If you used Open Sans, you wouldn't be seeing this problem to this extreme, if at all.

Annnnywayy e.g. in this screenshot, I inspected the hinting in both Open Sans and Aptos Narrow at both 16 and 18 point. The REAL font outline is in Black; The hinting is the Blue outline. You can see how wildly different and shorter the letter "e" would be rendered in 18 pt Aptos.... even smaller than the 16 pt version. This is weird font design for sure. This difference is not in Open Sans.

 

As to why it shows in some programs and not others, it depends on what rasterizing tech is being used: e.g. a Win browser might use Cleartype rasterizer instead, which does it's own hinting, or a Mac with a Retina display which doesn't use hinting at all since those monitors are high enough resolution not to need it.

Screen Shot 2024-11-22 at 11.55.44 PM.pngexpand image

 

 

 

View solution in original post

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Nov 21, 2024 Nov 21, 2024

Can you share the Excel and PDF files in question for analysis?

 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Nov 21, 2024 Nov 21, 2024

I can (and did) create a different workbook that I can share that results in the same PDF output.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Nov 22, 2024 Nov 22, 2024

Opening your PDF in Adobe Acrobat I don't see the effect you describe. In your screen shot the 'c' and 'e' characters look a bit compressed, something I cannot see here:

MikelKlink_0-1732280264310.pngexpand image

I may not have the best eyes, though, so you maybe can illustrate a problematic effect in your example file.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Nov 22, 2024 Nov 22, 2024

So yours looks different to mine... Screenshot 2024-11-22 094631.pngexpand image

 

I am at a loss as to what could be causing it.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Nov 22, 2024 Nov 22, 2024

Viewing my upload within this (preview) the text is fine.  Viewing it within the browser extension after downloading is fine. Opening it in the desktop app it's wonky again.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Nov 22, 2024 Nov 22, 2024

Oops, I just opened your file again, and suddenly I have the same effect here, but only at 100% scaling:

MikelKlink_0-1732296927654.pngexpand image

Switching to a different scale, e.g. 150%, I get:

MikelKlink_1-1732297004277.pngexpand image

I guess when looking at your PDF at first, I immediately zoomed in for a detailled view and so missed the effect.

 

Also switching off Smooth Text (Preferences -> Page Display -> Rendering)  I get at 100%:

MikelKlink_2-1732297124690.pngexpand image

This doesn't look good but the height of 'c' and 'e' matches the other letters.

 

Thus, to me this looks like that Acrobat's text smoothing produces these artifacts with that very font with specific font sizes and scaling factors.

 

This might indicate some inadequate hints in the specific font or simply a bug in Acrobat, maybe both.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Nov 22, 2024 Nov 22, 2024

Your file is technically fine and the font is properly embedded.

However: Aptos has notoriously bad TrueType hinting. It's horrendous. I found others complaining about this problem online.

To be clear, this has less to do with the actual font size you use, but how many pixels are available on the screen at any magnification you display it, which is why it changes depending on your zoom.

btw: You can also see this in Illustrator or InDesign if you zoom in and out.... it's not an Excel-centric issue.

A TrueType rasterizer is usually used to display fonts on the screen, and it will use the embedded hinting for the different sizes used. This hinting is programmed into the font by the designers, for better or for worse. Why it's being applied to only some characters and not others I'm not sure, although the TrueType specs mention that hinting is used on a case by case basis?  For other fonts, with better-designed hints, this might not be an issue. e.g. If you used Open Sans, you wouldn't be seeing this problem to this extreme, if at all.

Annnnywayy e.g. in this screenshot, I inspected the hinting in both Open Sans and Aptos Narrow at both 16 and 18 point. The REAL font outline is in Black; The hinting is the Blue outline. You can see how wildly different and shorter the letter "e" would be rendered in 18 pt Aptos.... even smaller than the 16 pt version. This is weird font design for sure. This difference is not in Open Sans.

 

As to why it shows in some programs and not others, it depends on what rasterizing tech is being used: e.g. a Win browser might use Cleartype rasterizer instead, which does it's own hinting, or a Mac with a Retina display which doesn't use hinting at all since those monitors are high enough resolution not to need it.

Screen Shot 2024-11-22 at 11.55.44 PM.pngexpand image

 

 

 

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Beginner ,
Nov 23, 2024 Nov 23, 2024
LATEST

Fascinatingly complex. Thanks to you and MikelKlink for helping me understand that it is just the specific font that has issues and that I'm not going crazy.  Since this appears just to be an on-screen rendinging issue, it is not as big of a deal because any hard-copy prints would not have the same issues so at least there's that.  It does drive me crazy so looks like I'll be changing the default font.  

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines