https://bugs.documentfoundation.org/show_bug.cgi?id=144542
--- Comment #5 from Luke Kendall <luke.kend...@gmail.com> --- It was a real battle to get Calc to let me run the macro. Initially, the file opened with a warning that untrusted macros wouldn't be run. I then navigated via Tools->Macros->Run Macro to navigate to the AllFontMetrics macro and select Run. Nothing at all happened - no warning that it couldn't run, but no indication that it was running, either. [1] Next I tried clicking on the button, with the same result. Then I opened Tools->Macros->Edit Macro and navigated again to the LoadFontInfo macro and selected Run. This time it immediately failed with a message on an error panel [containing text that can't be copied and pasted, which is annoying][2]: For security reasons, you cannot run this macro. For more information, check the security settings. I did that, and changed my security settings for macros from high to Low, and hit OK. I tried again, and got the same security error. I closed the file and reopened it, and checked that the macros security option was still set to Low, and tried again, and got the same security denial. In desperation, I exited from LibreOffice entirely and restarted. At that point it worked. So neither (1) the message about the security setting, nor (2) changing the security settings and applying/okaying the change prompted the user that the changes would not take effect until exiting and restarting LibreOffice entirely. [3] I don't have time to report items [1], [2], and [3] as bugs. Anyway, checking into my specific case to try to give Rafael some useful information, it's not at obvious how to use the information I see. Since I know a bit about font design and typesetting, I'll see if I can puzzled it out here... I typically set my 5"x8" format books using 10.5pt Georgia. It seems possible that it uses a line height of 12pt (so I suppose you could say a leading of 1.5pt), if my guess is right. Now, the info provided doesn't include the typeface 'style', so I simply get the name Georgia repeated four times (no indication of Regular, Italic, Bold, Bold Italic), although in this case it doesn't matter because all the metrics are the same for each of the four. To be concrete, I get: Name Height Ascent Descent Leading Slant ... Georgia 17 16 4 3 0 Georgia 17 16 4 3 0 Georgia 17 16 4 3 0 Georgia 17 16 4 3 0 Hmm: assuming the calculation would be: Inter Line Gap factor = Leading / (Height + Descent) Inter Line Gap factor = Inter Line Gap factor * Font size yields 3 / (17+4) = 1/7 for the Inter Line Gap factor and 10.5pt/7 -> 1.5000pt Which does indeed give me the answer I would expect in this example at least, so I think you may have solved the problem Rafael - thank you! So, Writer could look up those metrics for the font style and height selected for a paragraph style, and report that information as a read-only figure on the Indents & Spacing tab for the Paragraph Style panel. I assume the Line Height number reported would have to be modified by a multiplying factor if one was included in the paragraph style (like 1.15, 1.5, Double spacing) was selected, or by an addition if some additive factor was chosen as the Line Spacing in the Indents & Spacing tab; or copied from the user selected figure if Fixed was selected, or just use the Leading factor if the user selected that? Doing a quick comparison with Times New Roman, which my 'rule of thumb' learnings have said is usually set as if Line Height is 1pt larger than the font size (so, 10/11, 11/12, 12/13) is roughly right: The metrics give 2/21 as the inter line gap factor, so would give 10/10.95, 11/12.05, 12/13.14. (I remember that this changes to Size/Size+2 at some point around 15pt - and so on as the font size increases further - but can't remember exactly where.) I don't know whether Writer rounds the line heights to integer values or works with fractional line heights as it lays out lines of text on the page. That's an important fact important to know, too, but is easily handled by reporting the figure with two or four decimal digits of precision if it uses fractions, otherwise as whole number if it rounds. Note: I understand that when the writer uses superscripts, inserts larger text, or images etc. in a line, it must increase the leading for such lines - but the user should also understand the such text layout changes may alter the number of lines that will fit on such a page. Therefore I think that issue isn't something Writer could be reasonably expected to do much about. I.e. the normal-case Line Height figure is enough. --- Just a final note on the font naming thing: it would be important for the Regular/Italic/Bold/... font style used in the paragraph style to be looked up as the basis for the calculations, if the feature is added to Writer. If it's not added, it would be good if the font style could be appended (in some way) to the font name in the spreadsheet. Here's a few names from the typefaces around Georgia in my list: Gesture Slant BRK Gesture BRK Georgia Georgia Georgia Georgia Gentium Book Basic Gentium Book Basic Gentium Book Basic Gentium Book Basic Gather BRK Gardiner Noto Sans Telugu UI ExtraCondensed Thin Gaposis Solid BRK Gaposis Outline BRK Gamaliel Galvanize BRK Galapogos BRK Noto Serif Tamil ExtCond ExtBd GFS Porson GFS Baskerville Furat Fully Completely BRK Quacksalver BRK Comic Neue Angular Light Comic Neue Angular Light Noto Serif Kannada SemiBold Comic Neue Angular Comic Neue Angular Comic Neue Angular Comic Neue Angular Comic Neue Light Comic Neue Light Combustion Wide BRK Combustion Tall BRK Combustion Plain BRK Combustion II BRK Combustion I BRK Noto Sans Thai SemCond Blk and a few around Times New Roman: Noto Serif Kannada ExtraBold Noto Serif Kannada Noto Serif Kannada Noto Serif Hebrew Thin Noto Serif Hebrew SemCond Light Noto Serif Hebrew SemCond ExtLt Noto Serif Hebrew SemCond Blk Noto Serif Hebrew SemBd Noto Serif Hebrew Light Noto Serif Hebrew ExtLt Noto Serif Hebrew ExtCond Thin Times New Roman Times New Roman Times New Roman Times New Roman Noto Serif Hebrew ExtCond SemBd Noto Serif Hebrew ExtCond Light Noto Serif Hebrew ExtCond ExtLt Noto Serif Hebrew ExtCond ExtBd Noto Serif Tamil ExtCond Light Noto Serif Hebrew ExtCond Blk Noto Serif Hebrew ExtCond Noto Serif Hebrew ExtCond Noto Serif Hebrew ExtBd Noto Serif Hebrew Cond Med Noto Serif Hebrew Cond ExtLt Noto Serif Hebrew Cond Blk Noto Serif Hebrew Noto Serif Hebrew Noto Serif Hebrew Blk Thanks again, Rafael. I'll be interested to hear if my single example calculations (Georgia, 10.5 pt) are correct. Nor do I know what -- You are receiving this mail because: You are the assignee for the bug.