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 int	computeZeroDate(String config, boolean excelBugCompatible)
static BigDecimal	getExcelDate(Date date)
static BigDecimal	getExcelDate(Date date, boolean excelBugCompatible, int zeroDate)
static Date	getJavaDate(BigDecimal date) Given a excel date, converts it into a Date.
static Date	getJavaDate(BigDecimal date, boolean excelBugCompatible, int zeroDate)

Method Detail

public static int computeZeroDate(String config, boolean excelBugCompatible)

public static BigDecimal getExcelDate(Date date)

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

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)

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