org.pentaho.reporting.libraries.formula.util

Class HSSFDateUtil

public class HSSFDateUtil extends Object

Contains methods for dealing with Excel dates.
Modified by Cedric Pronzato

Author: Michael Harhen Glen Stampoultzis (glens at apache.org) Dan Sherman (dsherman at isisph.com) Hack Kampbjorn (hak at 2mba.dk)

Method Summary
static intcomputeZeroDate(String config, boolean excelBugCompatible)
static BigDecimalgetExcelDate(Date date)
static BigDecimalgetExcelDate(Date date, boolean excelBugCompatible, int zeroDate)
static DategetJavaDate(BigDecimal date)
Given a excel date, converts it into a Date.
static DategetJavaDate(BigDecimal date, boolean excelBugCompatible, int zeroDate)

Method Detail

computeZeroDate

public static int computeZeroDate(String config, boolean excelBugCompatible)

getExcelDate

public static BigDecimal getExcelDate(Date date)

getExcelDate

public static BigDecimal getExcelDate(Date date, boolean excelBugCompatible, int zeroDate)

getJavaDate

public static Date getJavaDate(BigDecimal date)
Given a excel date, converts it into a Date. Assumes 1900 date windowing.

Parameters: date the Excel Date

Returns: Java representation of a date (null if error)

getJavaDate

public static Date getJavaDate(BigDecimal date, boolean excelBugCompatible, int zeroDate)