SetWSCellFormula.md

SetWSCellFormula

Description

Inserts a formula into a cell of the referenced worksheet.

SetWSCellFormula allows a formula to be inserted into a rectangular range of cells. To insert a formula into a single cell, specify identical values for the top/bottom and left/right range boundaries.

PROCEDURE SetWSCellFormula(
				worksheet   : HANDLE;
				topRow      : INTEGER;
				leftColumn  : INTEGER;
				bottomRow   : INTEGER;
				rightColumn : INTEGER;
				formula     : STRING);

def vs.SetWSCellFormula(worksheet, topRow, leftColumn, bottomRow, rightColumn, formula):
    return None

Parameters

Name	Type	Description
worksheet	HANDLE	Handle to worksheet.
topRow	INTEGER	Top row of cell insertion range.
leftColumn	INTEGER	Leftmost column of cell insertion range.
bottomRow	INTEGER	Bottom row of cell insertion range.
rightColumn	INTEGER	Rightmost column of cell insertion range.
formula	STRING	Formula to be inserted into cell range.

Remarks

Sets specified formula string in specified worksheet cell(s). If the 0 column is specified, a database row is created and the formula set as the database row criteria.

Examples

VectorScript

{ inserts a formula into a single cell }
SetWSCellFormula(h,4,2,4,2,'=3*2');

{ inserts a formula into a range of cells }
SetWSCellFormula(h,1,1,2,10,'<empty>');

{ creates a database sub-row for the record 'Part Info' }
SetWSCellFormula(h,2,0,2,0,'=DATABASE(R IN [''PART INFO''])');

Python

Version

Availability: from VectorWorks9.0

Category

• Worksheets