XL.Format.SetFont

Sets the font for the format.

Parameters

Parameter	Description	Example
Book	The reference to the workbook. Please use XL.LoadBook to load a file.	$ref
Format	The index of the format in the book to target.	0
Value	The new font index.	$value

Result

Returns OK or error.

Description

Examples

Create left aligned format with specific font:

#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")]
#create format
Set Variable [$textFormat; Value:MBS( "XL.Book.AddFormat"; $book)]
Set Variable [$r; Value:MBS( "XL.Format.SetFont"; $book; $textFormat; $textFont)]
Set Variable [$r; Value:MBS( "XL.Format.SetAlignH"; $book; $textFormat; 1) // left]

See also

• XL.Format.GetFont
• XL.Format.GetIndent
• XL.Format.GetWrap
• XL.Format.SetAlignH
• XL.Format.SetBorder
• XL.Format.SetIndent
• XL.Format.SetWrap
• XL.Sheet.CellWriteNumber
• XL.Sheet.CellWriteText
• XL.Sheet.SetCellFormats

Example Databases

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

Blog Entries

• MBS Plugin Advent calendar: 13 - XL

This function checks for a license.

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

XL.Format.SetFillPattern - XL.Format.SetHidden