SprdFormat.md

SprdFormat

Description

Procedure SprdFormat determines the number format for cells within the active worksheet.

Values for ldr and trailr may not exceed 8 characters.

{| class="wikitable_c" |+ Table - Worksheet Cell Formats

! Cell Format !! Constant
General
style="text-align:center"
-
Decimal
style="text-align:center"
-
Decimal/comma
style="text-align:center"
-
Scientific
style="text-align:center"
-
Fractional
style="text-align:center"
-
Dimension
style="text-align:center"
-
Angle
style="text-align:center"
}

PROCEDURE SprdFormat(
				numForm : INTEGER;
				acc     : INTEGER;
				ldr     : STRING;
				trailr  : STRING);

def vs.SprdFormat(numForm, acc, ldr, trailr):
    return None

Parameters

Name	Type	Description
numForm	INTEGER	Numeric format of cell.
acc	INTEGER	Numeric accuracy setting.
ldr	STRING	String prefix for cell.
trailr	STRING	String suffix for cell.

Examples

==== VectorScript ====

SprdFormat(2, 2, '$', '');
LoadCell(1, 1, '=500 * 3.25');

==== Python ====

See Also

SetWSCellNumberFormat| SetWSCellNumberFormat

Version

SprdFormat is obsolete as of VectorWorks 9.0, see new [[VS:SetWSCellNumberFormat| SetWSCellNumberFormat]].

Availability: from All Versions

Category

• Worksheets