[Libreoffice-bugs] [Bug 144542] [DOCUMENTATION] Please describe line spacing in detail

Sat Oct 2 07:51:23 UTC 2021

https://bugs.documentfoundation.org/show_bug.cgi?id=144542

--- Comment #5 from Luke Kendall <luke.kendall at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20211002/8a17f114/attachment.htm>