Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4   10.5   10.6    Statistic    FMM    Blog  

XL.Book.AddFont

Adds a new font to the workbook, initial parameters can be copied from other font.

Parameters

Parameter	Description	Example	Flags
bookRef	The reference to the workbook. Please use XL.LoadBook to load a file.	$ref
initFont	The index of an existing font which you want to use as a template.	0	Optional

Result

Returns new font index or error.

Description

Examples

Create a font:

Set Variable [$textFont; Value:MBS( "XL.Book.AddFont"; $book)]
Set Variable [$r; Value:MBS( "XL.Font.SetSize"; $book; $textfont; 8)]
Set Variable [$r; Value:MBS( "XL.Font.SetName"; $book; $textfont; "Century Gothic")]

See also

• XL.Font.SetBold
• XL.Font.SetColor
• XL.Font.SetName
• XL.Font.SetSize
• XL.Format.SetAlignH
• XL.Format.SetFont
• XL.LoadBook
• XL.Sheet.CellWriteNumber
• XL.Sheet.CellWriteText
• XL.Sheet.SetCellFormats

Example Databases

• XL/Sheet with colored text
• XL/Writing data

Created 18th August 2014, last changed 5th May 2016

XL.Book.AddCustomNumFormat   -   XL.Book.AddFormat

Feedback: Report problem or ask question.