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

Packages that use Function2Arg
org.apache.poi.ss.formula.eval   
org.apache.poi.ss.formula.functions   
 

Uses of Function2Arg in org.apache.poi.ss.formula.eval
 

Classes in org.apache.poi.ss.formula.eval that implement Function2Arg
 class ConcatEval
           
 class IntersectionEval
           
 class RangeEval
           
 class RelationalOperationEval
          Base class for all comparison operator evaluators
 class TwoOperandNumericOperation
           
 

Uses of Function2Arg in org.apache.poi.ss.formula.functions
 

Classes in org.apache.poi.ss.formula.functions that implement Function2Arg
 class Countif
          Implementation for the function COUNTIF
 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 Fixed2ArgFunction
          Convenience base class for functions that must take exactly two arguments.
 class Hyperlink
          Implementation of Excel HYPERLINK function.

In Excel this function has special behaviour - it causes the displayed cell value to behave like a hyperlink in the GUI.

 class IfFunc
          Implementation for the Excel function IF
 class Index
          Implementation for the Excel function INDEX
 class Lookup
          Implementation of Excel function LOOKUP.

LOOKUP finds an index row in a lookup table by the first column value and returns the value from another column.

 class Match
          Implementation for the MATCH() Excel function.

Syntax:
MATCH(lookup_value, lookup_array, match_type)

Returns a 1-based index specifying at what position in the lookup_array the specified lookup_value is found.

Specific matching behaviour can be modified with the optional match_type parameter.

static class NumericFunction.TwoArg
           
 class Rank
          Returns the rank of a number in a list of numbers.
 class Sumif
          Implementation for the Excel function SUMIF
 class Sumx2my2
          Implementation of Excel function SUMX2MY2()

Calculates the sum of differences of squares in two arrays of the same size.
Syntax:
SUMX2MY2(arrayX, arrayY)

result = Σi: 0..n(xi2-yi2)

 class Sumx2py2
          Implementation of Excel function SUMX2PY2()

Calculates the sum of squares in two arrays of the same size.
Syntax:
SUMX2PY2(arrayX, arrayY)

result = Σi: 0..n(xi2+yi2)

 class Sumxmy2
          Implementation of Excel function SUMXMY2()

Calculates the sum of squares of differences between two arrays of the same size.
Syntax:
SUMXMY2(arrayX, arrayY)

result = Σi: 0..n(xi-yi)2

 class XYNumericFunction
           
 



Copyright 2012 The Apache Software Foundation or its licensors, as applicable.