Skip to content

Latest commit

 

History

History
53 lines (44 loc) · 1.52 KB

SetWSCellFill.md

File metadata and controls

53 lines (44 loc) · 1.52 KB

SetWSCellFill

Description

Sets the fill style and color of a cell in the referenced worksheet

SetWSCellFill allows cell fill style and color text to be set for a range of cells. To set fill style and color for a single cell, specify identical values for the top/bottom and left/right range boundaries.

PROCEDURE SetWSCellFill(
				worksheet   : HANDLE;
				topRow      : INTEGER;
				leftColumn  : INTEGER;
				bottomRow   : INTEGER;
				rightColumn : INTEGER;
				style       : INTEGER;
				bgcolor     : LONGINT;
				fgcolor     : LONGINT;
				fillpattern : INTEGER);
def vs.SetWSCellFill(worksheet, topRow, leftColumn, bottomRow, rightColumn, style, bgcolor, fgcolor, fillpattern):
    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
style INTEGER Cell fill style to be set
bgcolor LONGINT Cell background color index value to be set
fgcolor LONGINT Cell foreground color index value to be set
fillpattern INTEGER Cell pattern index value to be set

Remarks

bgcolor - cell background color (0 if none) fgcolor - cell foreground color (0 if none) fillpattern - cell fill pattern index (-1 if none)

Fill style constants: no fill = 0 solid fill= 1 pattern fill= 2

Version

Availability: from VectorWorks12.0

Category