How to Specify TrueType Fonts Location

This article describes:

1. Where the Aspose.Cells API looks for TrueType fonts.
2. How to explicitly specify TrueType font folders for Aspose.Cells API.
3. How to restrict the Aspose.Cells API to use only one TrueType font location.

Working with Fonts

Where Aspose.Cells Looks for TrueType Fonts on Windows

Aspose.Cells searches for fonts in the Windows\Fonts folder. This default setting works most of the time, so only specify your own fonts folder if you really need to.

Where Aspose.Cells Looks for TrueType Fonts on Linux

By default, Aspose.Cells API looks for the fonts in all of the following locations, although different Linux distributions store fonts in different folders.

1. /usr/share/fonts
2. /usr/local/share/fonts

This default behavior will work for most Linux distributions, but is not guaranteed to work for all of the time. You might need to specify the location of the TrueType fonts explicitly.

How to Explicitly Specify a Font Folder

Aspose.Cells APIs have exposed many factory methods for the FontConfigs class to specify the fonts or fonts folders as described below.

1. The setFontFolder method accepts the first parameter of type String that specifies the location of the fonts directory, whereas the second parameter of type Boolean directs the Aspose.Cells APIs to search the folders recursively for font files.
2. The setFontFolders method accepts an array of type String, so you may specify many font directories using this approach. You may also direct the Aspose.Cells APIs to search the folders recursively by specifying true as the second parameter.
3. The setFontSources method accepts an array of type FontSourceBase for you to specify a list of individual fonts' locations.

When specifying the fonts folder using any of the above‑mentioned methods, we recommend setting the font location at the start of the application, otherwise you may receive poorly formatted results.

Setting the fonts folder using any of the above methods does not ensure that the Aspose.Cells API will not look for the fonts in default locations such as the system’s font folder.

How to Restrict the Aspose.Cells to Use Only One Font Folder

Starting from Aspose.Cells for Java 8.1.0, setting the JVM argument as -DAspose.Cells.FontDirExc=“YourFontDir” will ensure that the Aspose.Cells API will only use the fonts location as specified.

Set the specified argument using the System.setProperty method as shown below.

System.setProperty("Aspose.Cells.FontDirExc", "FontDirSet");

Please note the following:

• The above statement should be at the start of your application.
• Using the above approach does not require setting the font directory using any of the FontConfigs methods discussed above.
• The string "FontDirSet" should be the complete path to the folder containing the required fonts.