Character fit within merged cells in Excel

Post general font related questions (e.g. how to install, convert and use fonts) and requests (looking for fonts, designers etc.) here.
Post Reply
Fonts
Posts: 47
Joined: Thu Sep 17, 2009 3:35 am

Character fit within merged cells in Excel

Post by Fonts » Mon Mar 12, 2018 6:11 am

I am working on this font and have noticed that some of the end characters do not within the merged cells in Excel.
In the case I have attached, part of some characters are truncated on the right boundary (the green line is the border of merged cells in Excel).
Sometimes I have issue where the characters over-run the border rather than continuing in the next line. I have also noticed this latter problem with some fonts I have installed from font manufacturers.

Note: The caption is from a printed PDF, not a screenshot in Excel.

How can i fix it?
Attachments
Untitled.png
Untitled.png (19.51 KiB) Viewed 1074 times

Bhikkhu Pesala
Top Typographer
Top Typographer
Posts: 7448
Joined: Tue Oct 29, 2002 5:28 am
Location: Seven Kings, London UK
Contact:

Re: Character fit within merged cells in Excel

Post by Bhikkhu Pesala » Mon Mar 12, 2018 6:16 am

This looks like a problem in Excel rather than in the fonts. Try setting the cell padding or margins to a few more pixels. I don't use Excel, so I cannot tell you how to do that.
My FontsReviews: MainTypeFont CreatorHelpFC11.5 Pro + MT8.0 @ Win10 1803

Fonts
Posts: 47
Joined: Thu Sep 17, 2009 3:35 am

Re: Character fit within merged cells in Excel

Post by Fonts » Mon Mar 12, 2018 6:45 am

No I don't believe it is an issue in Excel.
It is the font as I have tested hundreds of different types of fonts and the issue seems to be with the less established fonts, rather than with, say, fonts shipped with Microsoft products.

Erwin Denissen
Moderator
Moderator
Posts: 7347
Joined: Fri Oct 04, 2002 12:41 am
Location: De Bilt, The Netherlands
Contact:

Re: Character fit within merged cells in Excel

Post by Erwin Denissen » Mon Mar 12, 2018 10:52 am

I'm not able to reproduce the issue with Excel 1802 (from Office 365).
Erwin Denissen
High-Logic
Proven Font Technology

Fonts
Posts: 47
Joined: Thu Sep 17, 2009 3:35 am

Re: Character fit within merged cells in Excel

Post by Fonts » Mon Mar 12, 2018 1:55 pm

What font are you using?
If it's your own font, is it based on a template from and established font?

Erwin Denissen
Moderator
Moderator
Posts: 7347
Joined: Fri Oct 04, 2002 12:41 am
Location: De Bilt, The Netherlands
Contact:

Re: Character fit within merged cells in Excel

Post by Erwin Denissen » Mon Mar 12, 2018 1:59 pm

I went through all my installed fonts.

If you also use the same Excel version, then send me a sample Excel document along with the font.
Erwin Denissen
High-Logic
Proven Font Technology

Fonts
Posts: 47
Joined: Thu Sep 17, 2009 3:35 am

Re: Character fit within merged cells in Excel

Post by Fonts » Mon Mar 12, 2018 2:08 pm

Erwin
I presume all your installed fonts are those provided by Microsoft.
In which case this is what I'm trying to say in the original post, the issue is not there not there with the established fonts.
With my own font, started from a blank template, I am having issues. And I also note the same issue with some downloaded fonts from sites such as dafont and others. Possibly because of designer inexperience, the characters are either truncated or they over-run the border.

Fonts
Posts: 47
Joined: Thu Sep 17, 2009 3:35 am

Re: Character fit within merged cells in Excel

Post by Fonts » Tue Mar 13, 2018 1:34 am

To illustrate the issue.
Compare Courier New with PT Mono. Courier New is an established Microsoft font. PT Mono has the same issue as my font.

Attached:
- Excel workbook.
- PDF printouts.
- PT Mono font file.
Attachments
PTM55FT.ttf
(181.55 KiB) Downloaded 29 times
PDF - PT Mono.pdf
(20.93 KiB) Downloaded 12 times
PDF - Courier New.pdf
(17.6 KiB) Downloaded 8 times
Excel.xlsx
(14.67 KiB) Downloaded 9 times

Erwin Denissen
Moderator
Moderator
Posts: 7347
Joined: Fri Oct 04, 2002 12:41 am
Location: De Bilt, The Netherlands
Contact:

Re: Character fit within merged cells in Excel

Post by Erwin Denissen » Tue Mar 13, 2018 7:38 am

Again, no issues here.
ptmono.png
ptmono.png (97.95 KiB) Viewed 1030 times
Erwin Denissen
High-Logic
Proven Font Technology

Fonts
Posts: 47
Joined: Thu Sep 17, 2009 3:35 am

Re: Character fit within merged cells in Excel

Post by Fonts » Tue Mar 13, 2018 8:32 am

Erwin
As stated in the original post, the issue is in the printed PDF. You know that Excel will give variable graphic output.
Look, I know that it is a difficult and unique issue, and you may not be able to solve it. If you can't solve upon considering above, please refer me to any literature or another forum that would deal with this.
Please don't take it as criticism, I really have to solve this.

Erwin Denissen
Moderator
Moderator
Posts: 7347
Joined: Fri Oct 04, 2002 12:41 am
Location: De Bilt, The Netherlands
Contact:

Re: Character fit within merged cells in Excel

Post by Erwin Denissen » Tue Mar 13, 2018 8:44 am

To me it was not obvious it was a PDF issue.

If the fonts do look fine in Excel, then I suspect your PDF generator/driver is the cause of the problem.
Erwin Denissen
High-Logic
Proven Font Technology

Fonts
Posts: 47
Joined: Thu Sep 17, 2009 3:35 am

Re: Character fit within merged cells in Excel

Post by Fonts » Tue Mar 13, 2018 8:56 am

Well done!
I think you may be right.
Thanks.

Bhikkhu Pesala
Top Typographer
Top Typographer
Posts: 7448
Joined: Tue Oct 29, 2002 5:28 am
Location: Seven Kings, London UK
Contact:

Re: Character fit within merged cells in Excel

Post by Bhikkhu Pesala » Tue Mar 13, 2018 11:02 am

Topic moved since it is not related to the use of FontCreator.

I find that CutePDF is one of the best free PDF printers. Which were you using?
My FontsReviews: MainTypeFont CreatorHelpFC11.5 Pro + MT8.0 @ Win10 1803

Fonts
Posts: 47
Joined: Thu Sep 17, 2009 3:35 am

Re: Character fit within merged cells in Excel

Post by Fonts » Tue Mar 13, 2018 1:56 pm

I was using PDFill.
I did try CutePDF but there was no improvement.
I printed to xps and this was better but I haven't found any suitable PDF printer.

Post Reply