


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.

HTML code can be cleaner with online validators, integrated tools and automated processes. 1) Use W3CMarkupValidationService to verify HTML code online. 2) Install and configure HTMLHint extension in VisualStudioCode for real-time verification. 3) Use HTMLTidy to automatically verify and clean HTML files in the construction process.

HTML, CSS and JavaScript are the core technologies for building modern web pages: 1. HTML defines the web page structure, 2. CSS is responsible for the appearance of the web page, 3. JavaScript provides web page dynamics and interactivity, and they work together to create a website with a good user experience.

The function of HTML is to define the structure and content of a web page, and its purpose is to provide a standardized way to display information. 1) HTML organizes various parts of the web page through tags and attributes, such as titles and paragraphs. 2) It supports the separation of content and performance and improves maintenance efficiency. 3) HTML is extensible, allowing custom tags to enhance SEO.

The future trends of HTML are semantics and web components, the future trends of CSS are CSS-in-JS and CSSHoudini, and the future trends of JavaScript are WebAssembly and Serverless. 1. HTML semantics improve accessibility and SEO effects, and Web components improve development efficiency, but attention should be paid to browser compatibility. 2. CSS-in-JS enhances style management flexibility but may increase file size. CSSHoudini allows direct operation of CSS rendering. 3.WebAssembly optimizes browser application performance but has a steep learning curve, and Serverless simplifies development but requires optimization of cold start problems.

The roles of HTML, CSS and JavaScript in web development are: 1. HTML defines the web page structure, 2. CSS controls the web page style, and 3. JavaScript adds dynamic behavior. Together, they build the framework, aesthetics and interactivity of modern websites.

The future of HTML is full of infinite possibilities. 1) New features and standards will include more semantic tags and the popularity of WebComponents. 2) The web design trend will continue to develop towards responsive and accessible design. 3) Performance optimization will improve the user experience through responsive image loading and lazy loading technologies.

The roles of HTML, CSS and JavaScript in web development are: HTML is responsible for content structure, CSS is responsible for style, and JavaScript is responsible for dynamic behavior. 1. HTML defines the web page structure and content through tags to ensure semantics. 2. CSS controls the web page style through selectors and attributes to make it beautiful and easy to read. 3. JavaScript controls web page behavior through scripts to achieve dynamic and interactive functions.

HTMLisnotaprogramminglanguage;itisamarkuplanguage.1)HTMLstructuresandformatswebcontentusingtags.2)ItworkswithCSSforstylingandJavaScriptforinteractivity,enhancingwebdevelopment.


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

Atom editor mac version download
The most popular open source editor

MinGW - Minimalist GNU for Windows
This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

Zend Studio 13.0.1
Powerful PHP integrated development environment

WebStorm Mac version
Useful JavaScript development tools
