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

XL.ConditionalFormat.SetBorderBottom

Sets the bottom border style.

Component Version macOS Windows Linux Server iOS SDK
XL 14.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.ConditionalFormat.SetBorderBottom"; bookRef; ConditionalFormatRef; Value )   More

Parameters

Parameter Description Example
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
ConditionalFormatRef The reference number for the conditional format. $ConditionalFormat
Value The border style.
Default value is 1 for thin.
1

Result

Returns OK or error.

Description

Sets the bottom border style.

Examples

Create border format:

Set Variable [$f; Value:MBS( "XL.Sheet.AddConditionalFormatting"; $book)]
Set Variable [$r; Value:MBS( "XL.ConditionalFormat.SetBorderBottom"; $book; $f; 1) // thin ]

See also

Created 30th March 2024, last changed 11st May 2024


XL.ConditionalFormat.SetBorder - XL.ConditionalFormat.SetBorderBottomColor