Fonts missing in Libre Office Calc 6.1.2.1 (x64) after update on Windows

[dtp]

I notice that someone else is also having this problem on an Ubuntu system:

Fonts missing in LibreOffice 6.1.2.1 after update on Ubuntu

Hi: I’m a devote user of LO, and just a few days ago installed the new 6.1.2.1 version on my Ubuntu Budgie computer as a snap package. To my surprise, when I created a new Text Document, I found almost all fonts were missing. In fact, these are the only fonts available… [image description] I must say other apps like AbiWord recognize all the fonts in my computer. I’m not an Ubuntu expert, so I wonder if the new LO “forgot” where the fonts are and if I can do something to make it “remember” …

In my case, the problem showed up when I upgraded to LibreOffice Calc 6.1.2.1 (x64) on my desktop, running under Windows 10 Pro (ver. 1803). Calc’s FONT tab (under FORMAT menu) tells me that the fonts I’ve used for years without incident in my spreadsheets have not been installed; e.g.:

"This font has not been installed. The closest available font will be used."

But other programs on my system are not having this problem (e.g., InDesign is seeing the installed font just fine).
Unfortunately, this is a major issue for me.
If I can’t find a fix for it soon, I’ll have to revert to an older version of LibreOffice Calc.

[LibreTraining]

Not likely your issue is the same as the Ubuntu user.
Useful information:

• Which version of LibreOffice did you upgrade from?
• Which specific fonts are missing?
  A guess…
  LibreOffice removed support for PostScript fonts quite awhile ago. Is that the issue?

[dtp]

LibreOffice removed support for PostScript fonts quite awhile ago. Is that the issue?

The missing fonts are Type 1 PostScript, yes.

Do you know if there’s a work-around for this?

Or are my only options now to revert to an older version of LibreOffice Calc and/or stop using PostScript typefaces in my spreadsheets?

[LibreTraining]

Support for Type 1 Postscript fonts was removed in LibreOffice 5.3 when the layout engine was replaced.
Very unlikely it is ever coming back.
So you have a few choices.

If you have a large collection of Type 1 fonts you may want to look into conversion applications like TransType4, FontXChange, etc.
You can also convert them in any font application such as FontLab, FontCreator, and the free/FOSS FontForge.

Or you can move to newer OpenType fonts.
I doubt you are using too many different fonts in spreadsheets so I assume this would not be too painful.

If this answered your question please - check the checkmark at left.

.

[dtp]

Thanks much for this.

Past attempts at converting my PS fonts were not successful, but I expect the technology has improved since then, and this may well be a good solution for others.

For me, the best solution right now is to revert to LibreOffice ver. 5.1.4, which I have now done successfully.

A suggestion: an error message along the lines of “This version of LibreOffice Calc no longer supports Type 1 Postscript fonts.” would be an improvement over what I received.

[LibreTraining]

Yes, LO error messages are often really bad.
The font is installed, so that is wrong, confusing, and misleading.
Filing a bug report is just a futile waste of time.
Have never seen one of these get fixed.

I am curious what fonts are so important to you that you will go back to LO v5.1.x.
Maybe I can convert them for you.

[dtp]

The fonts are ITC Officina Sans and Officina Serif, designed by Erik Spiekermann and Ole Schäfer.

As described at the FontShop < https://www.fontshop.com/ > website:

"When ITC Officina was first released in 1990, as a paired family of serif and sans serif faces in two weights with italics, it was intended as a workhorse typeface for business correspondence. But the typeface proved popular in many more areas than correspondence. Erik Spiekermann, ITC Officina's designer: 'Once ITC Officina got

[dtp]

"picked up by the trendsetters to denote “coolness,” it had lost its innocence. No pretending anymore that it only needed two weights for office correspondence. As a face used in magazines and advertising, it needed proper headline weights and one more weight in between the original Book and Bold.’ To add the new weights and small caps, Spiekermann collaborated with Ole Schaefer, director of typography and type design at MetaDesign. The extended ITC Officina family now includes Medium, Extra

[dtp]

“Bold, and Black weights with matching italics – all in both Sans and Serif – as well as new small caps fonts for the original Book and Bold weights.”

I only have 13 fonts from the family installed on my system:

Officina Sans (Book, BookItalic, Bold, BoldItalic, Black, BlackOS, BlackSC)
Officina Sans SC (Book, Bold)
Officina Serif (Book, BookItalic, Bold, BoldItalic)

These are perfect for spreadsheets because they are tightly-spaced (like a condensed type), and yet still readable at very

[dtp]

small sizes (my LO spreadsheets are designed around Officina Sans text set at 8 points).

As for my reverting to LO v5.1.x.: that’s a whole lot easier than having to redesign my spreadsheets, which barely fit on letter- and tabloid-size paper printouts as it is. And since I’m not a power user of LO Calc, the older program has all the bells-and-whistles I need, so I don’t believe I sacrifice anything important by reverting.

FWIW, LO isn’t the only program I’m refusing to update! (My versions of

[dtp]

InDesign, Dreamweaver, Suitcase Fusion, etc., are so old they’re no longer supported.

[LibreTraining]

Very interesting. I just noticed Officina the other day in a new book.
The Excel 2019 Bible from Wiley uses OfficinaSerif as the main text font (9.5pt).
I have the OTF versions of both Sans and Serif (Book, BookItalic, Bold, BoldItalic).
Have to try them out.
In my quest to rid my system of all things Adobe, I installed/updated to the latest beta of Affinity Publisher today.
Check it out.