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

Sets the locked property.

Component Version macOS Windows Linux Server FileMaker iOS SDK
XL 3.5 Yes Yes Yes Yes Yes
MBS( "XL.Format.SetLocked"; 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

Result

Returns OK or error.

Description

Sets the locked property.
Needs to be used together with XL.Sheet.SetProtect or XL.Sheet.SetProtectEx function to prevent editing in locked cells.

Examples

Create locked format:

Set Variable [$textFormat; Value:MBS( "XL.Book.AddFormat"; $book)]
Set Variable [$r; Value:MBS( "XL.Format.SetLocked"; $book; $textFormat; 1) // locked ]

See also

Created 18th August 2014, last changed 11st February 2020


XL.Format.SetIndent   -   XL.Format.SetNumFormat

Feedback: Report problem or ask question.



Links
MBS Xojo tutorial videos

Start Chat