org.apache.poi.hssf.record.formula.functions
Class Value

java.lang.Object
  org.apache.poi.hssf.record.formula.functions.Fixed1ArgFunction
      org.apache.poi.hssf.record.formula.functions.Value

All Implemented Interfaces:

Function, Function1Arg

public final class Value
extends Fixed1ArgFunction

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.

Author:

Josh Micich

Constructor Summary

Value()

Method Summary

ValueEval

evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0) see Function.evaluate(ValueEval[], int, int)

Methods inherited from class org.apache.poi.hssf.record.formula.functions.Fixed1ArgFunction

evaluate

Methods inherited from class java.lang.Object

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

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)