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

Class Value

java.lang.Object

org.apache.poi.ss.formula.functions.Fixed1ArgFunction

org.apache.poi.ss.formula.functions.Value

All Implemented Interfaces:

ArrayFunction, Function, Function1Arg

public final class Value
extends Fixed1ArgFunction
implements ArrayFunction

Implementation for Excel VALUE() function.

Syntax:
VALUE(text)

Converts the text argument to a number. Leading and/or trailing whitespace is ignored. Currency symbols and thousands separators are stripped out. Scientific notation is also supported. If the supplied text does not convert properly the result is #VALUE! error. Blank string converts to zero.

Constructor Summary

Constructors

Constructor	Description
Value()

Method Summary

Modifier and Type	Method	Description
static Double	convertTextToNumber(String strText)	TODO see if the same functionality is needed in OperandResolver.parseDouble(String)
ValueEval	evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0)	see Function.evaluate(ValueEval[], int, int)
ValueEval	evaluateArray(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
static Double	parseDateTime(String pText)

Methods inherited from class org.apache.poi.ss.formula.functions.Fixed1ArgFunction

evaluate, evaluate

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.apache.poi.ss.formula.functions.ArrayFunction

evaluateOneArrayArg, evaluateTwoArrayArgs

Constructor Detail

Value

public Value()

Method Detail

evaluate

public ValueEval evaluate(int srcRowIndex,
                          int srcColumnIndex,
                          ValueEval arg0)

Description copied from interface: Function1Arg

see Function.evaluate(ValueEval[], int, int)

Specified by:

evaluate in interface Function1Arg

evaluateArray

public ValueEval evaluateArray(ValueEval[] args,
                               int srcRowIndex,
                               int srcColumnIndex)

Specified by:

evaluateArray in interface ArrayFunction

Parameters:

args - the evaluated function arguments. Empty values are represented with BlankEval or MissingArgEval, never null.

srcRowIndex - row index of the cell containing the formula under evaluation

srcColumnIndex - column index of the cell containing the formula under evaluation

Returns:

The evaluated result, possibly an ErrorEval, never null. Note - Excel uses the error code #NUM! instead of IEEE NaN, so when numeric functions evaluate to Double.NaN be sure to translate the result to ErrorEval.NUM_ERROR.

convertTextToNumber

public static Double convertTextToNumber(String strText)

TODO see if the same functionality is needed in OperandResolver.parseDouble(String)

Returns:

null if there is any problem converting the text

parseDateTime

public static Double parseDateTime(String pText)