Number Col Boxes

JMP Support 800.450.0135 (US)

Documentation Feedback
Your feedback is important to us. us any comments about our documentation.

JSL Syntax Reference • JSL Messages • Display Boxes • Number Col Boxes

•

Number Col Boxes

number col box<<Add Element(item)

Adds the item to the Number Col Box. Item can be a single number, a list of numbers, or a matrix of numbers.

number col box<<Get

number col box<<Get(i)

Gets the values in a list, or the i th value.

number col box<<Get As Matrix

Gets the values in a matrix, specifically a column vector.

number col box<<Get Format

Returns the current format.

number col box<<Get Heading

Returns the column heading text.

number col box<<Remove Element(row number)

Removes an element from the column at the specified position.

number col box<<Set Format(<width>|<width, decimal places>, <"Use thousands separator">)

number col box<<Set Format("Best", <width>, <"Use thousands separator">)

number col box<<Set Format(("Fixed Dec"|"Percent"), <width>|<width, decimal places>, <"Use thousands separator">)

number col box<<Set Format("Pvalue", <width>)

number col box<<Set Format(("Scientific"|"Engineering"|"Engineering SI"), <width>|<width, decimal places>)

number col box<<Set Format("Precision", <width>|<width, decimal places>, <"Use thousands separator">, <"Keep trailing zeroes">, <"Keep all whole digits">)

number col box<<Set Format("Currency", <"currency code">, <width>|<width, decimal places>, <"Use thousands separator">)

number col box<<Set Format("datetime", <width>, <input format>)

number col box<<Set Format(("Latitude DDD"|"Latitude DDM"|"Latitude DMS"|"Longitude DDD"|"Longitude DDM"|"Longitude DDM"), <width>|<width, decimal places>, ("PUN"|"DIR"|"PUNDIR"))

number col box<<Set Format("Custom", Formula(...), <width>, <input format>)

Sets the column format.

Numeric Formats in the Using JMP book describes the arguments. Note that Matrix Box(), Number Col Box(), Number Col Edit Box(), Number Edit Box() have the same Set Format syntax.

<<Set Format( 10, 2, "Use thousands separator");

<<Set Format( "Currency", "EUR", 20, );

<<Set Format( "m/d/y", 10 );

<<Set Format( "Precision", 10, 2, "Keep trailing zeroes", "Keep all whole digits" );

<<Set Format( "Latitude DDD", "PUNDIR"); // "PUN" for punctuation, "DIR" for direction, PUNDIR for both

<<Set Format( "Custom", Formula( Abs( value ) ), 15 );

•

For a list of currency codes, see Currency in the Scripting Guide. The currency code is based on the locale if the code is omitted.

•

If you don’t specify the format, set the decimal places to greater than 100 for datetime values and to 97 for p-values.

•

You must always precede the number of decimal places with the width.

•

Options can be defined in a list or a variable, or they can be in a Function() that is evaluated.

ncbFunc = Function({}, {"Fixed", 12, 5});

number col box<<Set Heading("string")

Changes the column heading text.

•

Help created on 7/12/2018