You need to change the line-spacing in Excel to fixed or an exact multiple of the point size (not the same as single, 1.5 or double-spacing). I don’t use Excel, but Serif PagePlus has a setting to prevent line-spacing changes when applying superscripts or subscripts.
A more robust alternative is to include true superscripts and subscripts in your fonts ¹²³ etc.
Applications create superscripts and subscripts by scaling the alphanumeric characters, shifting the baseline, and sometimes apply a bold attribute. This is less than ideal for professional typography, as stroke-weights may not be correct and vertical positioning can be incorrect. In FontCreator, you can set the scaling and positioning metrics in Additional Metrics, but not all applications use these correctly, if at all.
Hi
Thanks but there is no line spacing in Excel. And I can’t use true subscripts and superscripts.
I was wondering how it can be done by changing settings in FontCreator. Maybe metrics.
Thanks.
It seems that Excel does not excel at font support, so the only way to use true superscripts/subscripts is to insert them using character map.
FontCreator has additional metrics where one can set the scale and position of superscripts and subscripts, but Excel may not use them. Maybe use a table in Word instead. That does support OpenType features, but I don’t use it, so I cannot test if that works.
You are apparently using an older version of FontCreator. Version 12, or older than that?
Use typo metrics for line-spacing is greyed out because the Contents and Layout is not set to the latest version 5. I am not sure which tab that is on in your version. It should be on the General Tab
The vertical offset of superscipts and subscripts from the baseline is set by Superscript, y offset, and Subscript y offset.
I have no way of testing whether Excel uses these metrics. Try changing them, open the Font Test window, then switch to Excel and select the temporary font used by the font test window.
OK thanks but my issue has to do with Excel though.
I understand that there are a lot of variables the relationship of fonts may vary with application as well, but if you can please look into which settings I need to change to achieve as described in the original post.
I’ve tried a lot of settings but can’t get the same row height for all.
I can get the last 3 to have the same row width by changing settings but not the first.
Normal
Normal + Sub
Normal + Super
Normal + Sub + Super
I do not have Excel, so there is nothing more I have to add. I am surprised that there is no way to fix the row height of a cell, and/or the line-spacing of paragraph text.
Hi, thanks but I’m aware of this.
I need to know more about how the net height is determined from the settings in the font. I now know that it’s not an exact science and that different results will occur in different applications or screen resolution or otherwise.
If you can give me suggestions that would be appreciated.
Hi, yes thanks I have asked but it’s a grey area and I just need some assistance of some sort.
I can’t find anything specific in the documentation to assist. I understand it’s a unique situation.
If you had to design a font with equal “height” for Normal, Subscript, Superscript, where would you start. Which of the settings would you change.
Please have a try at least and offer some more understanding.
A solution would be great but a nudge in the right direction is all I’m expecting. Even if you can refer me to the typography standards as I’m sure when you design your software there are requirements that have to be met, and yes I know they are not 100% foolproof and there may be grey areas but please look into it.
The recommended vertical offset in font design units from the baseline for superscripts for this font.
The problem seems to be that Excel does not use them correctly, if at all. If setting the Row Height in Excel does not work, then ask Microsoft why it does not.