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


package org.apache.poi.ss.formula.functions
  • Class
    Description
    Creates a text reference as text, given specified row and column numbers.
     
    Returns the number of areas in a reference.
     
    Interface for those functions that evaluate arguments in array mode depending on context.
    Some utils for converting from and to any base
    Implementation for Excel Bin2Dec() function.
    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.
    Implementation of Excel functions Date parsing functions: Date - DAY, MONTH and YEAR Time - HOUR, MINUTE and SECOND
     
    Implementation for Excel CODE () function.
     
    Implementation for Excel COLUMNS function.
    Implementation for Excel COMPLEX () function.
    Counts the number of cells that contain numeric data within the list of arguments.
    Counts the number of cells that contain data within the list of arguments.
    Implementation for the function COUNTBLANK
    Implementation for the function COUNTIF
     
     
    Implementation for the function COUNTIFS
    Implementation for the Excel function DATE
    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.
    Implementation for Excel Bin2Dec() function.
    Implementation for Excel DELTA() function.
    Implementation for Excel DELTA() function.
    Implementation of the DGet function: Finds the value of a column in an area with given conditions.
    Implementation of the DMax function: Finds the maximum value of a column in an area with given conditions.
    Implementation of the DMin function: Finds the minimum value of a column in an area with given conditions.
    This class performs a D* calculation.
    Enum for convenience to identify and source implementations of the D* functions
    Implementation of the DSum function: Finds the total value of matching values in a column in an area with given conditions.
    Implementation for Excel EDATE () function.
    Implementation for the Excel EOMONTH() function.
    Implementation for the ERROR.TYPE() Excel function.
     
    Implementation for Excel FACTDOUBLE() function.
    Implementation of the financial functions pmt, fv, ppmt, ipmt.
     
     
     
    Convenience base class for functions that only take zero arguments.
    Convenience base class for functions that must take exactly one argument.
    Convenience base class for functions that must take exactly two arguments.
    Convenience base class for functions that must take exactly three arguments.
    Convenience base class for functions that must take exactly four arguments.
    For most Excel functions, involving references ((cell, area), (2d, 3d)), the references are passed in as arguments, and the exact location remains fixed.
    Implementation of Excel 'Analysis ToolPak' function FREQUENCY()
    Returns a frequency distribution as a vertical array
    Common interface for all implementations of Excel built-in functions.
    Implemented by all functions that can be called with zero arguments
    Implemented by all functions that can be called with one argument
    Implemented by all functions that can be called with two arguments
    Implemented by all functions that can be called with three arguments
    Implemented by all functions that can be called with four arguments
    Implementation for Excel HEX2DEC() function.
    Implementation of the HLOOKUP() function.
    Implementation of Excel HYPERLINK function.
    Interface specifying how an algorithm to be used by DStarRunner should look like.
    Implementation for the Excel function IF
    Implementation for Excel IMAGINARY() function.
    Implementation for Excel ImReal() function.
    Implementation for the Excel function INDEX
    Implementation for Excel function INDIRECT
    Implementation of Excel function INTERCEPT()
     
    Calculates the internal rate of return.
    Base class for linear regression functions.
     
    Implementation of the various ISxxx Logical Functions, which take a single expression argument, and return True or False.
    Implementation of Excel function LOOKUP.
    Implementation for the MATCH() Excel function.
     
     
     
     
     
    Calculates Modified internal rate of return.
     
    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
    Implementation of Excel function NA()
    This is the default implementation of a Function class.
    Implementation of Excel NOW() Function
    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).
     
     
     
    Implementation for Excel Oct2Dec() function.
     
    Implementation for Excel function OFFSET()
    Compute the interest portion of a payment.
    Implementation for Excel QUOTIENT () function.
    Returns the rank of a number in a list of numbers.
    Implements the Excel Rate function
    An implementation of the Excel REPLACE() function:
    Implementation for Excel REPT () function.
    Implementation for Excel WeekNum() function.
    Implementation for the Excel function ROW
    Implementation for Excel ROWS function.
    Implementation of Excel function SLOPE()
    An implementation of the SUBSTITUTE function:
    Implementation for the Excel function SUBTOTAL
    Implementation for the Excel function SUMIF
    Implementation for the Excel function SUMIFS
    Implementation for the Excel function SUMPRODUCT
    Implementation of Excel function SUMX2MY2()
    Implementation of Excel function SUMX2PY2()
    Implementation of Excel function SUMXMY2()
    Implementation of Excel T() function
     
    Implementation for the Excel function TIME
    Implementation of Excel TODAY() Function
    Implementation for the Excel function TREND
    Implementation for Excel VALUE() function.
    Implementation of the VLOOKUP() function.
    Implementation for the Excel function WEEKDAY
    Implementation for Excel WeekNum() function.