From Brave Search:
LibreOffice font styles (bold, semibold, condensed, etc)
🌐
superuser.com
› questions › 1627384 › libreoffice-font-styles-bold-semibold-condensed-etc
This is a known problem: LibO gets confused when a font offers many weights or shapes. Try to remove the ones you don’t need and see if the needed one show up.
BTW, WHY do you want to use a variable spaced typeface in a spreadsheet? If you are lining up numbers, MONOspaced typefaces are MUCH better. Microsoft is notoriously skimpy on monospaced typefaces included, and they do NOT have to all look like Courier.
I use Letter Goth 12, but there is also Bitstream Vera Sans Mono, and Microsoft Aptos Mono, and many others.
To answer your question, much of the information is text, and I'm trying to cram a lot of it in. The "Description" column in particular eats up a lot of column width, and I'm trying to keep the rows one line tall. Some items have subtle differences, and two word descriptions don't cut it.
OTOH, you are correct about the lining up of numbers, such as monetary values. Monospacing applies to my location coding as well, as it follows a set format of 7 characters. I ended up using both std. zeros and dotted zeros there in different positions in the code, so I was using Source Code Pro for the location codes, but have switched to DejaVu Sans Mono. (It's not a compact / narrow font, but, the column is only 7 characters wide, anyway.
Only 2 columns are numerical ($$) fields, so, at least for now those are getting Arial Narrow (Bold).
There is also a column titled "Mod?". That refers to alterations, usually by yours truly. I threw in the towel there: The fields get either a "N" for "None", or a "Y####" as an alphanumeric code ("Yes" and numbers) to look up elsewhere, or maybe later on in an extension of the spreadsheet. (Basically another spreadsheet at the end of the spreadsheet, but, I may decide that's too cumbersome.)
I'll look up those fonts you mentioned, as I don't "know" them, except Courier, of course. I might like one of them! I'd look at any other "narrow" monospaced font with excellent legibility, too. (My eyes aren't quite what they once were, even with my new glasses.)
Thanks again!