BYE DESIGN LTD

A Microsoft Windows Mobile Solutions Partner

Electronic mail address: stephenbye@byedesign.co.uk
Copyright Bye Design Ltd 1999. Last revised: July 21, 2023.

What functions are supported?

Supported functions ( [ ] indicates optional parameters ) :

Database
DAVERAGE(database_range, field, criteria_range)
DCOUNT(database_range, [field], criteria_range)
DCOUNTA(database_range, [field], criteria_range)
DGET(database_range, field, criteria_range)
DMAX(database_range, field, criteria_range)
DMIN(database_range, field, criteria_range)
DPRODUCT(database_range, field, criteria_range)
DSTDEV(database_range, field, criteria_range)
DSTDEVP(database_range, field, criteria_range)
DSUM(database_range, field, criteria_range)
DVAR(database_range, field, criteria_range)
DVARP(database_range, field, criteria_range)

Date/time
DATE(year, month, day)
DATEDIF(date1, date2, units)
DATEVALUE(date_text)
DAY(serial_number)
DAYS(end_date, start_date)
DAYS360(start_date, end_date, [method])
EDATE(start_date, months)
EOMONTH(start_date, months)
HOUR(serial_number)
ISOWEEKNUM(date)
MINUTE(serial_number)
MONTH(serial_number)
NETWORKDAYS(start_date, end_date, [holidays])
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
NOW()
SECOND(serial_number)
TIME(hour, minute, second)
TIMEVALUE(time_text)
TODAY()
WEEKDAY(serial_number, [return_type])
WEEKNUM(serial_number, [return_type])
WORKDAY(start_date, number_days, [holidays])
WORKDAY.INTL(start_date, number_days, [weekend], [holidays])
YEAR(serial_number)
YEARFRAC(start_date, end_date, [basis])

Engineering
BESSELI(x, n)
BESSELJ(x, n)
BESSELK(x, n)
BESSELY(x, n)
BIN2DEC(number)
BIN2HEX(number, [places])
BIN2OCT(number, [places])
BITAND(number1, number2)
BITLSHIFT(number, shift_amount)
BITOR(number1, number2)
BITRSHIFT(number, shift_amount)
BITXOR(number1, number2)
COMPLEX(real_num, imag_num, [suffix])
CONVERT(number, from_unit, to_unit)
DEC2BIN(number, [places])
DEC2HEX(number, [places])
DEC2OCT(number, [places])
DELTA(number1, [number2])
ERF(lower_limit, [upper_limit])
ERF.PRECISE(x) ERFC(x)
ERFC.PRECISE(x) GESTEP(number, [step])
HEX2BIN(number, [places])
HEX2DEC(number)
HEX2OCT(number, [places])
IMABS(inumber)
IMAGINARY(inumber)
IMARGUMENT(inumber)
IMCONJUGATE(inumber)
IMCOS(inumber)
IMCOSH(inumber)
IMCOT(inumber)
IMCSC(inumber)
IMCSCH(inumber)
IMDIV(inumber1, inumber2)
IMEXP(inumber)
IMLN(inumber)
IMLOG10(inumber)
IMLOG2(inumber)
IMPOWER(inumber, number)
IMPRODUCT(inumber1, [inumber2, ...])
IMREAL(inumber)
IMSEC(inumber)
IMSECH(inumber)
IMSIN(inumber)
IMSINH(inumber)
IMSQRT(inumber)
IMSUB(inumber1, inumber2)
IMSUM(inumber1, [inumber2, ...])
IMTAN(inumber)
OCT2BIN(number, [places])
OCT2DEC(number)
OCT2HEX(number, [places])

Financial
ACCRINT(issue_date, first_interest_date, settlement_date, rate, par, frequency, [basis])
ACCRINTM(issue_date, maturity_date, rate, [par], [basis])
AMORDEGRC(cost, purchase_date, first_period_date, salvage, period, rate, [basis])
AMORLINC(cost, purchase_date, first_period_date, salvage, period, rate, [basis])
COUPDAYBS(settlement_date, maturity_date, frequency, [basis])
COUPDAYS(settlement_date, maturity_date, frequency, [basis])
COUPDAYSNC(settlement_date, maturity_date, frequency, [basis])
COUPNCD(settlement_date, maturity_date, frequency, [basis])
COUPNUM(settlement_date, maturity_date, frequency, [basis])
COUPPCD(settlement_date, maturity_date, frequency, [basis])
CUMIPMT(rate, nper, pv, start_period, end_period, type)
CUMPRINC(rate, nper, pv, start_period, end_period, type)
DB(cost, salvage, life, period, [month])
DDB(cost, salvage, life, period, [factor])
DISC(settlement_date, maturity_date, pr, redemption, [basis])
DOLLARDE(fractional_dollar, fraction)
DOLLARFR(decimal_dollar, fraction)
DURATION(settlement_date, maturity_date, coupon, yield, frequency, [basis])
EFFECT(nominal_rate, npery)
FV(rate, term, payment, [pv], [type])
FVSCHEDULE(principal, schedule_range)
INTRATE(settlement_date, maturity_date, investment_amount, redemption_amount, [basis])
IPMT(rate, period, term, pv, [fv], [type])
IRR(values_range, [guess])
ISPMT(rate, period, term, pv)
MDURATION(settlement_date, maturity_date, coupon, yield, frequency, [basis])
MIRR(values_range, finance_rate, reinvest_rate)
NOMINAL(effect_rate, npery)
NPER(rate, payment, pv, [fv], [type])
NPV(rate, value1, [value2, ...])
ODDFPRICE(settlement_date, maturity_date, issue_date, first_coupon_date, rate, yield, redemption, frequency, [basis])
ODDFYIELD(settlement_date, maturity_date, issue_date, first_coupon_date, rate, price, redemption, frequency, [basis])
ODDLPRICE(settlement_date, maturity_date, last_coupon_date, rate, yield, redemption, frequency, [basis])
ODDLYIELD(settlement_date, maturity_date, last_coupon_date, rate, price, redemption, frequency, [basis])
PDURATION(rate, pv, fv)
PMT(rate, term, [pv], [fv], [type])
PPMT(rate, period, term, pv, [fv], [type])
PRICE(settlement_date, maturity_date, rate, yield, redemption, frequency, [basis])
PRICEDISC(settlement_date, maturity_date, discount, redemption, [basis])
PRICEMAT(settlement_date, maturity_date, issue_date, rate, yield, [basis])
PV(rate, term, payment, [fv], [type])
RATE(term, payment, pv, [fv], [type], [guess])
RECEIVED(settlement_date, maturity_date, investment, discount, [basis])
RRI(nper, pv, fv)
SLN(cost, salvage, life)
SYD(cost, salvage, life, period)
TBILLEQ(settlement_date, maturity_date, discount)
TBILLPRICE(settlement_date, maturity_date, discount)
TBILLYIELD(settlement_date, maturity_date, price)
VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch])
XIRR(values_range, dates_range, [guess])
XNPV(rate, values_range, dates_range)
YIELD(settlement_date, maturity_date, rate, price, redemption, frequency, [basis])
YIELDDISC(settlement_date, maturity_date, price, redemption, [basis])
YIELDMAT(settlement_date, maturity_date, issue_date, rate, price, [basis])

Information
CELL(info_type, [reference])
ERROR.TYPE(error_val)
INFO(type_text)
ISBLANK(value)
ISERR(value)
ISERROR(value)
ISEVEN(number)
ISFORMULA(reference)
ISLOGICAL(value)
ISNA(value)
ISNONTEXT(value)
ISNUMBER(value)
ISODD(number)
ISREF(value)
ISTEXT(value)
N(value)
NA()
SHEET([value])
SHEETS([reference])
TYPE(value)

Logical
AND(logical1, [logical2, ...])
FALSE()
IF(logical_test, [value_if_true], [value_if_false])
IFERROR(value, value_if_error)
IFNA(value, value_if_na)
IFS(logical1, [value_if_true1], [logical2, value_if_true2, ...])
NOT(logical)
OR(logical1, [logical2, ...])
SWITCH(expression, value1, result1, [default or value2, result2, ...])
TRUE()
XOR(logical1, [logical2, ...])

Lookup/reference
ADDRESS(row_num, column_num, [abs_num], [a1], [sheet_text])
AREAS(reference)
CHOOSE(index_num, value1, [value2, ...])
CHOOSECOLS(array, column_num1, [column_num2, ...])
CHOOSEROWS(array, row_num1, [row_num2, ...])
COLUMN([reference])
COLUMNS(range)
DROP(array, [rows], [columns])
EXPAND(array, [rows], [columns], [pad_with])
FILTER(array, include, [if_empty])
FORMULATEXT(reference)
HLOOKUP(lookup_value, table_range, row_index_num, [range_lookup])
HSTACK(array1, [array2, ...])
HYPERLINK(link_location, [friendly_name])
INDEX(reference, [row_num], [col_num], [area_num])
INDIRECT(ref_text, [a1])
LOOKUP(lookup_value, lookup_range, [result_range])
MATCH(lookup_value, lookup_range, [match_type])
OFFSET(reference, rows, cols, [height], [width])
ROW([reference])
ROWS(range)
SINGLE(value)
SORT(array, [sort_index], [sort_order], [by_col])
SORTBY(array, by_array1, [sort_order1], [by_array2, sort_order2, ...])
TAKE(array, [rows], [columns])
TOCOL(array, [ignore], [scan_by_col])
TOROW(array, [ignore], [scan_by_col])
TRANSPOSE(array)
UNIQUE(array, [by_col], [exactly_once])
VLOOKUP(lookup_value, table_range, col_index_num, [range_lookup])
VSTACK(array1, [array2, ...])
WRAPCOLS(array, wrap_count, [pad_with])
WRAPROWS(array, wrap_count, [pad_with])
XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])
XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])

Math/trigonometry
ABS(number)
ACOS(number)
ACOSH(number)
ACOT(number)
ACOTH(number)
AGGREGATE(function_num, [options], ref1, [ref2, ...])
ARABIC(text)
ASIN(number)
ASINH(number)
ATAN(number)
ATAN2(x_num,y_num)
ATANH(number)
BASE(number, radix, [min_length])
CEILING(number, significance)
CEILING.MATH(number, [significance], [mode])
CEILING.PRECISE(number, [significance])
COMBIN(number, number_chosen)
COS(number)
COSH(number)
COT(number)
COTH(number)
CSC(number)
CSCH(number)
DECIMAL(text, radix)
DEGREES(angle)
ECMA.CEILING(number, significance)
EVEN(number)
EXP(number)
FACT(number)
FACTDOUBLE(number)
FLOOR(number, significance)
FLOOR.MATH(number, [significance], [mode])
FLOOR.PRECISE(number, [significance])
GCD(number1, [number2, ...])
INT(number)
ISO.CEILING(number, [significance])
LCM(number1, [number2, ...])
LN(number)
LOG(number, [base])
LOG10(number)
MDETERM(range)
MINVERSE(array)
MMULT(array1, array2)
MOD(number, divisor)
MROUND(number, multiple)
MULTINOMIAL(number1, [number2, ...])
MUNIT(dimension)
ODD(number)
PI()
POWER(number, power)
PRODUCT(number1, [number2, ...])
QUOTIENT(numerator, denominator)
RADIANS(angle)
RAND()
RANDARRAY([rows], [columns], [min], [max], [whole_number])
RANDBETWEEN(smallest, largest)
ROMAN(number, [form])
ROUND(number, num_digits)
ROUNDDOWN(number, [num_digits])
ROUNDUP(number, [num_digits])
SEC(number)
SECH(number)
SEQUENCE(rows, [columns], [start], [step])
SERIESSUM(x, n, m, coefficients)
SIGN(number)
SIN(number)
SINH(number)
SQRT(number)
SQRTPI(number)
SUBTOTAL(function_num, ref1, [ref2, ...])
SUM(number1, [number2, ...])
SUMIF(range, criteria, [sum_range])
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2, ...])
SUMPRODUCT(range1, [range2, ...])
SUMSQ(number1, [number2, ...])
SUMX2MY2(x_range, y_range)
SUMX2PY2(x_range, y_range)
SUMXMY2(x_range, y_range)
TAN(number)
TANH(number)
TRUNC(number, [num_digits])

Statistical
AVEDEV(number1, [number2, ...])
AVERAGE(number1, [number2, ...])
AVERAGEA(number1, [number2, ...])
AVERAGEIF(range, criteria, [average_range])
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2, ...])
BETA.DIST(x, alpha, beta, cumulative, [A], [B])
BETA.INV(probability, alpha, beta, [A], [B])
BETADIST(x, alpha, beta, [A], [B])
BETAINV(probability, alpha, beta, [A], [B])
BINOM.DIST(number_successes, trials, probability, cumulative)
BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])
BINOM.INV(trials, probability_s, alpha)
BINOMDIST(number_successes, trials, probability, cumulative)
CHIDIST(x, degrees_freedom)
CHIINV(probability, degrees_freedom)
CHISQ.DIST(x, degrees_freedom, cumulative)
CHISQ.DIST.RT(x, degrees_freedom)
CHISQ.INV(probability, degrees_freedom)
CHISQ.INV.RT(probability, degrees_freedom)
CHISQ.TEST(actual_range, expected_range)
CHITEST(actual_range, expected_range)
CONFIDENCE(alpha, standard_deviation, size)
CONFIDENCE.NORM(alpha, standard_deviation, size)
CONFIDENCE.T(alpha, standard_deviation, size)
CORREL(range1, range2)
COUNT(value1, [value2, ...])
COUNTA(value1, [value2, ...])
COUNTBLANK(range)
COUNTIF(range, criteria)
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2, ...])
COVAR(range1, range2)
COVARIANCE.P(range1, range2)
COVARIANCE.S(range1, range2)
CRITBINOM(trials, probability_s, alpha)
DEVSQ(number1, [number2, ...])
EXPON.DIST(x, lambda, cumulative)
EXPONDIST(x, lambda, cumulative)
F.DIST(x, degrees_freedom1, degrees_freedom2, cumulative)
F.DIST.RT(x, degrees_freedom1, degrees_freedom2)
F.INV(probability, degrees_freedom1, degrees_freedom2)
F.INV.RT(probability, degrees_freedom1, degrees_freedom2)
F.TEST(array1, array2)
FDIST(x, degrees_freedom1, degrees_freedom2)
FINV(probability, degrees_freedom1, degrees_freedom2)
FISHER(x)
FISHERINV(y)
FORECAST(x, y_range, x_range)
FORECAST.LINEAR(x, known_ys, known_xs)
FREQUENCY(data_array, bins_array)
FTEST(range1, range2)
GAMMA(x)
GAMMA.DIST(x, alpha, beta, cumulative)
GAMMA.INV(probability, alpha, beta)
GAMMADIST(x, alpha, beta, cumulative)
GAMMAINV(probability, alpha, beta)
GAMMALN(x)
GAMMALN.PRECISE(x)
GAUSS(z)
GEOMEAN(number1, [number2, ...])
GROWTH(known_ys, [known_xs], [new_xs], [const])
HARMEAN(number1, [number2, ...])
HYPGEOM.DIST(sample_s, number_sample, population_s, number_population, cumulative)
HYPGEOMDIST(sample_s, number_sample, population_s, number_population)
INTERCEPT(y_range, x_range)
KURT(number1, [number2, ...])
LARGE(range,k)
LINEST(known_ys, [known_xs], [const], [stats])
LOGEST(known_ys, [known_xs], [const], [stats])
LOGINV(probability, mean, standard_dev)
LOGNORM.DIST(x, mean, standard_dev, cumulative)
LOGNORM.INV(probability, mean, standard_dev)
LOGNORMDIST(x, mean, standard_dev)
MAX(number1, [number2, ...])
MAXA(value1, [value2, ...])
MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2, ...])
MEDIAN(number1, [number2, ...])
MIN(number1, [number2, ...])
MINA(value1, [value2, ...])
MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2, ...])
MODE(number1, [number2, ...])
MODE.MULT(number1, [number2, ...])
MODE.SNGL(number1, [number2, ...])
NEGBINOM.DIST(number_f, number_s, probability_s, cumulative)
NEGBINOMDIST(number_f, number_s, probability_s)
NORM.DIST(x, mean, standard_dev, cumulative)
NORM.INV(probability, mean, standard_dev)
NORM.S.DIST(z,cumulative)
NORM.S.INV(probability)
NORMDIST(x, mean, standard_dev, cumulative)
NORMINV(probability, mean, standard_dev)
NORMSDIST(z)
NORMSINV(probability)
PEARSON(range1, range2)
PERCENTILE(range, k)
PERCENTILE.EXC(array, k)
PERCENTILE.INC(array, k)
PERCENTRANK(range, x, [significance])
PERCENTRANK.EXC(array, x, [significance])
PERCENTRANK.INC(array, x, [significance])
PERMUT(number, number_chosen)
PERMUTATIONA(number, number_chosen)
PHI(x)
POISSON(x, mean, cumulative)
POISSON.DIST(x, mean, cumulative)
PROB(x_range, prob_range, lower_limit, [upper_limit])
QUARTILE(range, quart)
QUARTILE.EXC(array, quart)
QUARTILE.INC(array, quart)
RANK(number, range, [order])
RANK.AVG(number, range, [order])
RANK.EQ(number, range, [order])
RSQ(y_range, x_range)
SKEW(number1, [number2, ...])
SKEW.P(number1, [number2, ...])
SLOPE(y_range, x_range)
SMALL(range, k)
STANDARDIZE(x, mean, standard_dev)
STDEV(number1, [number2, ...])
STDEV.P(number1, [number2, ...])
STDEV.S(number1, [number2, ...])
STDEVA(value1, [value2, ...])
STDEVP(number1, [number2, ...])
STDEVPA(value1, [value2, ...])
STEYX(y_range, x_range)
T.DIST(x, degrees_freedom, cumulative)
T.DIST.2T(x, degrees_freedom)
T.DIST.RT(x, degrees_freedom)
T.INV(probability, degrees_freedom)
T.INV.2T(probability, degrees_freedom)
T.TEST(array1, array2, tails, type)
TDIST(x, degrees_freedom, tails)
TINV(probability, degrees_freedom)
TREND(known_ys, [known_xs], [new_xs], [const])
TRIMMEAN(range, percent)
TTEST(range1, range2, tails, type)
VAR(number1, [number2, ...])
VAR.P(number1, [number2, ...])
VAR.S(number1, [number2, ...])
VARA(value1, [value2, ...])
VARP(number1, [number2, ...])
VARPA(value1, [value2, ...])
WEIBULL(x, alpha, beta, cumulative)
WEIBULL.DIST(x, alpha, beta, cumulative)
Z.TEST(array, x, [sigma])
ZTEST(range, x, [sigma])

Text
ARRAYTOTEXT(array, [format])
ASC(text)
BAHTTEXT(number)
CHAR(number)
CLEAN(text)
CODE(text)
CONCAT(text1, [text2, ...])
CONCATENATE(text1, [text2, ...])
DBCS(text)
DOLLAR(number, [decimals])
EXACT(text1, text2)
FIND(find_text, within_text, [start_num])
FINDB(find_text, within_text, [start_num])
FIXED(number, [decimals], [no_commas])
LEFT(text, [num_chars])
LEFTB(text, [num_bytes])
LEN(text)
LENB(text)
LOWER(text)
MID(text, start_num, num_chars)
MIDB(text, start_num, num_bytes)
NUMBERVALUE(text, [decimal_separator], [group_separator])
PROPER(text)
REPLACE(old_text, start_num, num_chars, new_text)
REPLACEB(old_text, start_num, num_bytes, new_text)
REPT(text, number_times)
RIGHT(text, [num_chars])
RIGHTB(text, [num_bytes])
SEARCH(find_text, within_text, [start_num])
SEARCHB(find_text, within_text, [start_num])
SUBSTITUTE(text, old_text, new_text, [instance_num])
T(value)
TEXT(value, format_text)
TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])
TEXTBEFORE(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])
TEXTJOIN(delimiter, ignore_empty, text1, [text2, ...])
TEXTSPLIT(input_text, [col_delimiter], [row_delimiter], [include_empty])
TRIM(text)
UNICHAR(number)
UNICODE(text)
UPPER(text)
USDOLLAR(number, [decimals])
VALUE(text)
VALUETOTEXT(value, [format])

Macro control
ARGUMENT([name], [type], [reference])
BREAK()
ELSE()
ELSE.IF(logical_test)
END.IF()
FOR(counter_text, start_num, end_num, [step_num])
FOR.CELL(ref_name, [area­_ref], [skip_blanks])
GOTO(reference)
HALT([cancel_close])
IF(logical_test)
NEXT()
RESTART([level_num])
RESULT([type_num])
RETURN([value])
SET.NAME(name, [value])
SET.VALUE(reference, values)
VOLATILE([logical])
WAIT([serial_number])
WHILE(logical_test)

Macro command
ABSREF(ref_text, reference)
ACTIVATE([window_text], [pane_num])
ACTIVATE.NEXT([workbook_text])
ACTIVATE.PREV([workbook_text])
ACTIVE.CELL()
ALERT(message_text, [type_num], [help_ref])
ALIGNMENT([horiz_align], [wrap], [vert_align], [orientation], [add_indent])
APP.MAXIMIZE()
APP.MINIMIZE()
APP.MOVE([x_num], [y_num])
APP.MOVE?([x_num], [y_num])
APP.RESTORE()
APP.SIZE([x_num], [y_num])
APP.SIZE?([x_num], [y_num])
APP.TITLE([text])
ASSIGN.TO.OBJECT([macro_ref])
ATTACH.TEXT(attach_to_num, [series_num], [point_num])
AXES([x_primary], [y_primary], [x_secondary], [y_secondary])
BEEP([tone_num])
BORDER([outline], [left], [right], [top], [bottom], [shade], [outline_color], [left-color], [right_color], [top_color], [bottom_color])
BRING.TO.FRONT()
CALCULATE.DOCUMENT()
CALCULATE.NOW()
CALCULATION([type_num], [iter], [max_num], [max_change], [update], [precision], [date_1904], [calc_save], [save_values], [alt_exp], [alt_form])
CALLER()
CANCEL.COPY()
CANCEL.KEY(enable_logical, [macro_ref])
CELL.PROTECTION([locked], [hidden])
CHECKBOX.PROPERTIES([value], [link], [accel_text], [3d_shading], [accel_text2])
CLEAR([type_num])
CLEAR?([type_num])
COLOR.PALETTE(file_text)
COLUMN.WIDTH([width_num], [reference], [standard], [type_num], [standard_num])
COPY([from_reference], [to_reference])
COPY.CHART([size_num])
CREATE.NAMES([top], [left], [bottom], [right])
CREATE.NAMES?([top], [left], [bottom], [right])
CREATE.OBJECT(obj_type, ref1, [x_offset1], [y_offset1], ref2, [x_offset2], [y_offset2], [text], [fill], [editable])
CREATE.OBJECT(obj_type, ref1, [x_offset1], [y_offset1], ref2, [x_offset2], [y_offset2], array, [fill])
CUT([from_reference], [to_reference])
DATA.FORM()
DATA.LABEL([show_option], [auto_text], [show_key])
DATA.SERIES([rowcol], [type_num], [date_num], [step_value], [stop_value], [trend])
DEFINE.NAME(name_text, [refers_to], [macro_type], [shortcut_text], [hidden], [category], [local])
DELETE.FORMAT(format_text)
DELETE.NAME(name_text)
DEREF(reference)
DIRECTORY([path_text])
DOCUMENTS([type_num], [match_text])
DUPLICATE()
ECHO([logical])
EDIT.COLOR(color_num, [red_value], [green_value], [blue_value])
EDIT.DELETE([shift_num])
EDIT.DELETE?([shift_num])
EDIT.SERIES([series_num], [name_ref], [x_ref], [y_ref], [z_ref], [plot_order])
ENABLE.OBJECT([object_id], [enable_logical])
ERROR(enable_logical, [macro_ref])
EVALUATE(formula_text)
EXEC(program_text, [window_num])
EXTEND.POLYGON(array)
EXTRACT([unique])
EXTRACT?([unique])
FCLOSE(file_num)
FILE.CLOSE([save_logical], [route_logical])
FILE.DELETE(file_text)
FILES([directory_text])
FILL.DOWN()
FILL.LEFT()
FILL.RIGHT()
FILL.UP()
FILTER([field_num], [criteria1], [operation], [criteria2])
FILTER?([field_num], [criteria1], [operation], [criteria2])
FILTER.ADVANCED(operation, list_ref, [criteria_ref], [copy_ref], [unique])
FILTER.ADVANCED?([operation], [list_ref], [criteria_ref], [copy_ref], [unique]) FILTER.SHOW.ALL()
FIND.FILE?()
FONT.PROPERTIES([font], [font_style], [size], [strikethrough], [superscript],[subscript], [outline], [shadow], [underline], [color], [normal], [background], [start_char], [char_count])
FOPEN(file_text, [access_num])
FORMAT.LEGEND(position_num)
FORMAT.MOVE([x_offset], [y_offset], [reference])
FORMAT.NUMBER(format_text)
FORMAT.SHAPE(vertex_num, insert, [reference], [x_offset], [y_offset])
FORMAT.TEXT([x_align], [y_align], [orient_num], [auto_text], [auto_size], [show_key], [show_value], [add_indent])
FORMULA(formula_text, [reference])
FORMULA.ARRAY(formula_text, [reference])
FORMULA.CONVERT(formula_text, from_a1, [to_a1], [to_ref_type], [rel_to_ref])
FORMULA.FILL(formula_text, [reference])
FORMULA.FIND(text, in_num, at_num, by_num, [dir_num], [match_case])
FORMULA.FIND.NEXT()
FORMULA.FIND.PREV()
FORMULA.GOTO([reference], [corner])
FORMULA.REPLACE(find_text, replace_text, [look_at], [look_by], [active_cell], [match_case])
FPOS(file_num, [position_num])
FREAD(file_num, num_chars)
FREADLN(file_num)
FREEZE.PANES([logical], [col_split], [row_split])
FSIZE(file_num)
FULL.SCREEN(logical)
FWRITE(file_num, text)
FWRITELN(file_num, text)
GALLERY.AREA(type_num, [delete_overlay])
GALLERY.BAR(type_num, [delete_overlay])
GALLERY.COLUMN(type_num, [delete_overlay])
GALLERY.DOUGHNUT(type_num, [delete_overlay])
GALLERY.LINE(type_num, [delete_overlay])
GALLERY.PIE(type_num, [delete_overlay])
GALLERY.RADAR(type_num, [delete_overlay])
GALLERY.SCATTER(type_num, [delete_overlay])
GET.CELL(type_num, [reference])
GET.DOCUMENT(type_num, [name_text])
GET.FORMULA(reference)
GET.NAME(name_text, [info_type])
GET.NOTE([cell_ref], [start_char], [num_chars])
GET.OBJECT(type_num, [object_id], [start_num], [count_num], [item_index])
GET.WINDOW(type_num, [window_text])
GET.WORKBOOK(type_num, [name_text])
GET.WORKSPACE(type_num)
GOAL.SEEK(target_cell, target_value, variable_cell)
GOAL.SEEK?([target_cell], [target_value], [variable_cell])
GRIDLINES([x_major], [x_minor], [y_major], [y_minor], [z_major], [z_minor], [2D_effect])
HIDE()
HIDE.OBJECT(object_id, hide)
HLINE([num_columns])
HPAGE([num_windows])
HSCROLL(position, [col_logical])
INPUT(message_text, [type_num], [title_text], [default], [x_pos], [y_pos], [help_ref])
INSERT([shift_num])
INSERT?([shift_num])
INSERT.PICTURE([file_name],[filter_number])
INSERT.PICTURE?([file_name],[filter_number])
INSERT.TITLE([chart], [y_primary], [x_primary], [y_secondary], [x_secondary])
JUSTIFY()
LABEL.PROPERTIES([accel_text], [accel_text2], [3d_shading])
LEGEND([logical])
LIST.NAMES()
LISTBOX.PROPERTIES([range], [link], [drop_size], [multi_select], [3d_shading])
MESSAGE(logical, [text])
NAMES(document_text, type_num, match_text)
NEW([type_num], [xy_series], [add_logical])
NOTE([add_text], [cell_ref], [start_char], [num_chars])
OBJECT.PROPERTIES([placement_type], [print_object])
ON.DOUBLECLICK([sheet_text], [macro_text])
ON.ENTRY([sheet_text], [macro_text])
ON.SHEET([sheet_text], [macro_text], [activate_logical])
OPEN(file_text, [update_links], [read_only], [format], [prot_pwd], [write_res_pwd], [ignore_rorec], [file_origin], [custom_delimit], [add_logical], [editable], [file_access], [notify_logical], [converter])
OPEN.DIALOG([file_filter], [button_text], [title], [filter_index])
OPTIONS.CALCULATION([type_num], [iter], [max_num], [max_change], [update], [precision], [date_1904], [calc_save], [save_values])
OPTIONS.EDIT([incell_edit], [drag_drop], [alert], [entermove], [fixed], [decimals], [copy_objects], [update_links], [move_direction], [autocomplete], [animations])
OPTIONS.GENERAL([R1C1_mode], [dde_on], [sum_info], [tips], [recent_files], [old_menus], [user_info], [font_name], [font_size], [default_location], [alternate_location], [sheet_num], [enable_under])
OPTIONS.VIEW([formula], [status], [notes], [show_info], [object_num], [page_breaks], [formulas], [gridlines], [color_num], [headings], [outline], [zeros], [hor_scroll], [vert_scroll], [sheet_tabs])
PAGE.SETUP([head], [foot], [left], [right], [top], [bot], [hdng], [grid], [h_cntr], [v_cntr], [orient], [paper_size], [scale], [pg_num], [pg_order], [bw_cells], [quality], [head_margin], [foot_margin], [notes], [draft])
PAGE.SETUP?([head], [foot], [left], [right], [top], [bot], [hdng], [grid], [h_cntr], [v_cntr], [orient], [paper_size], [scale], [pg_num], [pg_order], [bw_cells], [quality], [head_margin], [foot_margin], [notes], [draft])
PAGE.SETUP([head], [foot], [left], [right], [top], [bot], [size], [h_cntr], [v_cntr], [orient], [paper_size], [scale], [pg_num], [bw_chart], [quality], [head_margin], [foot_margin], [draft])
PAGE.SETUP?([head], [foot], [left], [right], [top], [bot], [size], [h_cntr], [v_cntr], [orient], [paper_size], [scale], [pg_num], [bw_chart], [quality], [head_margin], [foot_margin], [draft])
PASTE([to_reference])
PASTE.SPECIAL([paste_num], [operation_num], [skip_blanks], [transpose])
PATTERNS([apattern], [afore], [aback])
PATTERNS([lauto], [lstyle], [lcolor], [lwt], [hwidth], [hlength], [htype])
PATTERNS([bauto], [bstyle], [bcolor], [bwt], [shadow], [aauto], [apattern], [afore], [aback], [rounded], [newui])
PATTERNS([bauto], [bstyle], [bcolor], [bwt], [shadow], [aauto], [apattern], [afore], [aback], [invert], [apply], [new_fill])
PATTERNS([lauto], [lstyle], [lcolor], [lwt], [tmajor], [tminor], [tlabel])
PATTERNS([lauto], [lstyle], [lcolor], [lwt], [apply], [smooth])
PATTERNS([lauto], [lstyle], [lcolor], [lwt], [mauto], [mstyle], [mfore], [mback], [apply], [smooth])
PROTECT.DOCUMENT([contents], [windows], [password], [objects], [scenarios])
QUIT()
REFTEXT(reference, [a1])
RELREF(reference, rel_to_ref)
RENAME.OBJECT([new_name])
ROW.HEIGHT([height_num], [reference], [standard_height], [type_num])
SAVE()
SAVE.AS([document_text], [type_num], [prot_pwd], [backup], [write_res_pwd], [read_only_rec])
SAVE.AS?([document_text], [type_num], [prot_pwd], [backup], [write_res_pwd], [read_only_rec])
SAVE.COPY.AS([document_text])
SAVE.DIALOG([init_filename], [title], [button_text], [file_filter], [filter_index])
SCALE([min_num], [max_num], [major], [minor], [cross], [logarithmic], [reverse], [max])
SCROLLBAR.PROPERTIES([value], [min], [max], [inc], [page], [link], [3d_shading])
SELECT([selection], [active_cell])
SELECT([object_id], [replace])
SELECT([item_text], [single_point])
SELECT.CHART()
SELECT.END(direction_num)
SELECT.LAST.CELL()
SELECT.PLOT.AREA()
SELECTION()
SEND.TO.BACK()
SET.CONTROL.VALUE([value])
SET.CRITERIA()
SET.DATABASE()
SET.EXTRACT()
SET.PRINT.AREA([range])
SET.PRINT.TITLES([titles_for_cols_ref], [titles_for_rows_ref])
SET.PRINT.TITLES?([titles_for_cols_ref], [titles_for_rows_ref])
SHOW.ACTIVE.CELL()
SORT([orientation], [key1], [order1], [key2], [order2], [key3], [order3], [header], [custom], [case])
STANDARD.WIDTH(standard_num)
SUMMARY.INFO([title], [subject], [author], [keywords], [comments])
SUMMARY.INFO?([title], [subject], [author], [keywords], [comments])
TEXT.BOX(add_text, [object_id], [start_num], [num_chars])
TEXT.TO.COLUMNS([destination_ref], [data_type], [text_delim], [consecutive_delim], [tab], [semicolon], [comma], [space], [other], [other_char], [field_info])
TEXTREF(text, [a1])
UNDO()
UNHIDE([window_text])
UNLOCKED.NEXT()
UNLOCKED.PREV()
VLINE([num_rows])
VPAGE([num_windows])
VSCROLL(position, [row_logical])
WORKBOOK.ACTIVATE(sheet_name)
WORKBOOK.DELETE([sheet_name])
WORKBOOK.HIDE([sheet_text], [very_hidden])
WORKBOOK.INSERT([type_num])
WORKBOOK.NAME(old_sheet_name, new_sheet_name)
WORKBOOK.NAME?([old_sheet_name], [new_sheet_name])
WORKBOOK.NEXT()
WORKBOOK.PREV()
WORKBOOK.UNHIDE([sheet_text])
ZOOM([magnification])

DDE and External
CALL(module_text, procedure, type_text, [argument1, ...])

Web
ENCODEURL(text)
FILTERXML(xml, xpath)
WEBSERVICE(url)