Search Java Classes and Packages

Search Java Frameworks and Libraries

255581 classes and counting ...
Search Tips Index Status



#Org.apache.poi.ss.formula Classes and Interfaces - 243 results found.
NameDescriptionTypePackageFramework
AbstractFunctionPtgThis class provides the base functionality for Excel sheet functions There are two kinds of function Ptgs - tFunc and tFuncVarClassorg.apache.poi.ss.formula.ptgApache POI
AddPtgAddition operator PTG the + binomial operator.Classorg.apache.poi.ss.formula.ptgApache POI
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
AggregatingUDFFinderClassorg.apache.poi.ss.formula.udfApache POI
AnalysisToolPakClassorg.apache.poi.ss.formula.atpApache POI
Area2DPtgBaseClassorg.apache.poi.ss.formula.ptgApache POI
Area3DPtgTitle: Area 3D Ptg - 3D reference (Sheet + Area) Description: Defined an area in Extern Sheet.Classorg.apache.poi.ss.formula.ptgApache POI
Area3DPxgTitle: XSSF Area 3D Reference (Sheet + Area) Description: Defined an area in an external or different sheet.Classorg.apache.poi.ss.formula.ptgApache POI
AreaErrPtgAreaErr - handles deleted cell area references.Classorg.apache.poi.ss.formula.ptgApache POI
AreaEvalInterfaceorg.apache.poi.ss.formula.evalApache POI
AreaEvalBaseClassorg.apache.poi.ss.formula.evalApache POI
AreaICommon interface for AreaPtg and Area3DPtg, and their child classes.Interfaceorg.apache.poi.ss.formula.ptgApache POI
AreaI .OffsetAreaClassorg.apache.poi.ss.formula.ptg.AreaIApache POI
AreaNPtgSpecifies a rectangular area of cells A1:A4 for instance.Classorg.apache.poi.ss.formula.ptgApache POI
AreaPtgSpecifies a rectangular area of cells A1:A4 for instance.Classorg.apache.poi.ss.formula.ptgApache POI
AreaPtgBaseSpecifies a rectangular area of cells A1:A4 for instance.Classorg.apache.poi.ss.formula.ptgApache POI
ArrayPtgArrayPtg - handles arrays The ArrayPtg is a little weird, the size of the Ptg when parsing initially onlyClassorg.apache.poi.ss.formula.ptgApache POI
AttrPtg"Special Attributes" This seems to be a Misc Stuff and Junk record.Classorg.apache.poi.ss.formula.ptgApache POI
AttrPtg .SpaceTypeClassorg.apache.poi.ss.formula.ptg.AttrPtgApache 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
BlankEvalClassorg.apache.poi.ss.formula.evalApache 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
BoolEvalClassorg.apache.poi.ss.formula.evalApache POI
BoolPtgBoolean (boolean) Stores a (java) boolean value in a formula.Classorg.apache.poi.ss.formula.ptgApache 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
CollaboratingWorkbooksEnvironmentManages a collection of WorkbookEvaluators, in order to support evaluation of formulas across spreadsheets.Classorg.apache.poi.ss.formulaApache POI
CollaboratingWorkbooksEnvironment .WorkbookNotFoundExceptionClassorg.apache.poi.ss.formula.CollaboratingWorkbooksEnvironmentApache 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
ConcatEvalClassorg.apache.poi.ss.formula.evalApache POI
ConcatPtgClassorg.apache.poi.ss.formula.ptgApache POI
ConstantValueParserTo support Constant Values (2.Classorg.apache.poi.ss.formula.constantApache POI
ControlPtgClassorg.apache.poi.ss.formula.ptgApache 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
DateParserParser for java dates.Classorg.apache.poi.ss.formula.atpApache 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
DefaultUDFFinderDefault UDF finder - for adding your own user defined functions.Classorg.apache.poi.ss.formula.udfApache POI
Deleted3DPxgClassorg.apache.poi.ss.formula.ptgApache POI
DeletedArea3DPtgTitle: Deleted Area 3D Ptg - 3D referecnce (Sheet + Area) Description: Defined a area in Extern Sheet.Classorg.apache.poi.ss.formula.ptgApache POI
DeletedRef3DPtgTitle: Deleted Reference 3D Ptg Description: Defined a cell in extern sheet.Classorg.apache.poi.ss.formula.ptgApache 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
DividePtgThis PTG implements the standard binomial divide "/"Author:Andrew C.Classorg.apache.poi.ss.formula.ptgApache 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
EqualPtgClassorg.apache.poi.ss.formula.ptgApache POI
ErrorConstantRepresents a constant error code value as encoded in a constant values array.Classorg.apache.poi.ss.formula.constantApache POI
ErrorEvalClassorg.apache.poi.ss.formula.evalApache POI
Errortype ERROR.Classorg.apache.poi.ss.formula.functionsApache POI
ErrPtgClassorg.apache.poi.ss.formula.ptgApache POI
EvaluationCellAbstracts a cell for the purpose of formula evaluation.Interfaceorg.apache.poi.ss.formulaApache POI
EvaluationExceptionThis class is used to simplify error handling logic within operator and function implementations.Classorg.apache.poi.ss.formula.evalApache POI
EvaluationNameAbstracts a name record for formula evaluation.Interfaceorg.apache.poi.ss.formulaApache POI
EvaluationSheetAbstracts a sheet for the purpose of formula evaluation.Interfaceorg.apache.poi.ss.formulaApache POI
EvaluationWorkbookAbstracts a workbook for the purpose of formula evaluation.Interfaceorg.apache.poi.ss.formulaApache POI
EvaluationWorkbook .ExternalNameClassorg.apache.poi.ss.formula.EvaluationWorkbookApache POI
EvaluationWorkbook .ExternalSheetClassorg.apache.poi.ss.formula.EvaluationWorkbookApache POI
EvaluationWorkbook .ExternalSheetRangeClassorg.apache.poi.ss.formula.EvaluationWorkbookApache POI
EvenClassorg.apache.poi.ss.formula.functionsApache POI
ExpPtgClassorg.apache.poi.ss.formula.ptgApache POI
ExternalNameEvalClassorg.apache.poi.ss.formula.evalApache POI
ExternSheetReferenceTokenShould be implemented by any Ptg subclass that needs has an extern sheet index For POI internal use onlyInterfaceorg.apache.poi.ss.formulaApache 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
ForkedEvaluatorAn alternative workbook evaluator that saves memory in situations where a single workbook is concurrently and independently evaluated many times.Classorg.apache.poi.ss.formula.eval.forkedApache POI
FormulaEncapsulates an encoded formula token array.Classorg.apache.poi.ss.formulaApache POI
FormulaParseExceptionThis exception thrown when a supplied formula has incorrect syntax (or syntax currently not supported by POI).Classorg.apache.poi.ss.formulaApache POI
FormulaParserThis class parses a formula string into a List of tokens in RPN order.Classorg.apache.poi.ss.formulaApache POI
FormulaParsingWorkbookAbstracts a workbook for the purpose of formula parsing.Interfaceorg.apache.poi.ss.formulaApache POI
FormulaRendererCommon logic for rendering formulas.Classorg.apache.poi.ss.formulaApache POI
FormulaRenderingWorkbookAbstracts a workbook for the purpose of converting formula to text.Interfaceorg.apache.poi.ss.formulaApache POI
FormulaShifterClassorg.apache.poi.ss.formulaApache POI
FormulaTypeEnumeration of various formula types.Classorg.apache.poi.ss.formulaApache 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
FuncPtgClassorg.apache.poi.ss.formula.ptgApache 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
FunctionEvalClassorg.apache.poi.ss.formula.evalApache 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
FunctionNameEvalClassorg.apache.poi.ss.formula.evalApache POI
FuncVarPtgClassorg.apache.poi.ss.formula.ptgApache POI
GreaterEqualPtgPTG class to implement greater or equal toAuthor:fred at stsci dot eduClassorg.apache.poi.ss.formula.ptgApache POI
GreaterThanPtgGreater than operator PTG ">"Author:Cameron Riley (criley at ekmail.Classorg.apache.poi.ss.formula.ptgApache 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
IndexedUDFFinderA UDFFinder that can retrieve functions both by name and by fake index.Classorg.apache.poi.ss.formula.udfApache 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
IntersectionEvalClassorg.apache.poi.ss.formula.evalApache POI
IntersectionPtgClassorg.apache.poi.ss.formula.ptgApache POI
IntPtgInteger (unsigned short integer) Stores an unsigned short value (java int) inAuthor:Andrew C.Classorg.apache.poi.ss.formula.ptgApache POI
IPMTClassorg.apache.poi.ss.formula.functionsApache POI
IrrCalculates the internal rate of return.Classorg.apache.poi.ss.formula.functionsApache POI
IStabilityClassifierUsed to help optimise cell evaluation result caching by allowing applications to specify which parts of a workbook are final.Interfaceorg.apache.poi.ss.formulaApache POI
LessEqualPtgPtg class to implement less than or equalAuthor:fred at stsci dot eduClassorg.apache.poi.ss.formula.ptgApache POI
LessThanPtgLess than operator PTG "Author:Cameron Riley (criley at ekmail.Classorg.apache.poi.ss.formula.ptgApache 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
MemAreaPtgClassorg.apache.poi.ss.formula.ptgApache POI
MemErrPtgClassorg.apache.poi.ss.formula.ptgApache POI
MemFuncPtgClassorg.apache.poi.ss.formula.ptgApache POI
MinaMaxaClassorg.apache.poi.ss.formula.functionsApache POI
MirrCalculates Modified internal rate of return.Classorg.apache.poi.ss.formula.functionsApache POI
MissingArgEvalRepresents the (intermediate) evaluated result of a missing function argument.Classorg.apache.poi.ss.formula.evalApache POI
MissingArgPtgMissing Function Arguments Avik Sengupta Classorg.apache.poi.ss.formula.ptgApache 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
MultiplyPtgClassorg.apache.poi.ss.formula.ptgApache POI
NaClassorg.apache.poi.ss.formula.functionsApache POI
NameIdentifierClassorg.apache.poi.ss.formulaApache POI
NamePtgClassorg.apache.poi.ss.formula.ptgApache POI
NameXPtgA Name, be that a Named Range or a Function / User Defined Function, addressed in the HSSF External Sheet style.Classorg.apache.poi.ss.formula.ptgApache POI
NameXPxgA Name, be that a Named Range or a Function / User Defined Function, addressed in the HSSF External Sheet style.Classorg.apache.poi.ss.formula.ptgApache POI
NotEqualPtgPtg class to implement not equalAuthor:fred at stsci dot eduClassorg.apache.poi.ss.formula.ptgApache POI
NotImplementedExceptionAn exception thrown by implementors of FormulaEvaluator, when attempting to evaluate a formula which requires featuresClassorg.apache.poi.ss.formula.evalApache POI
NotImplementedFunctionThis is the default implementation of a Function class.Classorg.apache.poi.ss.formula.functionsApache POI
NotImplementedFunctionExceptionAn exception thrown by implementors of FormulaEvaluator when attempting to evaluate a formula which requires a function that POI Classorg.apache.poi.ss.formula.evalApache 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
NumberEvalClassorg.apache.poi.ss.formula.evalApache POI
NumberPtgNumber Stores a floating point value in a formula value stored in a 8 byte field using IEEE notationClassorg.apache.poi.ss.formula.ptgApache 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
NumericValueEvalInterfaceorg.apache.poi.ss.formula.evalApache 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
OperandPtgClassorg.apache.poi.ss.formula.ptgApache POI
OperandResolverProvides functionality for evaluating arguments to functions and operators.Classorg.apache.poi.ss.formula.evalApache POI
OperationEvaluationContextContains all the contextual information required to evaluate an operation For POI internal use onlyClassorg.apache.poi.ss.formulaApache POI
OperationPtgClassorg.apache.poi.ss.formula.ptgApache POI
ParenthesisPtgWhile formula tokens are stored in RPN order and thus do not need parenthesis for precedence reasons, Parenthesis tokens ARE written to ensure that userClassorg.apache.poi.ss.formula.ptgApache POI
PercentEvalClassorg.apache.poi.ss.formula.evalApache POI
PercentPtgClassorg.apache.poi.ss.formula.ptgApache POI
PowerPtgClassorg.apache.poi.ss.formula.ptgApache POI
PPMTCompute the interest portion of a payment.Classorg.apache.poi.ss.formula.functionsApache POI
PtgPtg represents a syntactic token in a formula.Classorg.apache.poi.ss.formula.ptgApache POI
PxgAn XSSF only special kind of Ptg, which stores the sheet / book reference in string form.Interfaceorg.apache.poi.ss.formula.ptgApache POI
Pxg3DAn XSSF only special kind of Ptg, which stores a range of sheet / book references in string form.Interfaceorg.apache.poi.ss.formula.ptgApache POI
Quotient Syntax: QUOTIENT(Numerator,Denominator) Numerator is the dividend.Classorg.apache.poi.ss.formula.functionsApache POI
RangeEvalClassorg.apache.poi.ss.formula.evalApache POI
RangePtgClassorg.apache.poi.ss.formula.ptgApache 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
Ref3DPtgTitle: Reference 3D Ptg Description: Defined a cell in extern sheet.Classorg.apache.poi.ss.formula.ptgApache POI
Ref3DPxgTitle: XSSF 3D Reference Description: Defines a cell in an external or different sheet.Classorg.apache.poi.ss.formula.ptgApache POI
RefErrorPtgRefError - handles deleted cell referenceAuthor:Jason Height (jheight at chariot dot net dot au)Classorg.apache.poi.ss.formula.ptgApache POI
RefEvalRefEval is the super interface for Ref2D and Ref3DEval.Interfaceorg.apache.poi.ss.formula.evalApache POI
RefEvalBaseClassorg.apache.poi.ss.formula.evalApache POI
RefNPtgClassorg.apache.poi.ss.formula.ptgApache POI
RefPtgReferencePtg - handles references (such as A1, A2, IA4)Author:Andrew C.Classorg.apache.poi.ss.formula.ptgApache POI
RefPtgBaseReferencePtgBase - handles references (such as A1, A2, IA4)Author:Andrew C.Classorg.apache.poi.ss.formula.ptgApache POI
RelationalOperationEvalBase class for all comparison operator evaluatorsAuthor:Amol S.Classorg.apache.poi.ss.formula.evalApache 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
ScalarConstantPtgCommon superclass of all Ptgs that represent simple constant values.Classorg.apache.poi.ss.formula.ptgApache POI
SharedFormulaClassorg.apache.poi.ss.formulaApache POI
SheetIdentifierClassorg.apache.poi.ss.formulaApache POI
SheetNameFormatterFormats sheet names for use in formula expressions.Classorg.apache.poi.ss.formulaApache POI
SheetRangeInterfaceorg.apache.poi.ss.formulaApache POI
SheetRangeIdentifierClassorg.apache.poi.ss.formulaApache 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
StringEvalClassorg.apache.poi.ss.formula.evalApache POI
StringPtgString Stores a String value in a formula value stored in the format char[]Classorg.apache.poi.ss.formula.ptgApache POI
StringValueEvalInterfaceorg.apache.poi.ss.formula.evalApache 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
SubtractPtgClassorg.apache.poi.ss.formula.ptgApache 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
TblPtgThis ptg indicates a data table.Classorg.apache.poi.ss.formula.ptgApache POI
TextFunctionClassorg.apache.poi.ss.formula.functionsApache POI
ThreeDEvalOptional Extension to the likes of AreaEval and which allows for looking up 3D (sheet+row+column) evaluationsInterfaceorg.apache.poi.ss.formulaApache POI
TimeFuncClassorg.apache.poi.ss.formula.functionsApache POI
TodayClassorg.apache.poi.ss.formula.functionsApache POI
TwoDEvalCommon interface of AreaEval and AreaEvalBase, for 2D (row+column) evaluationsInterfaceorg.apache.poi.ss.formulaApache POI
TwoOperandNumericOperationClassorg.apache.poi.ss.formula.evalApache POI
UDFFinderCommon interface for "Add-in" libraries and user defined function libraries.Interfaceorg.apache.poi.ss.formula.udfApache POI
UnaryMinusEvalClassorg.apache.poi.ss.formula.evalApache POI
UnaryMinusPtg does not have any effect on the operandAuthor:Avik SenguptaClassorg.apache.poi.ss.formula.ptgApache POI
UnaryPlusEvalClassorg.apache.poi.ss.formula.evalApache POI
UnaryPlusPtg does not have any effect on the operandAuthor:Avik SenguptaClassorg.apache.poi.ss.formula.ptgApache POI
UnionPtgClassorg.apache.poi.ss.formula.ptgApache POI
UnknownPtgClassorg.apache.poi.ss.formula.ptgApache POI
Value Syntax: VALUE(text) Converts the text argument to a number.Classorg.apache.poi.ss.formula.functionsApache POI
ValueOperatorPtgCommon superclass of all value operators.Classorg.apache.poi.ss.formula.ptgApache 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
WorkbookDependentFormulaShould be implemented by any Ptg subclass that needs a workbook to render its formula.Interfaceorg.apache.poi.ss.formulaApache POI
WorkbookEvaluatorEvaluates formula cells.Classorg.apache.poi.ss.formulaApache POI
WorkbookEvaluatorProviderProvides access to a WorkbookEvaluator, eg for use with CollaboratingWorkbooksEnvironmentInterfaceorg.apache.poi.ss.formulaApache POI
WorkdayCalculatorA calculator for workdays, considering dates as excel representations.Classorg.apache.poi.ss.formula.atpApache POI
XYNumericFunctionClassorg.apache.poi.ss.formula.functionsApache POI
XYNumericFunction .AccumulatorInterfaceorg.apache.poi.ss.formula.functions.XYNumericFunctionApache POI