

but a friend told me that to get one I either need a VPS with a public ip (which just takes all the fun out of selfhosting) or purchase a static ip
Neither of those are requirements. Just buy a domain at a registrar that allows you to dynamically update an IP address with a domain you have there. Look into DDNS update scripts and/or your own internet router, many routers have that feature built-in already.





I was reading into this recently too. My understanding is that Debian + LibreOffice install the Liberation Fonts by default so usually you don’t need to worry about documents using Ariel and Helvetica (Liberation are metrically compatible replacements).
After further reading I ended up also installing the Crosextra fonts, the advantage of those two is that they are metrically compatible with Microsoft’s Calibri and Cambria. Once installed in theory LibreOffice should be able to open documents that had those Microsoft fonts and auto replace them with the open versions. (there’s a setting in LibreOffice to force font replacements but it didn’t seem like I needed to do that in my case)
Some more info on that
https://en.wikipedia.org/wiki/Croscore_fonts#Crosextra_fonts
The Crosextra font packages in Debian
https://packages.debian.org/trixie/fonts-crosextra-carlito
https://packages.debian.org/trixie/fonts-crosextra-caladea
Also interestingly - if you do really, really want some of Microsoft’s fonts they are free to install but I don’t think you actually get a license to distribute/publish with them. I didn’t bother installing these but could be useful for someone with tons of old MS Office documents with lots of random MS fonts.
https://packages.debian.org/trixie/ttf-mscorefonts-installer (need to enable contrib in your apt settings to be able to apt install those)