Enum BorderStyle
Stay organized with collections
Save and categorize content based on your preferences.
BorderStyle
Styles that can be set on a range using Range.setBorder(top, left, bottom, right, vertical, horizontal, color, style)
.
To call an enum, you call its parent class, name, and property. For example,
SpreadsheetApp.BorderStyle.DOTTED
.
Properties
Property | Type | Description |
DOTTED | Enum | Dotted line borders. |
DASHED | Enum | Dashed line borders. |
SOLID | Enum | Thin solid line borders. |
SOLID_MEDIUM | Enum | Medium solid line borders. |
SOLID_THICK | Enum | Thick solid line borders. |
DOUBLE | Enum | Two solid line borders. |
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-02 UTC.
[null,null,["Last updated 2024-12-02 UTC."],[[["\u003cp\u003e\u003ccode\u003eBorderStyle\u003c/code\u003e in Google Apps Script is used to define the style of borders applied to a range of cells within a spreadsheet.\u003c/p\u003e\n"],["\u003cp\u003eYou can apply borders to the top, bottom, left, right, vertical, and horizontal edges of a range.\u003c/p\u003e\n"],["\u003cp\u003eBorder styles include dotted, dashed, solid (in varying thicknesses), and double lines.\u003c/p\u003e\n"],["\u003cp\u003eTo set a border style, you need to call \u003ccode\u003eRange.setBorder()\u003c/code\u003e with arguments specifying the desired style and colors.\u003c/p\u003e\n"],["\u003cp\u003e\u003ccode\u003eBorderStyle\u003c/code\u003e is an enum within the \u003ccode\u003eSpreadsheetApp\u003c/code\u003e class and its properties (like \u003ccode\u003eDOTTED\u003c/code\u003e or \u003ccode\u003eSOLID\u003c/code\u003e) are accessed as \u003ccode\u003eSpreadsheetApp.BorderStyle.DOTTED\u003c/code\u003e.\u003c/p\u003e\n"]]],["Border styles can be applied to a range using `Range.setBorder()`, specifying top, left, bottom, right, vertical, and horizontal borders, along with color and style. The available border styles, accessed via `SpreadsheetApp.BorderStyle`, include `DOTTED`, `DASHED`, `SOLID`, `SOLID_MEDIUM`, `SOLID_THICK`, and `DOUBLE`. Each style corresponds to a different line appearance, ranging from dotted to thick solid lines, as well as double lines.\n"],null,["# Enum BorderStyle\n\nBorderStyle\n\nStyles that can be set on a range using [Range.setBorder(top, left, bottom, right, vertical, horizontal, color, style)](/apps-script/reference/spreadsheet/range#setBorder(Boolean,Boolean,Boolean,Boolean,Boolean,Boolean,String,BorderStyle)).\n\nTo call an enum, you call its parent class, name, and property. For example, `\nSpreadsheetApp.BorderStyle.DOTTED`. \n\n### Properties\n\n| Property | Type | Description |\n|----------------|--------|----------------------------|\n| `DOTTED` | `Enum` | Dotted line borders. |\n| `DASHED` | `Enum` | Dashed line borders. |\n| `SOLID` | `Enum` | Thin solid line borders. |\n| `SOLID_MEDIUM` | `Enum` | Medium solid line borders. |\n| `SOLID_THICK` | `Enum` | Thick solid line borders. |\n| `DOUBLE` | `Enum` | Two solid line borders. |"]]