Overview  Package  Class   Use  Tree  Deprecated  Index  Help 
 PREV   NEXT FRAMES    NO FRAMES    

Uses of Interface
org.apache.poi.ss.formula.functions.Function

Packages that use Function
org.apache.poi.ss.formula This package contains common internal POI code for manipulating formulas. 
org.apache.poi.ss.formula.eval   
org.apache.poi.ss.formula.functions   
 

Uses of Function in org.apache.poi.ss.formula
 

Methods in org.apache.poi.ss.formula with parameters of type Function
static void WorkbookEvaluator.registerFunction(java.lang.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 Function
 class ConcatEval
           
 class IntersectionEval
           
 class PercentEval
          Implementation of Excel formula token '%'.
 class RangeEval
           
 class RelationalOperationEval
          Base class for all comparison operator evaluators
 class TwoOperandNumericOperation
           
 class UnaryMinusEval
           
 class UnaryPlusEval
           
 

Fields in org.apache.poi.ss.formula.eval declared as Function
static Function TwoOperandNumericOperation.AddEval
           
static Function TwoOperandNumericOperation.DivideEval
           
static Function RelationalOperationEval.EqualEval
           
protected static Function[] FunctionEval.functions
          Array elements corresponding to unimplemented functions are null
static Function RelationalOperationEval.GreaterEqualEval
           
static Function RelationalOperationEval.GreaterThanEval
           
static Function RangeEval.instance
           
static Function ConcatEval.instance
           
static Function UnaryPlusEval.instance
           
static Function UnaryMinusEval.instance
           
static Function IntersectionEval.instance
           
static Function PercentEval.instance
           
static Function RelationalOperationEval.LessEqualEval
           
static Function RelationalOperationEval.LessThanEval
           
static Function TwoOperandNumericOperation.MultiplyEval
           
static Function RelationalOperationEval.NotEqualEval
           
static Function TwoOperandNumericOperation.PowerEval
           
static Function TwoOperandNumericOperation.SubtractEval
           
 

Methods in org.apache.poi.ss.formula.eval that return Function
static Function FunctionEval.getBasicFunction(int functionIndex)
           
 

Methods in org.apache.poi.ss.formula.eval with parameters of type Function
static void FunctionEval.registerFunction(java.lang.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.functions
 interface Function0Arg
          Implemented by all functions that can be called with zero arguments
 interface Function1Arg
          Implemented by all functions that can be called with one argument
 interface Function2Arg
          Implemented by all functions that can be called with two arguments
 interface Function3Arg
          Implemented by all functions that can be called with three arguments
 interface Function4Arg
          Implemented by all functions that can be called with four arguments
 

Classes in org.apache.poi.ss.formula.functions that implement Function
 class Address
          Creates a text reference as text, given specified row and column numbers.
 class AggregateFunction
           
 class Bin2Dec
          Implementation for Excel Bin2Dec() function.
 class BooleanFunction
          Here 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.
 class CalendarFieldFunction
          Implementation of Excel functions Date parsing functions: Date - DAY, MONTH and YEAR Time - HOUR, MINUTE and SECOND
 class Choose
           
 class Code
          Implementation for Excel CODE () function.
 class Column
           
 class Columns
          Implementation for Excel COLUMNS function.
 class Complex
          Implementation for Excel COMPLEX () function.
 class Count
          Counts the number of cells that contain numeric data within the list of arguments.
 class Counta
          Counts the number of cells that contain data within the list of arguments.
 class Countblank
          Implementation for the function COUNTBLANK
 class Countif
          Implementation for the function COUNTIF
 class DateFunc
          Implementation for the Excel function DATE
 class Days360
          Calculates the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations.
 class Dec2Bin
          Implementation for Excel Bin2Dec() function.
 class Dec2Hex
          Implementation for Excel DELTA() function.
 class Delta
          Implementation for Excel DELTA() function.
 class DStarRunner
          This class performs a D* calculation.
 class Errortype
          Implementation for the ERROR.TYPE() Excel function.
 class Even
           
 class FactDouble
          Implementation for Excel FACTDOUBLE() function.
 class FinanceFunction
           
 class Fixed
           
 class Fixed0ArgFunction
          Convenience base class for functions that only take zero arguments.
 class Fixed1ArgFunction
          Convenience base class for functions that must take exactly one argument.
 class Fixed2ArgFunction
          Convenience base class for functions that must take exactly two arguments.
 class Fixed3ArgFunction
          Convenience base class for functions that must take exactly three arguments.
 class Fixed4ArgFunction
          Convenience base class for functions that must take exactly four arguments.
 class Hex2Dec
          Implementation for Excel HEX2DEC() function.
 class Hlookup
          Implementation of the HLOOKUP() function.
 class Hyperlink
          Implementation of Excel HYPERLINK function.
 class IfFunc
          Implementation for the Excel function IF
 class Imaginary
          Implementation for Excel IMAGINARY() function.
 class ImReal
          Implementation for Excel ImReal() function.
 class Index
          Implementation for the Excel function INDEX
 class Intercept
          Implementation of Excel function INTERCEPT()
 class IPMT
           
 class Irr
          Calculates the internal rate of return.
 class LinearRegressionFunction
          Base class for linear regression functions.
 class LogicalFunction
          Implementation of the various ISxxx Logical Functions, which take a single expression argument, and return True or False.
 class Lookup
          Implementation of Excel function LOOKUP.
 class Match
          Implementation for the MATCH() Excel function.
 class MinaMaxa
           
 class Mirr
          Calculates Modified internal rate of return.
 class Mode
           
 class MultiOperandNumericFunction
          This is the super class for all excel function evaluator classes that take variable number of operands, and where the order of operands does not matter
 class Na
          Implementation of Excel function NA()
 class NotImplementedFunction
          This is the default implementation of a Function class.
 class Now
          Implementation of Excel NOW() Function
 class Npv
          Calculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positive values).
 class NumericFunction
           
static class NumericFunction.OneArg
           
static class NumericFunction.TwoArg
           
 class Oct2Dec
          Implementation for Excel Oct2Dec() function.
 class Odd
           
 class Offset
          Implementation for Excel function OFFSET()
 class PPMT
          Compute the interest portion of a payment.
 class Quotient
          Implementation for Excel QUOTIENT () function.
 class Rank
          Returns the rank of a number in a list of numbers.
 class Rate
          Implements the Excel Rate function
 class Replace
          An implementation of the Excel REPLACE() function:
 class Rept
          Implementation for Excel REPT () function.
 class Roman
          Implementation for Excel WeekNum() function.
 class RowFunc
          Implementation for the Excel function ROW
 class Rows
          Implementation for Excel ROWS function.
 class Slope
          Implementation of Excel function SLOPE()
 class Substitute
          An implementation of the SUBSTITUTE function:
 class Subtotal
          Implementation for the Excel function SUBTOTAL
 class Sumif
          Implementation for the Excel function SUMIF
 class Sumproduct
          Implementation for the Excel function SUMPRODUCT
 class Sumx2my2
          Implementation of Excel function SUMX2MY2()
 class Sumx2py2
          Implementation of Excel function SUMX2PY2()
 class Sumxmy2
          Implementation of Excel function SUMXMY2()
 class T
          Implementation of Excel T() function
 class TextFunction
           
 class TimeFunc
          Implementation for the Excel function TIME
 class Today
          Implementation of Excel TODAY() Function
 class Value
          Implementation for Excel VALUE() function.
 class Vlookup
          Implementation of the VLOOKUP() function.
 class WeekdayFunc
          Implementation for the Excel function WEEKDAY
 class WeekNum
          Implementation for Excel WeekNum() function.
 class XYNumericFunction
           
 

Fields in org.apache.poi.ss.formula.functions declared as Function
static Function NumericFunction.ABS
           
static Function NumericFunction.ACOS
           
static Function NumericFunction.ACOSH
           
static Function BooleanFunction.AND
           
static Function NumericFunction.ASIN
           
static Function NumericFunction.ASINH
           
static Function NumericFunction.ATAN
           
static Function NumericFunction.ATAN2
           
static Function NumericFunction.ATANH
           
static Function AggregateFunction.AVEDEV
           
static Function AggregateFunction.AVERAGE
           
static Function NumericFunction.CEILING
           
static Function TextFunction.CHAR
          Returns the character specified by a number.
static Function TextFunction.CLEAN
          An implementation of the CLEAN function: In Excel, the Clean function removes all non-printable characters from a string.
static Function NumericFunction.COMBIN
           
static Function TextFunction.CONCATENATE
           
static Function NumericFunction.COS
           
static Function NumericFunction.COSH
           
static Function CalendarFieldFunction.DAY
           
static Function NumericFunction.DEGREES
           
static Function AggregateFunction.DEVSQ
           
static Function NumericFunction.DOLLAR
           
static Function TextFunction.EXACT
           
static Function NumericFunction.EXP
           
static Function NumericFunction.FACT
           
static Function BooleanFunction.FALSE
           
static Function TextFunction.FIND
          Implementation of the FIND() function.
static Function NumericFunction.FLOOR
           
static Function FinanceFunction.FV
           
static Function CalendarFieldFunction.HOUR
           
static Function DateFunc.instance
           
static Function WeekdayFunc.instance
           
static Function NumericFunction.INT
           
static Function LogicalFunction.ISBLANK
           
static Function LogicalFunction.ISERR
          Implementation of Excel ISERR() function.
static Function LogicalFunction.ISERROR
           
static Function LogicalFunction.ISLOGICAL
           
static Function LogicalFunction.ISNA
          Implementation for Excel ISNA() function.
static Function LogicalFunction.ISNONTEXT
           
static Function LogicalFunction.ISNUMBER
           
static Function LogicalFunction.ISREF
           
static Function LogicalFunction.ISTEXT
           
static Function AggregateFunction.LARGE
           
static Function TextFunction.LEFT
           
static Function TextFunction.LEN
           
static Function NumericFunction.LN
           
static Function NumericFunction.LOG
           
static Function NumericFunction.LOG10
           
static Function TextFunction.LOWER
           
static Function AggregateFunction.MAX
           
static Function MinaMaxa.MAXA
           
static Function AggregateFunction.MEDIAN
           
static Function TextFunction.MID
          An implementation of the MID function
MID returns a specific number of characters from a text string, starting at the specified position.
static Function AggregateFunction.MIN
           
static Function MinaMaxa.MINA
           
static Function CalendarFieldFunction.MINUTE
           
static Function NumericFunction.MOD
           
static Function CalendarFieldFunction.MONTH
           
static Function BooleanFunction.NOT
           
static Function FinanceFunction.NPER
           
static Function BooleanFunction.OR
           
static Function AggregateFunction.PERCENTILE
           
static Function NumericFunction.PI
           
static Function FinanceFunction.PMT
           
static Function NumericFunction.POISSON
           
static Function NumericFunction.POWER
           
static Function AggregateFunction.PRODUCT
           
static Function TextFunction.PROPER
          Implementation of the PROPER function: Normalizes all words (separated by non-word characters) by making the first letter upper and the rest lower case.
static Function FinanceFunction.PV
           
static Function NumericFunction.RADIANS
           
static Function NumericFunction.RAND
           
static Function TextFunction.RIGHT
           
static Function NumericFunction.ROUND
           
static Function NumericFunction.ROUNDDOWN
           
static Function NumericFunction.ROUNDUP
           
static Function TextFunction.SEARCH
          Implementation of the FIND() function.
static Function CalendarFieldFunction.SECOND
           
static Function NumericFunction.SIGN
           
static Function NumericFunction.SIN
           
static Function NumericFunction.SINH
           
static Function AggregateFunction.SMALL
           
static Function NumericFunction.SQRT
           
static Function AggregateFunction.STDEV
           
static Function AggregateFunction.SUM
           
static Function AggregateFunction.SUMSQ
           
static Function NumericFunction.TAN
           
static Function NumericFunction.TANH
           
static Function TextFunction.TEXT
          An implementation of the TEXT function
TEXT returns a number value formatted with the given number formatting string.
static Function TextFunction.TRIM
          An implementation of the TRIM function: Removes leading and trailing spaces from value if evaluated operand value is string.
static Function BooleanFunction.TRUE
           
static Function NumericFunction.TRUNC
           
static Function TextFunction.UPPER
           
static Function AggregateFunction.VAR
           
static Function AggregateFunction.VARP
           
static Function CalendarFieldFunction.YEAR
           
 

Overview  Package  Class   Use  Tree  Deprecated  Index  Help 
 PREV   NEXT FRAMES    NO FRAMES    
Copyright 2017 The Apache Software Foundation or its licensors, as applicable.