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

XL.Format.SetBorderColor

Sets the border color.

Component Version macOS Windows Linux Server iOS SDK
XL 3.5 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XL.Format.SetBorderColor"; 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 border color.
Color values if not in RGB Mode:
Black8
White9
Red10
Brightgreen11
Blue12
Yellow13
Pink14
Turquoise15
Darkred16
Green17
Darkblue18
Darkyellow19
Violet20
Teal21
Gray2522
Gray5023
Periwinkle Cf24
Plum Cf25
Ivory Cf26
Lightturquoise Cf27
Darkpurple Cf28
Coral Cf29
Oceanblue Cf30
Iceblue Cf31
Darkblue Cl32
Pink Cl33
Yellow Cl34
Turquoise Cl35
Violet Cl36
Darkred Cl37
Teal Cl38
Blue Cl39
Skyblue40
Lightturquoise41
Lightgreen42
Lightyellow43
Paleblue44
Rose45
Lavender46
Tan47
Lightblue48
Aqua49
Lime50
Gold51
Lightorange52
Orange53
Bluegray54
Gray4055
Darkteal56
Seagreen57
Darkgreen58
Olivegreen59
Brown60
Plum61
Indigo62
Gray8063
Default Foreground64
Default Background65
Tooltip81
Auto32767

See also

Example Databases

This function checks for a license.

Created 18th August 2014, last changed 18th August 2014


XL.Format.SetBorderBottomColor - XL.Format.SetBorderDiagonal