Uses of Interface
org.apache.poi.ss.formula.functions.Function
Packages that use Function
Package
Description
This package contains common internal POI code for manipulating formulas.
-
Uses of Function in org.apache.poi.ss.formula
Methods in org.apache.poi.ss.formula with parameters of type FunctionModifier and TypeMethodDescriptionstatic voidWorkbookEvaluator.registerFunction(String name, Function func) Register a function in runtime. -
Uses of Function in org.apache.poi.ss.formula.eval
Classes in org.apache.poi.ss.formula.eval that implement FunctionModifier and TypeClassDescriptionfinal classfinal classfinal classImplementation of Excel formula token '%'.final classclassBase class for all comparison operator evaluatorsclassfinal classfinal classFields in org.apache.poi.ss.formula.eval declared as FunctionModifier and TypeFieldDescriptionstatic final FunctionTwoOperandNumericOperation.AddEvalstatic final FunctionTwoOperandNumericOperation.DivideEvalstatic final FunctionRelationalOperationEval.EqualEvalprotected static final Function[]FunctionEval.functionsArray elements corresponding to unimplemented functions arenullstatic final FunctionRelationalOperationEval.GreaterEqualEvalstatic final FunctionRelationalOperationEval.GreaterThanEvalstatic final FunctionConcatEval.instancestatic final FunctionIntersectionEval.instancestatic final FunctionPercentEval.instancestatic final FunctionRangeEval.instancestatic final FunctionUnaryMinusEval.instancestatic final FunctionUnaryPlusEval.instancestatic final FunctionRelationalOperationEval.LessEqualEvalstatic final FunctionRelationalOperationEval.LessThanEvalstatic final FunctionTwoOperandNumericOperation.MultiplyEvalstatic final FunctionRelationalOperationEval.NotEqualEvalstatic final FunctionTwoOperandNumericOperation.PowerEvalstatic final FunctionTwoOperandNumericOperation.SubtractEvalMethods in org.apache.poi.ss.formula.eval that return FunctionModifier and TypeMethodDescriptionstatic FunctionFunctionEval.getBasicFunction(int functionIndex) Methods in org.apache.poi.ss.formula.eval with parameters of type FunctionModifier and TypeMethodDescriptionstatic voidFunctionEval.registerFunction(String name, Function func) Register a new function in runtime. -
Uses of Function in org.apache.poi.ss.formula.functions
Subinterfaces of Function in org.apache.poi.ss.formula.functionsModifier and TypeInterfaceDescriptioninterfaceImplemented by all functions that can be called with zero argumentsinterfaceImplemented by all functions that can be called with one argumentinterfaceImplemented by all functions that can be called with two argumentsinterfaceImplemented by all functions that can be called with three argumentsinterfaceImplemented by all functions that can be called with four argumentsClasses in org.apache.poi.ss.formula.functions that implement FunctionModifier and TypeClassDescriptionclassCreates a text reference as text, given specified row and column numbers.classfinal classReturns the number of areas in a reference.classImplementation for Excel Bin2Dec() function.classHere are the general rules concerning Boolean functions: Blanks are ignored (not either true or false) Strings are ignored if part of an area ref or cell ref, otherwise they must be 'true' or 'false' Numbers: 0 is false.final classImplementation of Excel functions Date parsing functions: Date - DAY, MONTH and YEAR Time - HOUR, MINUTE and SECONDfinal classclassImplementation for Excel CODE () function.final classfinal classImplementation for Excel COLUMNS function.classImplementation for Excel COMPLEX () function.final classCounts the number of cells that contain numeric data within the list of arguments.final classCounts the number of cells that contain data within the list of arguments.final classImplementation for the function COUNTBLANKfinal classImplementation for the function COUNTIFfinal classImplementation for the Excel function DATEclassCalculates the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations.classImplementation for Excel Bin2Dec() function.final classImplementation for Excel DELTA() function.final classImplementation for Excel DELTA() function.final classThis class performs a D* calculation.final classImplementation for the ERROR.TYPE() Excel function.final classclassImplementation for Excel FACTDOUBLE() function.classfinal classclassConvenience base class for functions that only take zero arguments.classConvenience base class for functions that must take exactly one argument.classConvenience base class for functions that must take exactly two arguments.classConvenience base class for functions that must take exactly three arguments.classConvenience base class for functions that must take exactly four arguments.classImplementation of Excel 'Analysis ToolPak' function FREQUENCY()
Returns a frequency distribution as a vertical arrayclassImplementation for Excel HEX2DEC() function.final classImplementation of the HLOOKUP() function.final classImplementation of Excel HYPERLINK function.final classImplementation for the Excel function IFclassImplementation for Excel IMAGINARY() function.classImplementation for Excel ImReal() function.final classImplementation for the Excel function INDEXfinal classImplementation of Excel function INTERCEPT()classfinal classCalculates the internal rate of return.final classBase class for linear regression functions.classImplementation of the various ISxxx Logical Functions, which take a single expression argument, and return True or False.final classImplementation of Excel function LOOKUP.final classImplementation for the MATCH() Excel function.classstatic final classstatic classstatic classclassclassCalculates Modified internal rate of return.final classclassThis is the super class for all excel function evaluator classes that take variable number of operands, and where the order of operands does not matterfinal classImplementation of Excel function NA()final classThis is the default implementation of a Function class.final classImplementation of Excel NOW() Functionfinal classCalculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values).classstatic classstatic classclassImplementation for Excel Oct2Dec() function.final classfinal classImplementation for Excel function OFFSET()classCompute the interest portion of a payment.classImplementation for Excel QUOTIENT () function.classReturns the rank of a number in a list of numbers.classImplements the Excel Rate functionfinal classAn implementation of the Excel REPLACE() function:classImplementation for Excel REPT () function.classImplementation for Excel WeekNum() function.final classImplementation for the Excel function ROWfinal classImplementation for Excel ROWS function.final classImplementation of Excel function SLOPE()final classAn implementation of the SUBSTITUTE function:classImplementation for the Excel function SUBTOTALfinal classImplementation for the Excel function SUMIFfinal classImplementation for the Excel function SUMPRODUCTfinal classImplementation of Excel function SUMX2MY2()final classImplementation of Excel function SUMX2PY2()final classImplementation of Excel function SUMXMY2()final classImplementation of Excel T() functionclassfinal classImplementation for the Excel function TIMEfinal classImplementation of Excel TODAY() Functionfinal classImplementation for the Excel function TRENDfinal classImplementation for Excel VALUE() function.final classImplementation of the VLOOKUP() function.final classImplementation for the Excel function WEEKDAYclassImplementation for Excel WeekNum() function.classFields in org.apache.poi.ss.formula.functions declared as FunctionModifier and TypeFieldDescriptionstatic final FunctionNumericFunction.ABSstatic final FunctionNumericFunction.ACOSstatic final FunctionNumericFunction.ACOSHstatic final FunctionBooleanFunction.ANDstatic final FunctionNumericFunction.ASINstatic final FunctionNumericFunction.ASINHstatic final FunctionNumericFunction.ATANstatic final FunctionNumericFunction.ATAN2static final FunctionNumericFunction.ATANHstatic final FunctionAggregateFunction.AVEDEVstatic final FunctionAggregateFunction.AVERAGEstatic final FunctionNumericFunction.CEILINGstatic final FunctionTextFunction.CHARReturns the character specified by a number.static final FunctionTextFunction.CLEANAn implementation of the CLEAN function: In Excel, the Clean function removes all non-printable characters from a string.static final FunctionNumericFunction.COMBINstatic final FunctionTextFunction.CONCATENATEstatic final FunctionNumericFunction.COSstatic final FunctionNumericFunction.COSHstatic final FunctionCalendarFieldFunction.DAYstatic final FunctionNumericFunction.DEGREESstatic final FunctionAggregateFunction.DEVSQstatic final FunctionNumericFunction.DOLLARstatic final FunctionTextFunction.EXACTstatic final FunctionNumericFunction.EXPstatic final FunctionNumericFunction.FACTstatic final FunctionBooleanFunction.FALSEstatic final FunctionTextFunction.FINDImplementation of the FIND() function.static final FunctionNumericFunction.FLOORstatic final FunctionFinanceFunction.FVstatic final FunctionCalendarFieldFunction.HOURstatic final FunctionDateFunc.instancestatic final FunctionFrequency.instancestatic final FunctionWeekdayFunc.instancestatic final FunctionNumericFunction.INTstatic final FunctionLogicalFunction.ISBLANKstatic final FunctionLogicalFunction.ISERRImplementation of Excel ISERR() function.static final FunctionLogicalFunction.ISERRORstatic final FunctionLogicalFunction.ISLOGICALstatic final FunctionLogicalFunction.ISNAImplementation for Excel ISNA() function.static final FunctionLogicalFunction.ISNONTEXTstatic final FunctionLogicalFunction.ISNUMBERstatic final FunctionLogicalFunction.ISREFstatic final FunctionLogicalFunction.ISTEXTstatic final FunctionAggregateFunction.LARGEstatic final FunctionTextFunction.LEFTstatic final FunctionTextFunction.LENstatic final FunctionNumericFunction.LNstatic final FunctionNumericFunction.LOGstatic final FunctionNumericFunction.LOG10static final FunctionTextFunction.LOWERstatic final FunctionAggregateFunction.MAXstatic final FunctionMinaMaxa.MAXAstatic final FunctionMatrixFunction.MDETERMstatic final FunctionAggregateFunction.MEDIANstatic final FunctionTextFunction.MIDAn implementation of the MID function
MID returns a specific number of characters from a text string, starting at the specified position.static final FunctionAggregateFunction.MINstatic final FunctionMinaMaxa.MINAstatic final FunctionCalendarFieldFunction.MINUTEstatic final FunctionMatrixFunction.MINVERSEstatic final FunctionMatrixFunction.MMULTstatic final FunctionNumericFunction.MODstatic final FunctionCalendarFieldFunction.MONTHstatic final FunctionBooleanFunction.NOTstatic final FunctionFinanceFunction.NPERstatic final FunctionBooleanFunction.ORstatic final FunctionAggregateFunction.PERCENTILEstatic final FunctionNumericFunction.PIstatic final FunctionFinanceFunction.PMTstatic final FunctionNumericFunction.POISSONstatic final FunctionNumericFunction.POWERstatic final FunctionAggregateFunction.PRODUCTstatic final FunctionTextFunction.PROPERImplementation of the PROPER function: Normalizes all words (separated by non-word characters) by making the first letter upper and the rest lower case.static final FunctionFinanceFunction.PVstatic final FunctionNumericFunction.RADIANSstatic final FunctionNumericFunction.RANDstatic final FunctionTextFunction.RIGHTstatic final FunctionNumericFunction.ROUNDstatic final FunctionNumericFunction.ROUNDDOWNstatic final FunctionNumericFunction.ROUNDUPstatic final FunctionTextFunction.SEARCHImplementation of the FIND() function.static final FunctionCalendarFieldFunction.SECONDstatic final FunctionNumericFunction.SIGNstatic final FunctionNumericFunction.SINstatic final FunctionNumericFunction.SINHstatic final FunctionAggregateFunction.SMALLstatic final FunctionNumericFunction.SQRTstatic final FunctionAggregateFunction.STDEVstatic final FunctionAggregateFunction.SUMstatic final FunctionAggregateFunction.SUMSQstatic final FunctionNumericFunction.TANstatic final FunctionNumericFunction.TANHstatic final FunctionTextFunction.TEXTAn implementation of the TEXT function
TEXT returns a number value formatted with the given number formatting string.static final FunctionMatrixFunction.TRANSPOSEstatic final FunctionTextFunction.TRIMAn implementation of the TRIM function: Removes leading and trailing spaces from value if evaluated operand value is string.static final FunctionBooleanFunction.TRUEstatic final FunctionNumericFunction.TRUNCstatic final FunctionTextFunction.UPPERstatic final FunctionAggregateFunction.VARstatic final FunctionAggregateFunction.VARPstatic final FunctionCalendarFieldFunction.YEAR