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.Sheet.SetFooter

Sets the footer text for the sheet when printed.

Component Version macOS Windows Linux Server FileMaker iOS SDK
XL 3.5 Yes Yes Yes Yes Yes
MBS( "XL.Sheet.SetFooter"; bookRef; sheetIndex; Text { ; Margin } )   More

Parameters

Parameter Description Example Flags
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
sheetIndex The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0
Text The new footer text. "test"
Margin The margin to use. 0.5 Optional

Result

Returns OK or error message.

Description

Sets the footer text for the sheet when printed.
The footer text appears at the bottom of every page when printed. The length of the text must be less than or equal to 255. The footer text can contain special commands, for example a placeholder for the page number, current date or text formatting attributes. See XL.SetHeader for details. Margin is specified in inches.

See also

Created 18th August 2014, last changed 11st July 2016


XL.Sheet.SetDisplayGridlines   -   XL.Sheet.SetGroupSummaryBelow

Feedback: Report problem or ask question.



Links
MBS Xojo PDF Plugins

Start Chat