Unable to embed custom font (PUA/EUDC) in PDF on Azure AppService (Windows)

[d4isaka]

I am trying to generate a PDF from an Excel (.xlsx) file via command line on Azure AppService (Windows) environment.
The Excel file uses custom characters defined in the Private Use Area (PUA) with a specific custom font explicitly set within Excel.

Since OS-level font installation is not permitted on AppService, I followed the instructions at the following URL and placed the custom TrueType font under share\fonts\truetype within LibreOffice Portable:

Use local fonts for soffice.exe --headless on Windows

Hi, my Windows VM has no fonts installed and I can’t access C:\Windows\Fonts. Can I get soffice.exe to use fonts in a custom folder? My command is: soffice.exe --headless --convert-to pdf --outdir "D:\home\site\wwwroot" "D:\home\site\wwwroot\mydoc.docx" This command is OK on my local machine but on the server it fails with: No fonts could be found on the system. I’m trying to convert docs to PDF on an Azure App Service, it’s a Windows VM with no fonts installed. Thanks!

The version of soffice.com is as follows:

.\soffice.com --version
LibreOffice 7.6.7.2

When I test this approach on a local Windows 10 machine, the font is correctly embedded in the PDF output and the custom characters display properly.

However, when performing the PDF conversion in the same manner on AppService, a different font (ming-lt-hkscs-uni-h) is embedded instead of the specified custom font, resulting in different characters being displayed in the PDF.

An example of the command actually run on AppService is as follows:

C:\home\LibreOfficePortable\App\libreoffice\program\soffice.com ^
  --headless --language=ja --convert-to pdf ^
  --outdir "C:\home\test" "C:\home\test\sample.xlsx"

Questions:

1. Is there a reliable way to ensure that fonts placed under share/fonts/truetype are embedded when converting with soffice.com via the command line?
2. How can I prevent unintended fallback fonts (such as ming-lt-hkscs-uni-h) from being embedded instead?

If anyone has experience or advice on this issue, I would greatly appreciate your help.
Thank you very much in advance.

[mikekaganski]

@d4isaka

with a specific custom font explicitly set within Excel

I would first check, if this setting is correct: when you open the Excel file locally in Calc, is the font name set in the respective cells displayed normally in the Font Name box; or is it italicized there - which would indicate “font is absent on this system, and a substitute is used”?

The idea is, that if that is the case (which could be e.g. when the font name is similar, but not identical), it could be possible, that by chance, the font that you provided in share/fonts/truetype gets used as substitute; but on another system, another font could be picked.