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.SetAlignV

Sets the vertical alignment.

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 setting.	$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]
Set Variable [$r; Value:MBS( "XL.Format.SetAlignV"; $book; $textFormat; 0) // top ]

See also

• XL.Book.AddFont
• XL.Book.AddFormat
• XL.Font.SetName
• XL.Font.SetSize
• XL.Format.GetAlignH
• XL.Format.GetAlignV
• XL.Format.SetAlignH
• XL.Format.SetFont
• XL.Format.SetIndent
• XL.LoadBook

Example Databases

• XL/Writing data

Created 18th August 2014, last changed 27th November 2017

XL.Format.SetAlignH   -   XL.Format.SetBorder

Feedback: Report problem or ask question.