| 类 | 说明 |
|---|---|
| ABS |
ABS Function.
|
| ACOS |
Function.
|
| ACOSH |
ACOSH Function.
|
| ADD2ARRAY | |
| AND |
Function.
|
| ARRAY | |
| ASIN |
ASIN Function.
|
| ASINH |
ASIN Function.
|
| ATAN |
Function.
|
| ATAN2 |
Function.
|
| ATANH |
ATANH Function.
|
| AVERAGE |
AVERAGE Function.
|
| BITNOT | |
| BITOPERATION | |
| CEILING |
Function.
|
| CHAR |
CHAR.
|
| CIRCULAR | |
| CLASS |
Return the class of parameter
|
| CNMONEY |
Number to chinese money.
|
| CODE |
Function.
|
| COL | |
| COLCOUNT | |
| COLNAME | |
| COMBIN |
Function.
|
| CONCATENATE |
Function.
|
| CORREL |
CORREL Function.
|
| COS |
Function.
|
| COSH |
Function.
|
| COUNT |
COUNT.
|
| CROSSLAYERTOTAL | |
| DATE |
DATE.
|
| DATEDELTA | |
| DATEDIF |
Function.
|
| DateFinder | |
| DATEINMONTH | |
| DATEINQUARTER | |
| DATEINWEEK | |
| DATEINYEAR | |
| DATESUBDATE |
ABS Function.
|
| DATETIME |
Function.
|
| DATETONUMBER |
Convert date to number. date.getTime();
|
| DAY |
Function.
|
| DAYS360 |
Function.
|
| DAYSOFMONTH | |
| DAYSOFQUARTER | |
| DAYSOFYEAR | |
| DAYVALUE |
Function.
|
| DECIMAL | |
| DECODE | |
| DEGREES |
Function.
|
| ENCODE | |
| ENDWITH | |
| ENMONEY | |
| ENNUMBER | |
| EVAL | |
| EVEN |
Function.
|
| EvenOdd | |
| EXACT |
Function.
|
| EXP |
Function.
|
| FACT |
Function.
|
| FIELDS | |
| FILENAME | |
| FILESIZE |
Author : Shockway
Date: 13-10-9
Time: 下午4:41
|
| FILETYPE |
Author : Shockway
Date: 13-10-9
Time: 下午4:41
|
| FIND |
Function.
|
| FLOOR |
Function.
|
| FORMAT |
Format
|
| GETUSERDEPARTMENTS | |
| GETUSERJOBTITLES |
公式：返回角色的所有职务
|
| GREPARRAY | |
| HIERARCHY | |
| HOUR |
Function.
|
| I18N | |
| IF |
IF Function.
|
| INARRAY | |
| INDEX | |
| INDEXOF | |
| INDEXOFARRAY | |
| INT |
Function.
|
| ISNULL | |
| JOINARRAY | |
| JVM | |
| LambdaFunction |
这个类表示在计算的时候延迟执行
例如：grepArray([1,2,3,4,5], item == 4)是一个实现数组过滤的函数，其中item为grepArray()函数的内置参数，表示遍历时的当前的元素
执行顺序为：先执行grepArray()函数，遍历该函数的第一个参数所表示的数组，
再把遍历时当前的元素item和4比较并返回一个布尔值，
如果是true则保留该元素，false则不保留该元素。
|
| LAYERTOTAL | |
| LEFT |
Function.
|
| LEN |
Function.
|
| LET | |
| LN |
Function.
|
| LOG |
LOG Function.
|
| LOG10 |
Function.
|
| LOWER |
Function.
|
| LUNAR |
LUNAR Function.
|
| MAP | |
| MAPARRAY | |
| MAX |
Function.
|
| MEDIAN |
CORREL Function.
|
| MID |
Function.
|
| MIN |
Function.
|
| MinAndMaxAndSUM | |
| MINUTE |
Function.
|
| MOD |
Function.
|
| MOM | |
| MONTH |
Function.
|
| MONTHDELTA | |
| NOW |
返回当前时间, yy-MM-dd hh:mm:ss格式
|
| NUMTO |
natural number converts to Chinese.
|
| NVL | |
| ODD |
Function.
|
| OR | |
| PI |
Function.
|
| POWER |
Function.
|
| PRODUCT |
Function.
|
| PROMOTION | |
| PROPER |
Function.
|
| PROPORTION | |
| QUERY | |
| RADIANS |
Function.
|
| RAND |
Function.
|
| RANDBETWEEN |
Function.
|
| RANGE | |
| RANK | |
| RECORDS | |
| REGEXP | |
| REMOVEARRAY | |
| REPEAT |
Function.
|
| REPLACE |
Function.
|
| REVERSE | |
| REVERSEARRAY | |
| RIGHT |
Function.
|
| ROUND |
Function.
|
| ROUND5 |
Function.
|
| ROUNDDOWN |
Function.
|
| ROUNDUP |
Function.
|
| ROW | |
| ROWCOUNT | |
| SECOND |
Function.
|
| SEQ | |
| SIGN |
Function.
|
| SIN |
Function.
|
| SINH |
Function.
|
| SLICEARRAY | |
| SORT | |
| SORTARRAY | |
| SPLIT | |
| SQL | |
| SQRT |
Function.
|
| STARTWITH | |
| STDEV |
CORREL Function.
|
| SUBSTITUTE |
Function.
|
| SUM |
Function.
|
| SummaryFunction | |
| SUMSQ |
Function.
|
| SWITCH | |
| TABLEDATAFIELDS | |
| TABLEDATAS | |
| TABLES | |
| TAN |
TAN Function.
|
| TANH |
Function.
|
| TIME |
Function.
|
| TOBIGDECIMAL | |
| TOBINARY |
Convert String to integer.
|
| TODATE |
Format
|
| TODAY |
TODAY函数, 返回当前日期, 如2012/12/21
|
| TODOUBLE |
Convert String to double.
|
| TOHEX |
Convert String to integer.
|
| TOIMAGE |
ToImage函数, 返回用户指定路径的图片.
|
| TOINTEGER |
Convert String to integer.
|
| TOOCTAL |
Convert String to integer.
|
| TOTEXT |
反射 读取build.properties 方便OEM集成
|
| TREELAYER | |
| TRIM |
Function.
|
| TRUNC |
Function.
|
| UNIQUEARRAY | |
| UPPER |
Function.
|
| UUID | |
| VALUE | |
| WEBIMAGE |
web图片用此函数计算
|
| WEEK |
Function.
|
| WEEKDATE | |
| WEEKDAY |
Function.
|
| WEIGHTEDAVERAGE | |
| YEAR |
Function.
|
| YEARDELTA |