/**
* Set a date value for the cell. Excel treats dates as numeric so you will need to format the
* cell as a date.
*
* <p>This will set the cell value based on the Calendar's timezone. As Excel does not support
* timezones this means that both 20:00+03:00 and 20:00-03:00 will be reported as the same value
* (20:00) even that there are 6 hours difference between the two times. This difference can be
* preserved by using <code>setCellValue(value.getTime())</code> which will automatically shift
* the times to the default timezone.
*
* @param value the date value to set this cell to. For formulas we'll set the precalculated
* value, for numerics we'll set its value. For othertypes we will change the cell to a
* numeric cell and set its value.
*/
public void setCellValue(Calendar value) {
// TODO: activate this when compiling against 3.7.
// boolean date1904 = getSheet().getXSSFWorkbook().isDate1904();
boolean date1904 = false;
setCellValue(DateUtil.getExcelDate(value, date1904));
}
/**
* Set a date value for the cell. Excel treats dates as numeric so you will need to format the
* cell as a date.
*
* <p>This will set the cell value based on the Calendar's timezone. As Excel does not support
* timezones this means that both 20:00+03:00 and 20:00-03:00 will be reported as the same value
* (20:00) even that there are 6 hours difference between the two times. This difference can be
* preserved by using <code>setCellValue(value.getTime())</code> which will automatically shift
* the times to the default timezone.
*
* @param value the date value to set this cell to. For formulas we'll set the precalculated
* value, for numerics we'll set its value. For othertypes we will change the cell to a
* numeric cell and set its value.
*/
public void setCellValue(Calendar value) {
boolean date1904 = getSheet().getWorkbook().isDate1904();
setCellValue(DateUtil.getExcelDate(value, date1904));
}
