Ask Your Question
0

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

asked 2018-11-13 21:05:14 +0200

dtp gravatar image

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

https://ask.libreoffice.org/en/questi...

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.

edit retag flag offensive close merge delete

Comments

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?

LibreTraining gravatar imageLibreTraining ( 2018-11-13 23:15:20 +0200 )edit

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?

dtp gravatar imagedtp ( 2018-11-14 00:11:16 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2018-11-14 01:31:49 +0200

LibreTraining gravatar image

updated 2018-11-14 02:19:45 +0200

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.

.

edit flag offensive delete link more

Comments

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.

dtp gravatar imagedtp ( 2018-11-14 07:27:46 +0200 )edit

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.

LibreTraining gravatar imageLibreTraining ( 2018-11-15 01:44:49 +0200 )edit

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 gravatar imagedtp ( 2018-11-16 20:32:52 +0200 )edit

"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 gravatar imagedtp ( 2018-11-16 20:33:58 +0200 )edit

"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 gravatar imagedtp ( 2018-11-16 20:35:12 +0200 )edit

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 gravatar imagedtp ( 2018-11-16 20:35:53 +0200 )edit

InDesign, Dreamweaver, Suitcase Fusion, etc., are so old they're no longer supported. ;-)

dtp gravatar imagedtp ( 2018-11-16 20:36:56 +0200 )edit

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.

LibreTraining gravatar imageLibreTraining ( 2018-11-17 23:56:00 +0200 )edit
Login/Signup to Answer

Question Tools

2 followers

Stats

Asked: 2018-11-13 21:05:14 +0200

Seen: 174 times

Last updated: Nov 14 '18