Row height in Excel - relationship with data in Metrics

Get help with FontCreator here. Please do not post feature requests or bug reports here.
Post Reply
Fonts
Posts: 84
Joined: Thu Sep 17, 2009 3:35 am

Row height in Excel - relationship with data in Metrics

Post by Fonts »

I'm trying to adjust the settings in Metrics so that the glyph heights are smaller, and this would then effect the row height in Excel.

Basically, if you reduce the following values, then the row height in Excel generally changes, generally being the keyword.
"Typo Ascender - Typo Descender", "Win Ascent - Win Descent" and "Ascender - Line Gap"

But there doesn't seem to be a consistent behavior.
Sometimes row height may jump from 21.75 to 18 for a small change above.
Sometimes, with the same difference, you get a different row height (eg 2150 & -500 may give a different row height compared to 2350 & -300).

Can you please explain it a bit better please.
Attachments
Untitled.png
Untitled.png (19.11 KiB) Viewed 2262 times
Bhikkhu Pesala
Top Typographer
Top Typographer
Posts: 9877
Joined: Tue Oct 29, 2002 5:28 am
Location: Seven Kings, London UK
Contact:

Re: Row height in Excel - relationship with data in Metrics

Post by Bhikkhu Pesala »

Try changing the Contents and Layout version on Font Properties, General, then you can enable Use typo metrics for line spacing.
My FontsReviews: MainTypeFont CreatorHelpFC15 + MT12.0 @ Win 10 64-bit build 19045.2486
Fonts
Posts: 84
Joined: Thu Sep 17, 2009 3:35 am

Re: Row height in Excel - relationship with data in Metrics

Post by Fonts »

Thanks for responding.
There was a difference in the row height, it was reduced ... BUT the font properties were lost though, they don't look the same as created.

And when you go back to the original version, it's not the same as before, ie row height is smaller and font looks different.

What is this for "Contents and Layout version"?
Fonts
Posts: 84
Joined: Thu Sep 17, 2009 3:35 am

Re: Row height in Excel - relationship with data in Metrics

Post by Fonts »

Actually, now on another file, the "Contents and Layout version" doesn't make a difference.
Post Reply