RangeBorderType Enumeration

Summary

Defines the types of borders that can be applied to cell ranges within an Excel sheet. Allows developers to specify the borders of a cell range should be styled or modified, offering a range of options from individual borders to comprehensive sets.

Syntax

TypeScript
JavaScript
lt.Document.SheetEditor.RangeBorderType = { 
	none: 0, 
	top: 1, 
	bottom: 2, 
	left: 3, 
	right: 4, 
	all: 5, 
	outside: 6, 
	inside: 7, 
	horizontal: 8, 
	vertical: 9 
} 
lt.Document.SheetEditor.RangeBorderType = { 
	none: 0, 
	top: 1, 
	bottom: 2, 
	left: 3, 
	right: 4, 
	all: 5, 
	outside: 6, 
	inside: 7, 
	horizontal: 8, 
	vertical: 9 
} 

Members

Value Name Description
0 none No border should be applied to the cell range.
1 top Applies a border to the top edge of the cell range.
2 bottom Applies a border to the bottom edge of the cell range.
3 left Applies a border to the left edge of the cell range.
4 right Applies a border to the right edge of the cell range.
5 all Applies borders to all edges of each cell within the range.
6 outside Applies borders only to the outer edges of the cell range, not affecting borders between cells within the range.
7 inside Applies borders to the edges between cells within the range, excluding the outer edges.
8 horizontal Applies horizontal borders between cells within the range, excluding the top and bottom outer edges.
9 vertical Applies vertical borders between cells within the range, excluding the left and right outer edges.

Requirements

Target Platforms

See Also

Leadtools.Document.SheetEditor Namespace

Help Version 23.0.2024.5.29
Products | Support | Contact Us | Intellectual Property Notices
© 1991-2024 LEAD Technologies, Inc. All Rights Reserved.

Leadtools.Document.SheetEditor Assembly

Products | Support | Contact Us | Intellectual Property Notices
© 1991-2023 LEAD Technologies, Inc. All Rights Reserved.