Skip to content

SetSprdSortSum.md

Latest commit

 

History

History
62 lines (50 loc) · 1.85 KB

SetSprdSortSum.md

File metadata and controls

62 lines (50 loc) · 1.85 KB
Raw

SetSprdSortSum

Description

Procedure SetSprdSortSum specifies sorting and summation options for a database row in the referenced worksheet. For descending sorts, pass the column as a negative value. For no sort, pass 0 as the sumCol column.

PROCEDURE SetSprdSortSum(
				sheetHd  : HANDLE;
				row      : INTEGER;
				sortCol1 : INTEGER;
				sortCol2 : INTEGER;
				sortCol3 : INTEGER;
				sumCol   : INTEGER);
def vs.SetSprdSortSum(sheetHd, row, sortCol1, sortCol2, sortCol3, sumCol):
    return None

Parameters

Name Type Description
sheetHd HANDLE Handle to worksheet.
row INTEGER Worksheet database row index.
sortCol1 INTEGER Primary sort column index.
sortCol2 INTEGER Secondary sort column index.
sortCol3 INTEGER Tertiary sort column index.
sumCol INTEGER Summation column.

Remarks

Sets sorting and summation for a database row. The sortCol1, sortCol2, and sortCol3 values specify the primary, secondary and tertiary sorts for the database row. Pass a positive column for a descending sort; pass a negative column for an ascending sort. For no sort, pass 0 as the column. Sum works the same way. [VML 01/09/01]

Examples

SetSprdSortSum(sheetHd, 1, 2, 3, 10, 5);
import vs

# Procedure SetSprdSortSum specifies sorting and summation options for a
# database row in the referenced worksheet.
sheetHd = vs.FSActLayer()  # handle to the first selected object on the active layer
row = 10
sortCol1 = 5
sortCol2 = 5
sortCol3 = 5
sumCol = 5

vs.SetSprdSortSum(sheetHd, row, sortCol1, sortCol2, sortCol3, sumCol)

See Also

SetWSColumnOperators

Version

SetSprdSortSum is obsolete as of VectorWorks 9.0, see new SetWSColumnOperators

Availability: from VectorWorks 8.0

Category