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.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.Font.SetSize
• XL.Format.GetFont
• XL.Format.GetIndent
• XL.Format.GetWrap
• XL.Format.SetAlignV
• XL.Format.SetBorder
• XL.Format.SetLocked
• XL.Format.SetWrap
• XL.LoadBook
• XL.Sheet.CellWriteFormula

Example Databases

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

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

XL.Format.SetFillPattern   -   XL.Format.SetHidden

Feedback: Report problem or ask question.