Class Value
java.lang.Object
org.apache.poi.ss.formula.functions.Fixed1ArgFunction
org.apache.poi.ss.formula.functions.Value
- All Implemented Interfaces:
Function
,Function1Arg
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 -
Method Summary
Modifier and TypeMethodDescriptionMethods inherited from class org.apache.poi.ss.formula.functions.Fixed1ArgFunction
evaluate
-
Constructor Details
-
Value
public Value()
-
-
Method Details
-
evaluate
Description copied from interface:Function1Arg
-