I have a font with the metrics shown below.
If I change the upper and lower bound values as follows:
2400 to 2450 &
-800 to -750
The row height in Excel increases. I have a large number of rows and need to keep the row height as low as possible.
Since the difference between upper and lower is the same, why does this happen?
The baseline will be lower if you change those metrics like that. Try using fixed line height in Excel.
I cannot change the height in Excel as my glyphs use all of the space.
Can you advise the root cause of the issue.
You suggest the baseline is moved … but so is the top metric, the difference is the same.
Can you please explain in more detail.
Hi Bhikkhu, can you please respond.
I don’t have Excel to test. In my tables, using a fixed line height reduces the minimum row height.
OK thanks. But can you please explain the fundamentals so we can understand.
This tutorial provides some more background information and techniques to solve font metrics issues:
Font Metrics – Vertical Line Spacing
It is not aimed at Excel, so you have to experiment to see how fonts behave. Let us know your findings.
OK thanks for sending the link, it is informative, unfortunately not specific enough with respect to Excel.
I guess that’s all you can do.
Cheers.