Supported Formula Functions"
(→Statistical: correct OSE supported function) |
(→Text: correct OSE supported function) |
||
Line 1,841: | Line 1,841: | ||
|- | |- | ||
− | | | + | | CHAR |
− | CHAR | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | CLEAN |
− | CLEAN | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | CODE |
− | CODE | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | CONCATENATE |
− | CONCATENATE | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | DOLLAR |
− | DOLLAR | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | EXACT |
− | EXACT | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | FIND |
− | FIND | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | FIXED |
− | FIXED | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | LEFT |
− | LEFT | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | LEN |
− | LEN | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | LOWER |
− | LOWER | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | MID |
− | MID | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | PROPER |
− | PROPER | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | REPLACE |
− | REPLACE | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | REPT |
− | REPT | + | | <center></center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | RIGHT |
− | RIGHT | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | SEARCH |
− | SEARCH | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | SUBSTITUTE |
− | SUBSTITUTE | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center></center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | T |
− | T | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | TEXT |
− | TEXT | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | TRIM |
− | TRIM | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | UPPER |
− | UPPER | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|- | |- | ||
− | | | + | | VALUE |
− | VALUE | + | | <center>Y</center> |
− | + | | <center>Y</center> | |
− | | | ||
− | <center>Y</center> | ||
− | |||
− | | | ||
− | <center>Y</center> | ||
− | |||
|} | |} | ||
* For current open issues that supported functions have, please refer to [http://tracker.zkoss.org/secure/IssueNavigator.jspa?mode=hide&requestId=12600 our tracker]. | * For current open issues that supported functions have, please refer to [http://tracker.zkoss.org/secure/IssueNavigator.jspa?mode=hide&requestId=12600 our tracker]. |
Revision as of 02:04, 9 January 2014
Here we list all ZK Spreadsheet supported functions in OSE and EE:
Date & Time
Function | OSE | EE |
---|---|---|
DATE | ||
DATEVALUE | ||
DAY | ||
DAYS360 | ||
HOUR | ||
MINUTE | ||
MONTH | ||
NETWORKDAYS | ||
NOW | ||
SECOND | ||
TIME | ||
TODAY | ||
WEEKDAY | ||
WORKDAY | ||
YEAR | ||
YEARFRAC |
Engineering
Function | OSE | EE |
---|---|---|
BESSELI |
|
|
BESSELJ |
|
|
BESSELK |
|
|
BESSELY |
|
|
BIN2DEC |
|
|
BIN2HEX |
|
|
BIN2OCT |
|
|
COMPLEX |
|
|
DEC2BIN |
|
|
DEC2HEX |
|
|
DEC2OCT |
|
|
DELTA |
|
|
ERF |
|
|
ERFC |
|
|
GESTEP |
|
|
HEX2BIN |
|
|
HEX2DEC |
|
|
HEX2OCT |
|
|
IMABS |
|
|
IMAGINARY |
|
|
IMARGUMENT |
|
|
IMCONJUGATE |
|
|
IMCOS |
|
|
IMDIV |
|
|
IMEXP |
|
|
IMLN |
|
|
IMLOG10 |
|
|
IMLOG2 |
|
|
IMPOWER |
|
|
IMPRODUCT |
|
|
IMREAL |
|
|
IMSIN |
|
|
IMSQRT |
|
|
IMSUB |
|
|
IMSUM |
|
|
OCT2BIN |
|
|
OCT2DEC |
|
|
OCT2HEX |
|
|
Financial
Function | OSE | EE |
---|---|---|
ACCRINT | ||
ACCRINTM | ||
AMORDEGRC | ||
AMORLINC | ||
COUPDAYBS | ||
COUPDAYS | ||
COUPDAYSNC | ||
COUPNCD | ||
COUPNUM | ||
COUPPCD | ||
CUMIPMT | ||
CUMPRINC | ||
DB | ||
DDB | ||
DISC | ||
DOLLARDE | ||
DOLLARFR | ||
DURATION | ||
EFFECT | ||
FV | ||
FVSCHEDULE | ||
INTRATE | ||
IPMT | ||
IRR | ||
NOMINAL | ||
NPER | ||
NPV | ||
PMT | ||
PPMT | ||
PRICE | ||
PRICEDISC | ||
PRICEMAT | ||
PV | ||
RATE | ||
RECEIVED | ||
SLN | ||
SYD | ||
TBILLEQ | ||
TBILLPRICE | ||
TBILLYIELD | ||
XNPV | ||
YIELD | ||
YIELDDISC | ||
YIELDMAT |
Info
Function | OSE | EE |
---|---|---|
ERROR.TYPE |
|
|
ISBLANK |
|
|
ISERR |
|
|
ISERROR |
|
|
ISEVEN |
|
|
ISLOGICAL |
|
|
ISNA |
|
|
ISNONTEXT |
|
|
ISNUMBER |
|
|
ISODD |
|
|
ISREF |
|
|
ISTEXT |
|
|
N |
|
|
NA |
|
|
TYPE |
|
|
Logical
Function | OSE | EE |
---|---|---|
AND |
|
|
FALSE |
|
|
IF |
|
|
IFERROR |
|
|
NOT |
|
|
OR |
|
|
TRUE |
|
|
Lookup & Reference
Function | OSE | EE |
---|---|---|
ADDRESS |
|
|
CHOOSE |
|
|
COLUMN |
|
|
COLUMNS |
|
|
HLOOKUP |
|
|
HYPERLINK |
|
|
INDEX |
|
|
INDIRECT |
|
|
LOOKUP |
|
|
MATCH |
|
|
OFFSET |
|
|
ROW |
|
|
ROWS |
|
|
VLOOKUP |
|
|
Mathematical
Function | OSE | EE |
---|---|---|
ABS |
|
|
ACOS |
|
|
ACOSH |
|
|
ASIN |
|
|
ASINH |
|
|
ATAN |
|
|
ATAN2 |
|
|
ATANH |
|
|
CEILING |
|
|
COMBIN |
|
|
COS |
|
|
COSH |
|
|
DEGREES |
|
|
EVEN |
|
|
EXP |
|
|
FACT |
|
|
FACTDOUBLE |
|
|
FLOOR |
|
|
GCD |
|
|
INT |
|
|
LCM |
|
|
LN |
|
|
LOG |
|
|
LOG10 |
|
|
MDETERM |
|
|
MINVERSE |
|
|
MMULT |
|
|
MOD |
|
|
MROUND |
|
|
MULTINOMIAL |
|
|
ODD |
|
|
PI |
|
|
POWER |
|
|
PRODUCT |
|
|
QUOTIENT |
|
|
RADIANS |
|
|
RAND |
|
|
RANDBETWEEN |
|
|
ROMAN |
|
|
ROUND |
|
|
ROUNDDOWN |
|
|
ROUNDUP |
|
|
SIGN |
|
|
SIN |
|
|
SINH |
|
|
SQRT |
|
|
SQRTPI |
|
|
SUBTOTAL |
|
|
SUM |
|
|
SUMIF |
|
|
SUMIFS |
|
|
SUMPRODUCT |
|
|
SUMSQ |
|
|
SUMX2MY2 |
|
|
SUMX2PY2 |
|
|
SUMXMY2 |
|
|
TAN |
|
|
TANH |
|
|
TRUNC |
|
|
Statistical
Function | OSE | EE |
---|---|---|
AVEDEV | ||
AVERAGE | ||
AVERAGEA | ||
BINOMDIST | ||
CHIDIST | ||
CHIINV | ||
COUNT | ||
COUNTA | ||
COUNTBLANK | ||
COUNTIF | ||
DEVSQ | ||
EXPONDIST | ||
FDIST | ||
FINV | ||
GAMMADIST | ||
GAMMAINV | ||
GAMMALN | ||
GEOMEAN | ||
HARMEAN | ||
HYPGEOMDIST | ||
KURT | ||
LARGE | ||
MAX | ||
MAXA | ||
MEDIAN | ||
MIN | ||
MINA | ||
MODE | ||
NORMDIST | ||
POISSON | ||
RANK | ||
SKEW | ||
SLOPE | ||
SMALL | ||
STDEV | ||
TDIST | ||
TINV | ||
VAR | ||
VARP | ||
WEIBULL |
Text
Function | OSE | EE |
---|---|---|
CHAR | ||
CLEAN | ||
CODE | ||
CONCATENATE | ||
DOLLAR | ||
EXACT | ||
FIND | ||
FIXED | ||
LEFT | ||
LEN | ||
LOWER | ||
MID | ||
PROPER | ||
REPLACE | ||
REPT | ||
RIGHT | ||
SEARCH | ||
SUBSTITUTE | ||
T | ||
TEXT | ||
TRIM | ||
UPPER | ||
VALUE |
- For current open issues that supported functions have, please refer to our tracker.