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:
Black | 8 |
White | 9 |
Red | 10 |
Brightgreen | 11 |
Blue | 12 |
Yellow | 13 |
Pink | 14 |
Turquoise | 15 |
Darkred | 16 |
Green | 17 |
Darkblue | 18 |
Darkyellow | 19 |
Violet | 20 |
Teal | 21 |
Gray25 | 22 |
Gray50 | 23 |
Periwinkle Cf | 24 |
Plum Cf | 25 |
Ivory Cf | 26 |
Lightturquoise Cf | 27 |
Darkpurple Cf | 28 |
Coral Cf | 29 |
Oceanblue Cf | 30 |
Iceblue Cf | 31 |
Darkblue Cl | 32 |
Pink Cl | 33 |
Yellow Cl | 34 |
Turquoise Cl | 35 |
Violet Cl | 36 |
Darkred Cl | 37 |
Teal Cl | 38 |
Blue Cl | 39 |
Skyblue | 40 |
Lightturquoise | 41 |
Lightgreen | 42 |
Lightyellow | 43 |
Paleblue | 44 |
Rose | 45 |
Lavender | 46 |
Tan | 47 |
Lightblue | 48 |
Aqua | 49 |
Lime | 50 |
Gold | 51 |
Lightorange | 52 |
Orange | 53 |
Bluegray | 54 |
Gray40 | 55 |
Darkteal | 56 |
Seagreen | 57 |
Darkgreen | 58 |
Olivegreen | 59 |
Brown | 60 |
Plum | 61 |
Indigo | 62 |
Gray80 | 63 |
Default Foreground | 64 |
Default Background | 65 |
Tooltip | 81 |
Auto | 32767 |
See also
- XL.Format.GetBorderTopColor
- XL.Format.SetBorderBottom
- XL.Format.SetBorderBottomColor
- XL.Format.SetBorderDiagonal
- XL.Format.SetBorderLeft
- XL.Format.SetBorderRight
- XL.Format.SetBorderRightColor
- XL.Format.SetBorderTop
- XL.Format.SetBorderTopColor
- XL.LoadBook
Example Databases
This function checks for a license.
Created 18th August 2014, last changed 18th August 2014
XL.Format.SetBorderBottomColor - XL.Format.SetBorderDiagonal