CREPORTFONT

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

Syntax

CREPORTFONT (ExistingFontName, ReplacementFontName, URL)

Arguments

ExistingFontName

(Required)   The name of the font that you going to replace (check the default font being used by Excel, by selecting a cell and checking the font name via the Home ribbon tab)

ReplacementFontName

(Required)

The name of the font your are using as a replacement

URL

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

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

Usage Scenarios

There are two main scenarios where CREPORTFONT can be used

  1. to replace system fonts with specific web fonts using, for example Google Fonts and
  2. where you have a specific corporate font you can reference it so that it shows correctly on the web

Examples

=CREPORTFONT("Calibri","Lobster")