org.apache.poi.hssf.record.formula.functions
Class CalendarFieldFunction
java.lang.Object
org.apache.poi.hssf.record.formula.functions.CalendarFieldFunction
- All Implemented Interfaces:
- Function
public final class CalendarFieldFunction
- extends java.lang.Object
- implements Function
Implementation of Excel functions DAY, MONTH and YEAR
- Author:
- Guenter Kickinger g.kickinger@gmx.net
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
YEAR
public static final Function YEAR
MONTH
public static final Function MONTH
DAY
public static final Function DAY
evaluate
public ValueEval evaluate(ValueEval[] operands,
int srcCellRow,
short srcCellCol)
- Specified by:
evaluate
in interface Function
- Parameters:
operands
- the evaluated function arguments. Empty values are represented with
BlankEval
or MissingArgEval
, never null
.srcCellRow
- row index of the cell containing the formula under evaluationsrcCellCol
- 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
.
Copyright 2009 The Apache Software Foundation or
its licensors, as applicable.