}
public ExportWorkbook exportCompleteList(final List<HRPlanningDO> list, final ExportWorkbook xls, final Locale locale)
{
final ContentProvider contentProvider = new MyContentProvider(xls);
// create a default Date format and currency column
xls.setContentProvider(contentProvider);
final String sheetTitle = PFUserContext.getLocalizedString("hr.plannings");
final ExportSheet sheet = xls.addSheet(sheetTitle);
sheet.createFreezePane(8, 1);
final ExportColumn[] cols = new ExportColumn[] { //
new I18nExportColumn(Col.USER, "timesheet.user", MyXlsContentProvider.LENGTH_USER),
new I18nExportColumn(Col.PROJEKT, "fibu.projekt", MyXlsContentProvider.LENGTH_STD),
new I18nExportColumn(Col.WEEK_OF_YEAR, "calendar.weekOfYearShortLabel", 4),
new I18nExportColumn(Col.PRIORITY, "resourceplanning.priority", 8),
new I18nExportColumn(Col.PROBABILITY, "resourceplanning.probability", 16),
new I18nExportColumn(Col.UNASSIGNEDHOURS, "resourceplanning.unassignedHours", MyXlsContentProvider.LENGTH_STD),
new I18nExportColumn(Col.MONDAYHOURS, "calendar.shortday.monday", 4),
new I18nExportColumn(Col.TUESDAYHOURS, "calendar.shortday.tuesday", 4),
new I18nExportColumn(Col.WEDNESDAYHOURS, "calendar.shortday.wednesday", 4),
new I18nExportColumn(Col.THURSDAYHOURS, "calendar.shortday.thursday", 4),
new I18nExportColumn(Col.FRIDAYHOURS, "calendar.shortday.friday", 4),
new I18nExportColumn(Col.WEEKENDHOURS, "resourceplanning.weekend", MyXlsContentProvider.LENGTH_STD),
new I18nExportColumn(Col.DESCRIPTION, "timesheet.description", MyXlsContentProvider.LENGTH_EXTRA_LONG)};
// column property names
sheet.setColumns(cols);
final ContentProvider sheetProvider = sheet.getContentProvider();
// Columnformats
sheetProvider.putFormat(Col.UNASSIGNEDHOURS, "0.00");
sheetProvider.putFormat(Col.MONDAYHOURS, "0.00");
sheetProvider.putFormat(Col.TUESDAYHOURS, "0.00");
sheetProvider.putFormat(Col.WEDNESDAYHOURS, "0.00");
sheetProvider.putFormat(Col.THURSDAYHOURS, "0.00");
sheetProvider.putFormat(Col.FRIDAYHOURS, "0.00");
sheetProvider.putFormat(Col.WEEKENDHOURS, "0.00");
final PropertyMapping mapping = new PropertyMapping();
for (final HRPlanningDO planningSheet : list) {
// final ProjektDO projekt = projektDao.getById(planningSheet.getProjektId());
// final PFUserDO user = userGroupCache.getUser(planningSheet.getUserId());