# 3.3.2.22.1 Options for Columns

## -b

Syntax: get name -b [variableName]

Get the beginning of the display range.The value of variableName equals the first index (row) number.

## -b3o

Syntax: get name -b3o [variableName]

Get the base value from which the 3D Bars are drawn and put to variableName. This option applies to both XYZ/Matrix 3D Bar and XYY 3D Bar. It supports 2 values, 0 and 1. 0 means the bars will start at Z = 0 and draw up if positive and down if negative. 1 means the bars will draw from the minimum Z value if any negative values exist.

get %c -b3o nOutPutVar; //get the start value of the current selected 3d bar plot to nOurPutVar.

## -b3co

Syntax: get %c -b3co value

Get fill type of 3D surface plot when the fill mode is Fill piece by piece

2=Color Mapping
3=Indexing
4= Direct RGB

## -b3cd

Syntax: get %c -b3cd datasetName

Get dataset name of 3D surface plot fill when the fill mode is Fill piece by piece

get %c -b3cd str;

## -i

Syntax: get name -i [variableName]

Get the X increment for the name dataset when X values are from an initial value and an increment such as Sampling Interval.

## -it

Syntax: get name -it [variableName]

Get the internal data type for the name dataset or matrix and place this value in variableName. For example, to get the internal data type of the active dataset held in %C and assign this value to a variable named v, use: get %C -it v; Possible return values are the same as the constants defined in the oc_const.h Origin C header file (located in the \OriginC\system subfolder):

• FSI_DOUBLE = 0
• FSI_REAL = 1
• FSI_SHORT = 2
• FSI_LONG = 3
• FSI_CHAR = 4
• FSI_TEXT = 5
• FSI_MIXED = 6
• FSI_BYTE = 7
• FSI_USHORT = 8
• FSI_ULONG = 9

If %C is a column in a worksheet, then only a Numeric column is supported and only types FSI_DOUBLE, FSI_REAL, FSI_SHORT, and FSI_LONG are supported. If %C is a matrix, then all these constants are supported, but FSI_TEXT and FSI_MIXED should be avoided.

## -set

Syntax: get datasetname -set value

Get whether the format of numeric string was set to text type (value=1) or numeric type (value=0) when the column format is Text & Numeric.

range rr = !A;
get rr -set value;
value=;

This command get whether the format of data was set to text type (value=1) or numeric type (value=0) by Set command.

range rr = !A;
set rr -set value;

In addation, if Never convert text to numeric during data entry checkbox checked in The (Column Properties) Properties Tab, the value will be set to 1, otherwise, value will be set to 0.