Sets the horizontal alignment of a cell in the referenced worksheet.
SetWSCellAlignment allows a formula to be inserted into a rectangular range of cells. To set the alignment of a single cell, specify identical values for the top/bottom and left/right range boundaries.
Alignment index values for worksheet cells correspond to the horizontal alignment index values for text used by VectorScript.
{| class="wikitable_c" |+ Table - Worksheet Cell Alignment
| ! Alignment !! Constant |
|---|
| Left |
| style="text-align:center" |
| - |
| Center |
| style="text-align:center" |
| - |
| Right |
| style="text-align:center" |
| - |
| General |
| style="text-align:center" |
| } |
PROCEDURE SetWSCellAlignment(
worksheet : HANDLE;
topRow : INTEGER;
leftColumn : INTEGER;
bottomRow : INTEGER;
rightColumn : INTEGER;
cellAlignment : INTEGER);def vs.SetWSCellAlignment(worksheet, topRow, leftColumn, bottomRow, rightColumn, cellAlignment):
return None| Name | Type | Description |
|---|---|---|
| worksheet | HANDLE | Handle to worksheet. |
| topRow | INTEGER | Top row of cell range. |
| leftColumn | INTEGER | Leftmost column of cell range. |
| bottomRow | INTEGER | Bottom row of cell range. |
| rightColumn | INTEGER | Rightmost column of cell range. |
| cellAlignment | INTEGER | The new alignment index value. |
Availability: from VectorWorks 9.0
- Worksheets