Difference between revisions of "Z API Functions"

Revision as of 14:38, 14 November 2016

LIST OF ALL FUNCTIONS

STATISTICAL FUNCTIONS1

STATISTICAL FUNCTIONS2

MATH1

MATH2

DATE AND TIME1

DATE AND TIME2

ENGINEERING1

ENGINEERING2

FINANCIAL1

FINANCIAL2

GEOMETRY AND GRAPH1

GEOMETRY AND GRAPH2

INFORMATION1

INFORMATION2

LOGICAL1

DATABASE AND LIST MANAGEMENT1

DATABASE AND LIST MANAGEMENT2

LOOKUP AND REFERENCE1

GETFUNCTION SET - * GETFUNCTIONSET GET GPS -* GETGPS GETJSON - * GETJSON GET LINE- * GETLINE GET NUMBER TAIL - * GETNUMBERTAIL GET REAL OR COMPLEX - * GETREALORCOMPLEX GET ROW - * GETROW GET SERIES - * GETSERIES GMAP - * GMAP GOALSEEK - * GOALSEEK GROUP - * GROUP HLOOKUP - * HLOOKUP HVLOOKUP - * HVLOOKUP INDEX - * INDEX INDIRECT - * INDIRECT INFO - * INFO INTEG - * INTEG LIST COLUMN LABELS - * LISTCOLUMNLABELS LIST COLUMNS - * LISTCOLUMNS LIST ROWS - * LISTROWS LIST UNIQUE - * LISTUNIQUE LISTV - * LISTV LOOKUP - * LOOKUP LOOP MEDIA - * LOOPMEDIA MLANGUAGE LOOKUP - * MLANGUAGELOOKUP NUMBER EIGHT - * NUMBEREIGHT NUMBER FIVE - * NUMBERFIVE NUMBER FOUR - * NUMBERFOUR NUMBER NINE - * NUMBERNINE NUMBER ONE - * NUMBERONE NUMBER SEVEN - * NUMBERSEVEN NUMBER SIX - * NUMBERSIX NUMBER TEN - * NUMBERTEN NUMBER THREE - * NUMBERTHREE NUMBER TWO - * NUMBERTWO NUMBER ZERO - * NUMBERZERO ONE - * ONE ONE BY -* ONEBY PARSE - * PARSE PARSE LISP - * PARSELISP PARSE NUMBER - * PARSENUMBER PARSE SQL - * PARSESQL PARSESTRING WITHOUT PARANTHESIS - * PARSESTRINGWITHOUTPARANTHESIS PASTE COLUMNS - * PASTECOLUMNS PASTE ROWS - * PASTEROWS PAUSE - * PAUSE QUOTE - * QUOTE ROW - * ROW ROWS - * ROWS ROW WITH - * ROWWITH SMILE - * SMILE UNDEFINED - * UNDEFINED UPTO - * UPTO VLOOKUP - * VLOOKUP

Lookup and Reference2: ANALYZE - * ANALYZE ASSIGN- * ASSIGN ASYNC ITERATE* ASYNCITERATE ATTRTOPROP - * ATTRTOPROP CASE - * CASE CASEIF - * CASEIF CDR - * CDR EFFECT COLORBOOK - * EFFECTCOLORBOOK EFFECTEDGEDETECTION - * EFFECTEDGEDETECTION EFFECTEDGEDETECTIONALGORITHM - * EFFECTEDGEDETECTIONALGORITHM EFFECTGLASS - * EFFECTGLASS EFFECTGLASSBOX - * EFFECTGLASSBOX EFFECT GLASS PATTERN -* EFFECTGLASSPATTERN EFFECTNEONLINES - * EFFECTNEONLINES EFFECTPATTERN - * EFFECTPATTERN EFFECTRIPPLES - * EFFECTRIPPLES GETCELLTD- * GETCELLTD GETLATLONG - * GETLATLONG GKMAPPING - * GKMAPPING PENTATE - * PENTATE QPIVOT - * QPIVOT QPIVOT IN CUBE - * QPIVOTINCUBE SAFE EVAL - * SAFEEVAL STEP LOOP - * STEPLOOP TIMER - * TIMER TIMES - * TIMES TIME STRING - * TIMESTRING TYPE - * TYPE TZ - * TZ XLBETWEEN - * XLBETWEEN XLR BETWEEN - * XLRBETWEEN XPY - * XPY XR BETWEEN - * XRBETWEEN XSY - * XSY

Text and Data1: BADWORDS - * BADWORDS CHAR - * CHAR CHR-* CHR CLAUSES - * CLAUSES CLEAN - * CLEAN CLEAR - * CLEAR CLS -* CLS CODE - * CODE DEFAULT - * DEFAULT DEFAULT NUMBER - * DEFAULTNUMBER DEFAULT PROPER - * DEFAULTPROPER DEFUN - * DEFUN DES - * DES DESCRIBEFUNCTIONCALLMISSING - * DESCRIBEFUNCTIONCALLMISSING DEVARRAY - * DEVARRAY DIM - * DIM DIMENSIONS - * DIMENSIONS DIS - * DIS EIGHTHOF - * EIGHTHOF ESCAPE - * ESCAPE EXTRACT NUMBERS - * EXTRACTNUMBERS EXTRACT TEXT - * EXTRACTTEXT FAIL - * FAIL FIND - * FIND FINDB - * FINDB FINDUNIT - * FINDUNIT FIXCHARS - * FIXCHARS FIXED - * FIXED FIXED BAD- * FIXEDBAD FOR - * FOR FOR ALL- * FORALL FOREACH - * FOREACH FORLOOP - * FORLOOP LEFTB - * LEFTB LEN - * LEN LENB - * LENB LETTERS - * LETTERS LOWER - * LOWER LOWER CASE - * LOWERCASE LZ - * LZ LZWCOMPRESS - * LZWCOMPRESS LZWDECOMPRESS - * LZWDECOMPRESS MID - * MID MIDB - * MIDB MIDDLE - * MIDDLE MIDN - * MIDN MIXED CASE - * MIXEDCASE NOK - * NOK NON FALSE VALUE - * NONFALSEVALUE NON NEGATIVE - * NONNEGATIVE NON POSITIVE - * NONPOSITIVE NON ZERO - * NONZERO NON ZERO VALUE - * NONZEROVALUE NOPE - * NOPE NOW - * NOW NULL - * NULL NULL IF - * NULLIF NUM - * NUM NUMBER - * NUMBER NVL - * NVL OSTYLE - * OSTYLE OUTPUT - * OUTPUT PACK - * PACK PADZEROES - * PADZEROES PHONETIC - * PHONETIC PHONETIC CODES - * PHONETICCODES PRINT - * PRINT PRINT CONVERSION - * PRINTCONVERSION PRINTTAGS - * PRINTTAGS PRINT UNIT TAGS - * PRINTUNITTAGS PRINT WITH UNITS - * PRINTWITHUNITS PROPER - * PROPER PUSH - * PUSH REMOVE TEXT - * REMOVETEXT REPEAT CHAR - * REPEATCHAR REPLACE - * REPLACE REPLACE ARRAY - * REPLACEARRAY REPLACEB - * REPLACEB REPLACE BAD - * REPLACEBAD REPT - * REPT REVERSE - * REVERSE RIGHTB - * RIGHTB RTD - * RTD SEARCH - * SEARCH SEARCHB - * SEARCHB SEARCH BOX SPACE - * SearchBoxSpace SEQ - * SEQ SET VALUE STRING - * SETVALUESTRING SET WHOISUSER - * SETWHOISUSER SLIDER CONTROL - * SLIDERCONTROL SO - * SO SOB - * SOB SOC - * SOC SOH - * SOH SOI - * SOI SOL - * SOL SOLT - * SOLT SOLTWH - * SOLTWH

@@ Line 603: / Line 603: @@
 *[[Manuals/calci/BESSELY | BESSELY]]
 *[[Manuals/calci/ENFORCECOMPLEX | ENFORCECOMPLEX]]
-FINANCIAL1:
+==FINANCIAL1==
 *[[Manuals/calci/ACCRINT | ACCRINT]]
 *[[Manuals/calci/AMORLINC | AMORLINC]]
@@ Line 617: / Line 617: @@
 *[[Manuals/calci/DB | DB]]
 *[[Manuals/calci/DDB | DDB]]
- *[[Manuals/calci/DISC | DISC]]
+*[[Manuals/calci/DISC | DISC]]
 *[[Manuals/calci/DOLLAR | DOLLAR]]
 *[[Manuals/calci/DOLLARDE | DOLLARDE]]
@@ Line 653: / Line 653: @@
 *[[Manuals/calci/USDOLLAR | USDOLLAR]]
 *[[Manuals/calci/XNPV | XNPV]]
-FINANCIAL2:
+==FINANCIAL2==
 *[[Manuals/calci/ACCRINTM | ACCRINTM]]
 *[[Manuals/calci/AMORDEGRC | AMORDEGRC]]
@@ Line 663: / Line 663: @@
 *[[Manuals/calci/OPTIONSECURITY | OPTIONSECURITY]]
 *[[Manuals/calci/PRICE | PRICE]]
- *[[Manuals/calci/PRICEDISC | PRICEDISC]]
+*[[Manuals/calci/PRICEDISC | PRICEDISC]]
 *[[Manuals/calci/PRICEMAT | PRICEMAT]]
 *[[Manuals/calci/PUTOPTION | PUTOPTION]]
@@ Line 674: / Line 674: @@
 *[[Manuals/calci/YIELDMAT | YIELDMAT]]
 *[[Manuals/calci/YMXC | YMXC]]
-GEOMETRY AND GRAPH1:
+==GEOMETRY AND GRAPH1==
 *[[Manuals/calci/BARCHART | BARCHART]]
 *[[Manuals/calci/BARHIERARCHY | BARHIERARCHY]]
@@ Line 723: / Line 723: @@
 *[[Manuals/calci/TRIANGLE | TRIANGLE]]
 *[[Manuals/calci/XYPOINT | XYPOINT]]
-GEOMETRY AND GRAPH2:
+==GEOMETRY AND GRAPH2==
 *[[Manuals/calci/BUBBLECHART | BUBBLECHART]]
 *[[Manuals/calci/CLOSEDCURVE | CLOSEDCURVE]]
@@ Line 736: / Line 736: @@
 *[[Manuals/calci/SURFACEGRAPHCORE | SURFACEGRAPHCORE]]
 *[[Manuals/calci/TORUS | TORUS]]
-INFORMATION1:
+==INFORMATION1==
 *[[Manuals/calci/APPLY | APPLY]]
 *[[Manuals/calci/APPLYFUNCTIONTOALLELEMENTS | APPLYFUNCTIONTOALLELEMENTS]]
@@ Line 897: / Line 897: @@
 *[[Manuals/calci/YES | YES]]
 *[[Manuals/calci/YUP | YUP]]
-INFORMATION2:
+==INFORMATION2==
 *[[Manuals/calci/ACRONYM | ACRONYM]]
 *[[Manuals/calci/APOLOGIZE | APOLOGIZE]]
@@ Line 921: / Line 921: @@
 *[[Manuals/calci/SDIM | SDIM]]
 *[[Manuals/calci/SOSZ | SOSZ]]
- *[[Manuals/calci/SOT | SOT]]
+*[[Manuals/calci/SOT | SOT]]
 *[[Manuals/calci/SOV | SOV]]
- *[[Manuals/calci/SOW | SOW]]
+*[[Manuals/calci/SOW | SOW]]
 *[[Manuals/calci/SOWH | SOWH]]
 *[[Manuals/calci/SOZ | SOZ]]
@@ Line 938: / Line 938: @@
 *[[Manuals/calci/XFUNCTIONAT | XFUNCTIONAT]]
 *[[Manuals/calci/XMLDEPTH | XMLDEPTH]]
- *[[Manuals/calci/XMLSET | XMLSET]]
+*[[Manuals/calci/XMLSET | XMLSET]]
 *[[Manuals/calci/XMLTOTABLE | XMLTOTABLE]]
 *[[Manuals/calci/XMLVALUES | XMLVALUES]]
 *[[Manuals/calci/XMY | XMY]]
-LOGICAL1:
+==LOGICAL1==
- *[[Manuals/calci/BITAND | BITAND]]
+*[[Manuals/calci/BITAND | BITAND]]
 *[[Manuals/calci/BITLSHIFT | BITLSHIFT]]
 *[[Manuals/calci/BITNOT | BITNOT]]
@@ Line 960: / Line 960: @@
 *[[Manuals/calci/TRUE | TRUE]]
 *[[Manuals/calci/TRUEVALUE | TRUEVALUE]]
-DATABASE AND LIST MANAGEMENT1:
+==DATABASE AND LIST MANAGEMENT1==
 *[[Manuals/calci/DAVERAGE | DAVERAGE]]
 *[[Manuals/calci/DCOUNT | DCOUNT]]
@@ Line 973: / Line 973: @@
 *[[Manuals/calci/DVAR | DVAR]]
 *[[Manuals/calci/DVARP | DVARP]]
-DATABASE AND LIST MANAGEMENT2:
+==DATABASE AND LIST MANAGEMENT2==
 *[[Manuals/calci/DBPEDIA | DBPEDIA]]
 *[[Manuals/calci/DIAG | DIAG]]
@@ Line 981: / Line 981: @@
 *[[Manuals/calci/DOEFFECT | DOEFFECT]]
 *[[Manuals/calci/DOFUNCTIONIF | DOFUNCTIONIF]]
-LOOKUP AND REFERENCE1:
+==LOOKUP AND REFERENCE1==
 *[[Manuals/calci/ADDRESS | ADDRESS]]
 *[[Manuals/calci/AGE | AGE]]
@@ Line 1,002: / Line 1,002: @@
 *[[Manuals/calci/FUCTIONTOIMPLEMENT | FUCTIONTOIMPLEMENT]]
 *[[Manuals/calci/FUNC | FUNC]]
-FUNCT - *[[Manuals/calci/FUNCT | FUNCT]]
+*[[Manuals/calci/FUNCT | FUNCT]]
-FUNCTIONFROMTEMPLATE  - *[[Manuals/calci/FUNCTIONFROMTEMPLATE | FUNCTIONFROMTEMPLATE]]
+*[[Manuals/calci/FUNCTIONFROMTEMPLATE | FUNCTIONFROMTEMPLATE]]
-FUNCTION OF - *[[Manuals/calci/FUNCTIONOF | FUNCTIONOF]]
+*[[Manuals/calci/FUNCTIONOF | FUNCTIONOF]]
-FUZZY - *[[Manuals/calci/FUZZY | FUZZY]]
+*[[Manuals/calci/FUZZY | FUZZY]]
-GETCOLUMN - *[[Manuals/calci/GETCOLUMN | GETCOLUMN]]
+*[[Manuals/calci/GETCOLUMN | GETCOLUMN]]
-GETCONVERSION - *[[Manuals/calci/GETCONVERSION | GETCONVERSION]]
+*[[Manuals/calci/GETCONVERSION | GETCONVERSION]]
-GETFUNCTION - *[[Manuals/calci/GETFUNCTION | GETFUNCTION]]
+*[[Manuals/calci/GETFUNCTION | GETFUNCTION]]
 GETFUNCTION SET - *[[Manuals/calci/GETFUNCTIONSET | GETFUNCTIONSET]]
 GET GPS -*[[Manuals/calci/GETGPS | GETGPS]]