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;
str$=;

-e

Syntax: get name -e [variableName]

Get the end of the display range. The value of variableName equals the last index (row) number.

-f

Syntax: get name -f [variableName]

Get the corresponding X value for the first data point when X values are from an initial value and an increment such as Sampling Interval.

-hbb

Syntax: get name -hbb [variableName]

Get the histogram lower bin value. Get the lower limit of the binned data.

-hbe

Syntax: get name -hbe [variableName]

Get the histogram upper bin value. Get the upper limit of the binned data.

-hbs

Syntax: get name -hbs [variableName]

Get the histogram bin size. Therefore number of bins can be calculated:

get %C -hbb lower;
get %C -hbe upper;
get %C -hbs size;
type Number of bins \x3D $((upper - lower) / size );

-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.