LibreOffice Tips & Tricks: Replacing Microsoft Fonts - TDF Community Blog
Skip to content
Search for:
Home " LibreOffice Tips & Tricks: Replacing Microsoft Fonts
Fonts are one of the main culprits of LibreOffice interoperability problems with Microsoft Office documents, when viewed from the end user’s point of view. In fact, Microsoft Office document are often using one of the default fonts – either the old "Core Fonts for the Web" (deprecated in 2002, but still in use) or the new "ClearType Fonts" (launched in 2000, and now adopted by Windows and Office) – which are not always available in LibreOffice, as they are proprietary and cannot be distributed with open source software. Also, in the case of ClearType fonts, the license is strictly connected to the Windows and/or Office license, so to legitimately use them with LibreOffice you need a Windows license where they are included.
When LibreOffice opens a Microsoft Office document, it will replace the fonts which are not available with one of the default Liberation fonts, which are metrically compatible with Arial (Liberation Sans), Courier New (Liberation Mono) and Times New Roman (Liberation Serif), but will have an impact on the visual appearance of the document if they replace a different font (in this case, the user will usually start to complain loudly about LibreOffice, without even checking if the contents are still there…).
To reduce the impact of this problem, which cannot be eliminated, at least until users stop using fonts creatively, LibreOffice offers a specific feature, a font replacement table that can be configured according to the user’s needs, and is among the program’s options. If the table is configured correctly, LibreOffice replaces the fonts with those metrically compatible – or simply more similar – defined by the user, and this in most cases will prevent the document from looking different. Luckily, there is a large number of free open source fonts available, with some specifically developed to replace Microsoft fonts as in the case of Croscore Fonts, from several online repositories. I suggest Google Fonts, as the website provides not only the font files but also all the associated legal resources, including the license.
My LibreOffice font replacement table, which has been developed over the years, includes the following font pairs (the first is replaced by the second, which is installed on my Linux PCs): Arial -> Arimo, Calibri-> Carlito, Cambria -> Caladea, Consolas -> Inconsolata, Courier New -> Cousine, Franklin Gothic -> Libre Franklin, Georgia -> Neuton, Gill Sans -> Cabin, Impact -> Oswald, Palatino -> Crimson Text, Perpetua -> Lustria, Times New Roman -> Tinos, Twentieth Century -> Spartan, and Verdana -> PT Sans. This is how it looks in LibreOffice:
Installing fonts is rather easy, but for those who are not familiar with the procedure there are a couple of articles which provide a quick tutorial: Windows & macOS, and Linux.
Related Posts
Update about Font Replacement
2025-11-12
Create a colour wheel in LibreOffice
2025-06-12
Quick tip: creating "hybrid" PDF files in LibreOffice
2024-04-16
12 thoughts on “LibreOffice Tips & Tricks: Replacing Microsoft Fonts”
It would be fine if the user is informed that some of the fonts in its documents are missing. Not Only for MS documents, but for all document. The way it done now is only an italic name of the font in the UI. Maybe just having a red name of the font would warn the user that the current font is not available on his computer OS
Better, he could be told if the font is free and available on the web
Better again, if not free, the substitution font could be proposed
Analog Times New Roman
Info
https://astralinux.ru/information/#section-fonts-astra
https://www.paratype.ru/fonts/pt/pt-astra-serif
Direct link
https://astralinux.ru/information/fonts-astra/font-ptastrasans-ttf-ver1001.zip
https://astralinux.ru/information/fonts-astra/font-ptastra-serif-ver1002.zip
Open Font License (OFL)
https://astralinux.ru/ofl
Hi Italo,
This is a fantastic idea, thank you for highlighting this point. However let me just ask why isn’t this the default for non Microsoft Windows users (I assume that Windows Users have all the fonts through the OS) of LibreOffice?
You have these mappings, I think as a pragmatic approach these (or similar mappings) be the defaults upon new installation. LO ships empty with no substitutions by default, you would cut down quite a lot of the complaints users have with incompatibilities by supporting their productivity by doing the mappings on their behalf. I would hazard a guess that a sizable number of users have no idea of this functionality.
If the end user is then not happy with the default choices they are free to change. The point is that you are supporting the end user through sane and reasoned defaults.
If you can’t install these fonts by default and set the mappings then can they packaged up as easy extensions?...