org.pentaho.reporting.libraries.formula.util
Class HSSFDateUtil
java.lang.Object
org.pentaho.reporting.libraries.formula.util.HSSFDateUtil
public class HSSFDateUtil
- extends java.lang.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(java.lang.String config,
boolean excelBugCompatible)
|
static java.math.BigDecimal |
getExcelDate(java.util.Date date)
|
static java.math.BigDecimal |
getExcelDate(java.util.Date date,
boolean excelBugCompatible,
int zeroDate)
|
static java.util.Date |
getJavaDate(java.math.BigDecimal date)
Given a excel date, converts it into a Date. |
static java.util.Date |
getJavaDate(java.math.BigDecimal date,
boolean excelBugCompatible,
int zeroDate)
|
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
computeZeroDate
public static int computeZeroDate(java.lang.String config,
boolean excelBugCompatible)
getExcelDate
public static java.math.BigDecimal getExcelDate(java.util.Date date)
getExcelDate
public static java.math.BigDecimal getExcelDate(java.util.Date date,
boolean excelBugCompatible,
int zeroDate)
getJavaDate
public static java.util.Date getJavaDate(java.math.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 java.util.Date getJavaDate(java.math.BigDecimal date,
boolean excelBugCompatible,
int zeroDate)