Top Description Fields Constructors Methods

org.apache.poi.ss.formula.functions

public final Class DateFunc

Class Inheritance

extends Fixed3ArgFunction

java.lang.Object
org.apache.poi.ss.formula.functions.Fixed3ArgFunction
org.apache.poi.ss.formula.functions.DateFunc

Imports

java.util.Calendar, org.apache.poi.ss.formula.eval.ErrorEval, .EvaluationException, .NumberEval, .ValueEval, org.apache.poi.ss.usermodel.DateUtil, org.apache.poi.util.LocaleUtil

Implementation for the Excel function DATE

Field Summary

Modifier and Type	Field and Description
public static final Function	instance

Constructor Summary

Access	Constructor and Description
private	DateFunc()

Method Summary

Modifier and Type	Method and Description
public ValueEval	evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2) Implements org.apache.poi.ss.formula.functions.Function3Arg.evaluate. see `Function#evaluate(ValueEval[], int, int)`
private static double	evaluate(int year, int month, int pDay) Note - works with Java Calendar months, not Excel months
private static int	getYear(double d)

Inherited from org.apache.poi.ss.formula.functions.Fixed3ArgFunction:: evaluate

Field Detail

instance	back to summary
public static final Function instance

Constructor Detail

DateFunc	back to summary
private DateFunc()

Method Detail

evaluate back to summary

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

Implements org.apache.poi.ss.formula.functions.Function3Arg.evaluate.

Doc from org.apache.poi.ss.formula.functions.Function3Arg.evaluate.

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

evaluate	back to summary
private static double evaluate(int year, int month, int pDay) throws EvaluationException Note - works with Java Calendar months, not Excel months

getYear	back to summary
private static int getYear(double d)