Monkeybread Software - MBS FileMaker Plugin: XL.Format.SetAlignV

Components	All	New	MacOS		Windows		Linux		iOS
Examples	Mac & Win		Server	Client	Guides	Statistic	FMM	Blog	Deprecated	Old

XL.Format.SetAlignV

Sets the vertical alignment.

Component	Version	macOS	Windows	Linux	Server	iOS SDK
XL	3.5	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes

MBS( "XL.Format.SetAlignV"; Book; Format; Value ) More

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

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

Sets the vertical alignment.
Possible values:

0	Top
1	Center
2	Bottom
3	Justify
4	Distributed

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 ]

<?xml version="1.0" encoding="UTF-8"?>
<fmxmlsnippet type="FMObjectList">
<Step enable="True" id="89" name="# (comment)"><Text>create a font</Text></Step>
<Step enable="True" id="141" name="Set Variable">
    <Value>
      <Calculation>MBS( "XL.Book.AddFont"; $book)</Calculation>
    </Value>
    <Repetition>
      <Calculation>1</Calculation>
    </Repetition>
    <Name>$textFont</Name>
  </Step>
  <Step enable="True" id="141" name="Set Variable">
    <Value>
      <Calculation>MBS( "XL.Font.SetSize"; $book; $textfont; 8)</Calculation>
    </Value>
    <Repetition>
      <Calculation>1</Calculation>
    </Repetition>
    <Name>$r</Name>
  </Step>
  <Step enable="True" id="141" name="Set Variable">
    <Value>
      <Calculation>MBS( "XL.Font.SetName"; $book; $textfont; "Century Gothic")</Calculation>
    </Value>
    <Repetition>
      <Calculation>1</Calculation>
    </Repetition>
    <Name>$r</Name>
  </Step>
<Step enable="True" id="89" name="# (comment)"><Text>create format</Text></Step>
<Step enable="True" id="141" name="Set Variable">
    <Value>
      <Calculation>MBS( "XL.Book.AddFormat"; $book)</Calculation>
    </Value>
    <Repetition>
      <Calculation>1</Calculation>
    </Repetition>
    <Name>$textFormat</Name>
  </Step>
  <Step enable="True" id="141" name="Set Variable">
    <Value>
      <Calculation>MBS( "XL.Format.SetFont"; $book; $textFormat; $textFont)</Calculation>
    </Value>
    <Repetition>
      <Calculation>1</Calculation>
    </Repetition>
    <Name>$r</Name>
  </Step>
  <Step enable="True" id="141" name="Set Variable">
    <Value>
      <Calculation>MBS( "XL.Format.SetAlignH"; $book; $textFormat; 1) // left</Calculation>
    </Value>
    <Repetition>
      <Calculation>1</Calculation>
    </Repetition>
    <Name>$r</Name>
  </Step>
  <Step enable="True" id="141" name="Set Variable">
    <Value>
      <Calculation>MBS( "XL.Format.SetAlignV"; $book; $textFormat; 0) // top </Calculation>
    </Value>
    <Repetition>
      <Calculation>1</Calculation>
    </Repetition>
    <Name>$r</Name>
  </Step>
</fmxmlsnippet>

Example Databases

XL/Writing data

This function checks for a license.

Created 18th August 2014, last changed 19th October 2021

XL.Format.SetAlignH - XL.Format.SetBorder