Skip to content

Latest commit

 

History

History
94 lines (77 loc) · 3.3 KB

SetWSCellBorders.md

File metadata and controls

94 lines (77 loc) · 3.3 KB

SetWSCellBorders

Description

Sets the borders of cells in the referenced worksheet

SetWSCellBorders allows borders to be set for a rectangular range of cells. To set the border formatting of a single cell, specify identical values for the top/bottom and left/right range boundaries.

Note: A rectangular range of cells is formatted as a single block of cells. If you apply a right border to the range of cells, the border is displayed only on the right edge of the cells.

The borders will be created with default values ( solid style, black color, standard weight).

PROCEDURE SetWSCellBorders(
				worksheet     : HANDLE;
				topRow        : INTEGER;
				leftColumn    : INTEGER;
				bottomRow     : INTEGER;
				rightColumn   : INTEGER;
				top           : BOOLEAN;
				left          : BOOLEAN;
				bottom        : BOOLEAN;
				right         : BOOLEAN;
				OutlineInside : INTEGER);
def vs.SetWSCellBorders(worksheet, topRow, leftColumn, bottomRow, rightColumn, top, left, bottom, right, OutlineInside):
    return None

Parameters

Name Type Description
worksheet HANDLE Handle to worksheet
topRow INTEGER Top row of cell range
leftColumn INTEGER Left column of cell range
bottomRow INTEGER Bottom row of cell range
rightColumn INTEGER Right column of cell range
top BOOLEAN Top border ON-OFF status
left BOOLEAN Left border ON-OFF status
bottom BOOLEAN Bottom border ON-OFF status
right BOOLEAN Right border ON-OFF status
OutlineInside INTEGER Outline and Inside borders constant

Remarks

OulineInside defines the outline, inside horizontal and inside vertical borders.

Available Constants

Const outline inside horizontal inside vertical
0 false false false
1 true false false
2 false true false
3 true true false
4 false false true
5 true false true
6 false true true
7 true true true

This replaces SetWSCellBorder which became obsolete as of version 12. (You can see obsolete functions by setting the preference on the home page.)

Examples

VectorScript

{ Sets the inside horizontal and vertical borders for the specified rectangular range of cells}
SetWSCellBorders(sheet, 2, 4, 1, 5, FALSE, FALSE, FALSE, FALSE, 6);

{ Sets an outline border for the specified rectangular range of cells}
SetWSCellBorders(sheet,2,4,1,5,FALSE,FALSE,FALSE,FALSE,1);
{or}
SetWSCellBorders(sheet,2,4,1,5,TRUE,TRUE,TRUE,TRUE,0);

Python



See Also


VS Functions:



Version


Availability: from VectorWorks 12.0


Category