Examples of org.apache.poi.ss.formula.functions.Errortype

Package org.apache.poi.ss.formula.functions

Examples of org.apache.poi.ss.formula.functions.Errortype

org.apache.poi.ss.formula.functions.Errortype
Implementation for the ERROR.TYPE() Excel function.
Syntax:
ERROR.TYPE(errorValue)

Returns a number corresponding to the error type of the supplied argument.

errorValue Return Value

#NULL! 1

#DIV/0! 2

#VALUE! 3

#REF! 4

#NAME? 5

#NUM! 6

#N/A! 7

everything else #N/A!

Note - the results of ERROR.TYPE() are different to the constants defined in ErrorConstants.
@author Josh Micich

        retval[233] = NumericFunction.ACOSH;
        retval[234] = NumericFunction.ATANH;


        retval[ID.EXTERNAL_FUNC] = null; // ExternalFunction is a FreeREfFunction


        retval[261] = new Errortype();


        retval[269] = AggregateFunction.AVEDEV;


        retval[276] = NumericFunction.COMBIN;

View Full Code Here

        retval[233] = NumericFunction.ACOSH;
        retval[234] = NumericFunction.ATANH;


        retval[ID.EXTERNAL_FUNC] = null; // ExternalFunction is a FreeREfFunction


        retval[261] = new Errortype();


        retval[269] = AggregateFunction.AVEDEV;


        retval[276] = NumericFunction.COMBIN;

View Full Code Here

TOP

Related Classes of org.apache.poi.ss.formula.functions.Errortype

org.apache.poi.ss.formula.eval.FunctionEval

org.apache.poi.ss.formula.eval.NumberEval

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.

errorValue	Return Value
#NULL!	1
#DIV/0!	2
#VALUE!	3
#REF!	4
#NAME?	5
#NUM!	6
#N/A!	7
everything else	#N/A!