Note: In this summary, tableName or viewName are used as parameter factors. When the function is called, it searches first from the private data source, and then from the public data source.

CLASS

CLASS(object): Returns the class to which the object object belongs.

CNMONEY

CNMONEY(number,unit) returns RMB in uppercase.

number: The numeric number that needs to be converted.

unit: unit, "s", "b", "q", "w", "sw", "bw", "qw", "y", "sy", "by", "qy" and "wy" respectively represent "Shi", "Hundred", "Qian", "Wan", "Shiwan", "Hundred million", "Qianwan", "Yi", "ShiYi", " "One hundred billion", "thousands of billions", "trillions".

Remarks:

The unit can be empty. If it is empty, directly convert the number into uppercase RMB. Otherwise, first multiply the number by the base of the unit, and then multiply the The results are converted to RMB capital letters.

Example:

CNMONEY(1200) is equal to one thousand two hundred round.

CNMONEY(12.5,"w") is equal to one hundred and twenty thousand five thousand round.

CNMONEY(56.3478, "bw") is equal to five thousand six hundred and thirty four thousand seven thousand eight hundred round.

CNMONEY(3.4567, "y") is equal to 340,000,500,000 yuan.

COL

COL() returns the column number of the current cell.

Example:

If the current cell is A5, writing "=col()" in A5 will return 1.

If the current cell is C6, writing "=col()" in C6 will return 3.

COLCOUNT

COLCOUNT(tableData): Returns the number of columns in tableData.

tableData: The name of tableData, in string form.

Remarks:

First search from the private data source, and then search from the public data source. What is returned is the number of columns in the first found tableData.

Example:

Take the data source FRDemo we provide as an example

COLCOUNT("Check") is equal to 6.

COLCOUNT("country") is equal to 5.

COLNAME

COLNAME(tableData,colIndex) returns the column name of the column number colIndex in tableData.

tableData: represents the name of TableData, in string form.

colIndex: represents the column number.

Note:

TableData first searches from private data sources, and then from public data sources.

Example:

COLNAME("Check", 3) equals AcceName.

COLNAME("country", 4) is equal to Area.

EVAL

EVAL(exp): Returns the calculated result of expression exp.

exp: an expression string.

Remarks:

As long as the parameter exp in EVAL can eventually be converted into a string in the form of an expression, such as "sum(2,4)", "2 7", etc., then it can be calculated.

Example:

EVAL("2 5") is equal to 7.

EVAL("count(2,3)") is equal to 2.

EVAL("sum" "(2,3,5)") is equal to 10.

EVAL(IF(true,"sum", "count") "(1,2,3,4)") is equal to 10.

EVAL(IF(false,"sum", "count") "(1,2,3,4)") is equal to 4.

FIELDS

FIELDS(connectionName, tableName): Returns all field names in the table tableName.

Example:

There is a table named task in database BASE with the following content:

namestart end

a2008 2009

b2009 2012

Then FIELDS("BASE","task") is equal to [name,start,end].

FORMAT

FORMAT(object ,format): Returns the format of object.

object: The object that needs to be formatted can be String, number, Object (commonly used are Date, Time).

format: formatting style.

Remarks:

The uppercase and lowercase letters in the format here must strictly follow the rules in the above example, month: uppercase MM, year lowercase: yyyy or yy, day: lowercase dd.

The format of the parameter factor here can be quoted with ' ' or " ".

Example:

Format(TODAY(),'yyyy-MM-dd') The result is 2008-11-01

INMAP

INMAP(key, value, mapName): Determine whether the data dictionary mapName contains a data pair with the key value being key and the value being value. The return value is Boolean. TRUE is returned, FALSE is not returned.

key: detected key.

value: detected value.

mapName: The specified data dictionary name.

Note:

mapName must be of type String.

Example:

INMAP(1,2, "customerdic") returns Boolean.TRUE (Boolean).

ISNULL

ISNULL(object): Determine whether all values ??in the object are Primitive.NULL.

MAP

MAP(key,mapName): Returns the value corresponding to the key in the data dictionary named mapName.

key: The key in the data dictionary corresponding to the return value.

mapName: The specified data dictionary name. Note that the data dictionary name must be enclosed in quotation marks

Example:

MAP(1,"customername") equals "Yixing HongdaFood Co.".

RECORDS

RECORDS(connection, table, field): Returns all elements under the field name field in the database table table.

Example:

There is a table named task in database BASE with the following content:

namestart end

a2008 2009

b2009 2012

Then RECORDS("BASE","task","end") is equal to [2009,2012].

RECORDS(connection, table, field, row) returns the field in the table The record in row row under the field. Field can be a column name or a column number.

RECORDS("BASE","task","end",2) is equal to 2012.

RECORDS("BASE","task",2,2) is equal to 2009.

REVERSE

REVERSE(value): Returns the logical value opposite to value.

Example:

REVERSE(true) equals false.

ROW

ROW() returns the row number of the current cell

Example:

If the current cell is A5, Writing "=ROW()" in A5 returns 5.

If the current cell is B8, writing "=ROW()" in B8 will return 8.

ROWCOUNT

ROWCOUNT(tableData) returns the number of rows in tableData.

tableData: The name of TableData, in string form.

Note:

First search from the private data source, and then search from the public data source. The number of rows in tableData is returned.

Example:

Take the data source FRDemo we provide as an example

ROWCOUNT("Check") is equal to 3.

ROWCOUNT("country") is equal to 18.

TABLEDATAFIELDS

TABLEDATAFIELDS(tableData): Returns all field names in tableData.

Note:

First search from the report data set, and then search from the server data set. What is returned is an array composed of the column names of tableData.

Example:

TABLEDATAFIELDS("Country") equals [name, capital, continent, area, population

TABLEDATES

TABLEDATAS(): Returns the report data set and server data set names. ]

Example:

The server data set has: ds1, ds2, ds3; the report data set has dsr1, dsr2.

TABLEDATAS() is equal to [dsr1, dsr2, ds1 ,ds2,ds3].

And TABLEDATAS(0) returns the server data set name; TABLEDATAS(1) returns the report data set name;

TABLEDATAS(0) is equal to [ds1,ds2,ds3 ];TABLEDATAS(1) equals [dsr1,dsr2].

TABLES

TABLEAS(connectionName): Returns all table names in the database named connectionName.

Example:

Assume that in the FRDemo database, there are 3 tables: a, b, c;

Then TABLES("FRDemo") is equal to [a,b ,c].

VALUE

VALUE(tableData, row,col) returns the value of row number and column number col in tableData.

tableData: The name of tableData, in string form.

row: row number.

col: column number.

Note:

First search from the private data source, and then search from the public data source. What is returned is the qualified value of tableData.

Example:

VALUE("country", 5, 3) equals South America.

VALUE("Simple", 8, 3) equals jonnason.