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: 12.2   12.3   12.4   12.5   13.0   13.1   13.2   13.3   13.4   13.5    Statistic    FMM    Blog  

XL.FormControl.SetFmlaRange

Sets the cell reference with range of source data cells.

Component Version macOS Windows Linux Server iOS SDK
XL 13.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.FormControl.SetFmlaRange"; bookRef; sheetIndex; FormControlIndex; Range )   More

Parameters

Parameter Description Example
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
FormControlIndex The index of the from control
Ranges from 0 to XL.Sheet.FormControlCount - 1.
$formControlIndex
Range The new range value.

Result

Returns OK or error.

Description

Sets the cell reference with range of source data cells.
This attribute only applies to list box and drop-down form controls.

See also

Blog Entries

Created 3th February 2023, last changed 3th February 2023


XL.FormControl.SetFmlaLink - XL.FormControl.SetFmlaTxbx

💬 Ask a question or report a problem