| 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
