3.5.1.7 Miscellaneous Functions


Name Brief Example
BitAND(int a, int b) Returns bitwise AND operation of two integers. Example
BitOR(int a, int b) Returns bitwise OR operation of two integers. Example
BitXOR Returns bitwise XOR operation of two integers. Example
colnum Returns the column position number of the column specified by colName. Example
color(name) Returns a number corresponding to the index in the color list of the color specified by the name or by the RGB value. Example
exist(name) Returns a single value indicating what 'object type' the given name is associated with string value.
font(name) Returns a number corresponding to the font list index of the font specified by name.
hex(string) Returns the base 10 equivalent to the hexadecimal value represented by the given string. Example
ISNA(double dd) Determines whether the number is a NANUM. Example
isText(string) Determine whether an input is a text. Example
Missing Value Equal to NANUM in Origin C.
NA() Returns NANUM. Example
NameOf Get the actual internal dataset name from a range string.
ocolor2rgb(oColor) Convert an internal color code ocolor to RGB value. Example
Range2uid Return the universal identifier (UID) given a range specifier (not a range variable!).
Uid2name Return a name (i.e., [Book1]Sheet1!1) corresponding to a range of data, given a universal identifier (UID) as input.
Uid2range Return a range variable given a universal identifier (UID) as input.
xf_get_last_error_code Returns the last error code value of XFunction engine.
xf_get_last_error_message Returns the last error string message of XFunction engine.
xor(n1,n2) Returns XOR operation of two logical values n1 and n2. Example