Search Java Classes and Packages

Search Java Frameworks and Libraries

255581 classes and counting ...
Search Tips Index Status



#Org.apache.poi.ss.formula.function Classes and Interfaces - 109 results found.
NameDescriptionTypePackageFramework
AddressCreates a text reference as text, given specified row and column numbers.Classorg.apache.poi.ss.formula.functionsApache POI
AggregateFunctionClassorg.apache.poi.ss.formula.functionsApache POI
BaseNumberUtilsSome utils for converting from and to any baseAuthor:cedric dot walter @ gmail dot comClassorg.apache.poi.ss.formula.functionsApache POI
Bin2Dec Syntax: Bin2Dec (number) Converts a binary number to decimal.Classorg.apache.poi.ss.formula.functionsApache POI
BooleanFunctionHere 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.Classorg.apache.poi.ss.formula.functionsApache POI
CalendarFieldFunction Date - DAY, MONTH and YEAR Time - HOUR, MINUTE and SECONDClassorg.apache.poi.ss.formula.functionsApache POI
ChooseClassorg.apache.poi.ss.formula.functionsApache POI
Code Syntax: CODE (text ) Returns a numeric code for the first character in a text string.Classorg.apache.poi.ss.formula.functionsApache POI
ColumnClassorg.apache.poi.ss.formula.functionsApache POI
ColumnsClassorg.apache.poi.ss.formula.functionsApache POI
Complex Syntax: COMPLEX (real_num,i_num,suffix ) Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.Classorg.apache.poi.ss.formula.functionsApache POI
CountCounts the number of cells that contain numeric data within the list of arguments.Classorg.apache.poi.ss.formula.functionsApache POI
CountaCounts the number of cells that contain data within the list of arguments.Classorg.apache.poi.ss.formula.functionsApache POI
CountblankClassorg.apache.poi.ss.formula.functionsApache POI
CountifClassorg.apache.poi.ss.formula.functionsApache POI
Countif .ErrorMatcherClassorg.apache.poi.ss.formula.functions.CountifApache POI
Countif .StringMatcherClassorg.apache.poi.ss.formula.functions.CountifApache POI
CountifsClassorg.apache.poi.ss.formula.functionsApache POI
DateFuncClassorg.apache.poi.ss.formula.functionsApache POI
Days360Calculates the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations.Classorg.apache.poi.ss.formula.functionsApache POI
Dec2Bin Syntax: Bin2Dec (number,[places] ) Converts a decimal number to binary.Classorg.apache.poi.ss.formula.functionsApache POI
Dec2Hex Syntax: DEC2HEX (number,places ) Converts a decimal number to hexadecimal.Classorg.apache.poi.ss.formula.functionsApache POI
Delta Syntax: DELTA (number1,number2 ) Tests whether two values are equal.Classorg.apache.poi.ss.formula.functionsApache POI
DGet Finds the value of a column in an area with given conditions.Classorg.apache.poi.ss.formula.functionsApache POI
DMin Finds the minimum value of a column in an area with given conditions.Classorg.apache.poi.ss.formula.functionsApache POI
DStarRunnerThis class performs a D* calculation.Classorg.apache.poi.ss.formula.functionsApache POI
DStarRunner .DStarAlgorithmEnumClassorg.apache.poi.ss.formula.functions.DStarRunnerApache POI
EDateClassorg.apache.poi.ss.formula.functionsApache POI
EOMonth EOMONTH() returns the date of the last day of a month.Classorg.apache.poi.ss.formula.functionsApache POI
Errortype ERROR.Classorg.apache.poi.ss.formula.functionsApache POI
EvenClassorg.apache.poi.ss.formula.functionsApache POI
FactDouble Syntax: FACTDOUBLE (number) Returns the double factorial of a number.Classorg.apache.poi.ss.formula.functionsApache POI
FinanceClassorg.apache.poi.ss.formula.functionsApache POI
FinanceFunctionClassorg.apache.poi.ss.formula.functionsApache POI
FinanceLibClassorg.apache.poi.ss.formula.functionsApache POI
FixedClassorg.apache.poi.ss.formula.functionsApache POI
Fixed0ArgFunctionConvenience base class for functions that only take zero arguments.Classorg.apache.poi.ss.formula.functionsApache POI
Fixed1ArgFunctionConvenience base class for functions that must take exactly one argument.Classorg.apache.poi.ss.formula.functionsApache POI
Fixed2ArgFunctionConvenience base class for functions that must take exactly two arguments.Classorg.apache.poi.ss.formula.functionsApache POI
Fixed3ArgFunctionConvenience base class for functions that must take exactly three arguments.Classorg.apache.poi.ss.formula.functionsApache POI
Fixed4ArgFunctionConvenience base class for functions that must take exactly four arguments.Classorg.apache.poi.ss.formula.functionsApache POI
FreeRefFunctionFor most Excel functions, involving references ((cell, area), (2d, 3d)), the references are passed in as arguments, and the exact location remains fixed.Interfaceorg.apache.poi.ss.formula.functionsApache POI
FunctionCommon interface for all implementations of Excel built-in functions.Interfaceorg.apache.poi.ss.formula.functionsApache POI
Function0ArgInterfaceorg.apache.poi.ss.formula.functionsApache POI
Function1ArgInterfaceorg.apache.poi.ss.formula.functionsApache POI
Function2ArgInterfaceorg.apache.poi.ss.formula.functionsApache POI
Function3ArgInterfaceorg.apache.poi.ss.formula.functionsApache POI
Function4ArgInterfaceorg.apache.poi.ss.formula.functionsApache POI
FunctionMetadataHolds information about Excel built-in functions.Classorg.apache.poi.ss.formula.functionApache POI
FunctionMetadataRegistryAllows clients to get FunctionMetadata instances for any built-in function of Excel.Classorg.apache.poi.ss.formula.functionApache POI
Hex2Dec Syntax: HEX2DEC (number) Converts a hexadecimal number to decimal.Classorg.apache.poi.ss.formula.functionsApache POI
Hlookup HLOOKUP finds a column in a lookup table by the first row value and returns the value from another row.Classorg.apache.poi.ss.formula.functionsApache POI
Hyperlink In Excel this function has special behaviour - it causes the displayed cell value to behave like a hyperlink in the GUI.Classorg.apache.poi.ss.formula.functionsApache POI
IDStarAlgorithmInterface specifying how an algorithm to be used by DStarRunner should look like.Interfaceorg.apache.poi.ss.formula.functionsApache POI
IfFunc Note that Excel is a bit picky about the arguments to this function, when serialised into Ptgs in a HSSF file.Classorg.apache.poi.ss.formula.functionsApache POI
Imaginary Syntax: IMAGINARY (Inumber) Returns the imaginary coefficient of a complex number in x + yi or x + yj text format.Classorg.apache.poi.ss.formula.functionsApache POI
ImReal Syntax: ImReal (Inumber) Returns the real coefficient of a complex number in x + yi or x + yj text format.Classorg.apache.poi.ss.formula.functionsApache POI
Index INDEX ( reference, row_num[, column_num [, area_num]]) INDEX ( array, row_num[, column_num])Classorg.apache.poi.ss.formula.functionsApache POI
Indirect INDIRECT() returns the cell or area reference denoted by the text argument.Classorg.apache.poi.ss.formula.functionsApache POI
Intercept Calculates the INTERCEPT of the linear regression line that is used to predict y values from x values (http://introcs.Classorg.apache.poi.ss.formula.functionsApache POI
IPMTClassorg.apache.poi.ss.formula.functionsApache POI
IrrCalculates the internal rate of return.Classorg.apache.poi.ss.formula.functionsApache POI
LinearRegressionFunctionBase class for linear regression functions.Classorg.apache.poi.ss.formula.functionsApache POI
LinearRegressionFunction .FUNCTIONClassorg.apache.poi.ss.formula.functions.LinearRegressionFunctionApache POI
LogicalFunction take a single expression argument, and return True or False.Classorg.apache.poi.ss.formula.functionsApache POI
Lookup LOOKUP finds an index row in a lookup table by the first column value and returns the value from another column.Classorg.apache.poi.ss.formula.functionsApache POI
Match MATCH(lookup_value, lookup_array, match_type) Returns a 1-based index specifying at what position in the lookup_array the specifiedClassorg.apache.poi.ss.formula.functionsApache POI
MinaMaxaClassorg.apache.poi.ss.formula.functionsApache POI
MirrCalculates Modified internal rate of return.Classorg.apache.poi.ss.formula.functionsApache POI
ModeClassorg.apache.poi.ss.formula.functionsApache POI
MultiOperandNumericFunctionThis is the super class for all excel function evaluator classes that take variable number of operands, andClassorg.apache.poi.ss.formula.functionsApache POI
NaClassorg.apache.poi.ss.formula.functionsApache POI
NotImplementedFunctionThis is the default implementation of a Function class.Classorg.apache.poi.ss.formula.functionsApache POI
NowClassorg.apache.poi.ss.formula.functionsApache POI
NpvCalculates the net present value of an investment by using a discount rate and a series of future payments (negative values) and income (positiveClassorg.apache.poi.ss.formula.functionsApache POI
NumericFunctionClassorg.apache.poi.ss.formula.functionsApache POI
NumericFunction .OneArgClassorg.apache.poi.ss.formula.functions.NumericFunctionApache POI
NumericFunction .TwoArgClassorg.apache.poi.ss.formula.functions.NumericFunctionApache POI
Oct2Dec Converts an octal number to decimal.Classorg.apache.poi.ss.formula.functionsApache POI
OddClassorg.apache.poi.ss.formula.functionsApache POI
Offset OFFSET returns an area reference that is a specified number of rows and columns from a reference cell or area.Classorg.apache.poi.ss.formula.functionsApache POI
PPMTCompute the interest portion of a payment.Classorg.apache.poi.ss.formula.functionsApache POI
Quotient Syntax: QUOTIENT(Numerator,Denominator) Numerator is the dividend.Classorg.apache.poi.ss.formula.functionsApache POI
RankReturns the rank of a number in a list of numbers.Classorg.apache.poi.ss.formula.functionsApache POI
RateClassorg.apache.poi.ss.formula.functionsApache POI
ReplaceAn implementation of the Excel REPLACE() function: Replaces part of a text string based on the number of charactersClassorg.apache.poi.ss.formula.functionsApache POI
Rept Syntax: REPT (text,number_times ) Repeats text a given number of times.Classorg.apache.poi.ss.formula.functionsApache POI
Roman Syntax: WeekNum (Serial_num,Return_type) Returns a number that indicates where the week falls numerically within a year.Classorg.apache.poi.ss.formula.functionsApache POI
RowFuncClassorg.apache.poi.ss.formula.functionsApache POI
RowsClassorg.apache.poi.ss.formula.functionsApache POI
Slope Calculates the SLOPE of the linear regression line that is used to predict y values from x values (http://introcs.Classorg.apache.poi.ss.formula.functionsApache POI
SubstituteAn implementation of the SUBSTITUTE function: Substitutes text in a text string with new text, some number of times.Classorg.apache.poi.ss.formula.functionsApache POI
Subtotal SUBTOTAL ( functionCode, ref1, ref2 .Classorg.apache.poi.ss.formula.functionsApache POI
Sumif SUMIF ( range, criteria, sum_range ) rangeThe range over which criteria is applied.Classorg.apache.poi.ss.formula.functionsApache POI
Sumifs SUMIFS ( sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], .Classorg.apache.poi.ss.formula.functionsApache POI
Sumproduct SUMPRODUCT ( array1[, array2[, array3[, .Classorg.apache.poi.ss.formula.functionsApache POI
Sumx2my2 Calculates the sum of differences of squares in two arrays of the same size.Classorg.apache.poi.ss.formula.functionsApache POI
Sumx2py2 Calculates the sum of squares in two arrays of the same size.Classorg.apache.poi.ss.formula.functionsApache POI
Sumxmy2 Calculates the sum of squares of differences between two arrays of the same size.Classorg.apache.poi.ss.formula.functionsApache POI
T If the argument is a text or error value it is returned unmodified.Classorg.apache.poi.ss.formula.functionsApache POI
TextFunctionClassorg.apache.poi.ss.formula.functionsApache POI
TimeFuncClassorg.apache.poi.ss.formula.functionsApache POI
TodayClassorg.apache.poi.ss.formula.functionsApache POI
Value Syntax: VALUE(text) Converts the text argument to a number.Classorg.apache.poi.ss.formula.functionsApache POI
Vlookup VLOOKUP finds a row in a lookup table by the first column value and returns the value from another column.Classorg.apache.poi.ss.formula.functionsApache POI
WeekdayFuncClassorg.apache.poi.ss.formula.functionsApache POI
WeekNum Syntax: WeekNum (Serial_num,Return_type) Returns a number that indicates where the week falls numerically within a year.Classorg.apache.poi.ss.formula.functionsApache POI
XYNumericFunctionClassorg.apache.poi.ss.formula.functionsApache POI
XYNumericFunction .AccumulatorInterfaceorg.apache.poi.ss.formula.functions.XYNumericFunctionApache POI