CREPORTFONT¶

The CREPORTFONT formula allows you to specify font substitution for your Published Reports.

Syntax

CREPORTFONT (ExistingFontName, ReplacementFontName, URL)

Arguments¶

ExistingFontName : `string` (required)¶

The name of the font to be replaced (check the default font being used by Excel, by selecting a cell and checking the font name via the Home ribbon tab).

ReplacementFontName : `string` (required)¶

The name of the font to be used as a replacement.

URL : `string`¶

The URL to the font file that you want to use.

If no URL is specified, then Google Fonts are used.

Usage Scenarios¶

There are two main scenarios where CREPORTFONT can be used:

To replace system fonts with specific web fonts using, for example Google Fonts.
To ensure a specific corporate font shows correctly on the web.

Examples¶

=CREPORTFONT("Calibri","Lobster")
=CREPORTFONT("Calibri","Segoe UI")