Defines a set of styles that can be applied to the borders of cells. The supported border styles range from very basic to more complex patterns, resulting in an extensive set of visual presentation options.
lt.Document.SheetEditor.BorderStyle = {
none: 0,
thin: 1,
hair: 2,
dotted: 3,
dashed: 4,
dashDot: 5,
dashDotDot: 6,
doubleLines: 7,
medium: 8,
mediumDashed: 9,
mediumDashDot: 10,
mediumDashDotDot: 11,
slantedDashDot: 12,
thick: 13
}
Value | Member | Description |
---|---|---|
0 | none |
No border. |
1 | thin |
A thin, single line border. |
2 | hair |
A very fine, hairline border. |
3 | dashed |
A border consisting of dashes. |
4 | dotted |
A border comprising of dots. |
5 | dashDot |
Alternating dashes and dots. |
6 | dashDotDot |
A DashDotDot pattern. |
7 | doubleLines |
Two parallel lines. |
8 | medium |
Thicker than Thin, a medium line border. |
9 | mediumDashed |
A dashed line that's thicker than the Dashed style. |
10 | mediumDashDot |
A DashDot pattern with a medium thickness. |
11 | mediumDashDotDot |
A DashDotDot pattern with a medium thickness. |
12 | slantedDashDot |
Dashes and dots placed in a slanted manner. |
13 | thick |
A thick line border. |
The BorderStyle enumeration allows for detailed customization of cell borders.
The styles range from simple (thin
, medium
, thick
) to more complex patterns (dashDot
, mediumDashDot
, etc.), providing flexibility for different aesthetic and functional requirements.
For instance, the none
style is useful for removing borders or ensuring that no border is applied.