/** * @see org.projectforge.export.DOListExcelExporter#putFieldFormat(ContentProvider, * java.lang.reflect.Field, org.projectforge.common.anots.PropertyInfo, ExportColumn) */ @Override public void putFieldFormat(final ContentProvider sheetProvider, final Field field, final PropertyInfo propInfo, final ExportColumn exportColumn) { super.putFieldFormat(sheetProvider, field, propInfo, exportColumn); if ("dateOfPayment".equals(field.getName()) == true) { exportColumn.setWidth(12); } else if ("paid".equals(field.getName()) == true) { exportColumn.setWidth(8); } else if ("subject".equals(field.getName()) == true) { exportColumn.setWidth(40); } else if ("comment".equals(field.getName()) == true) { exportColumn.setWidth(80); } }
protected List<ExportColumn> reorderAndRemoveOtherColumns(final List<ExportColumn> columns, final String... names) { if (names == null || names.length == 0) { return columns; } final List<ExportColumn> sortedList = new LinkedList<>(); for (final String name : names) { for (final ExportColumn column : columns) { if (name.equals(column.getName())) { sortedList.add(column); break; } } } return sortedList; }
/** * Remove the columns by the given names. * * @param columns * @param names */ protected List<ExportColumn> removeColumns(final List<ExportColumn> columns, final String... names) { if (names == null || names.length == 0) { return columns; } for (final String name : names) { for (final ExportColumn column : columns) { if (name.equals(column.getName()) == true) { columns.remove(column); break; } } } return columns; }
public void putCurrencyFormat(final ContentProvider sheetProvider, final ExportColumn exportColumn) { sheetProvider.putFormat(exportColumn, "#,##0.00;[Red]-#,##0.00"); exportColumn.setWidth(12); } }
if (column.getName().equals(property) == true) { format = map.get(column); break;
/** * @see org.projectforge.export.MyExcelExporter#putFieldFormat(ContentProvider, java.lang.reflect.Field, * org.projectforge.common.anots.PropertyInfo, ExportColumn) */ @Override public void putFieldFormat(final ContentProvider sheetProvider, final Field field, final PropertyInfo propInfo, final ExportColumn exportColumn) { super.putFieldFormat(sheetProvider, field, propInfo, exportColumn); if ("deleted".equals(field.getName()) == true) { exportColumn.setWidth(8); } }
/** * @see org.projectforge.export.MyExcelExporter#putFieldFormat(ContentProvider, * java.lang.reflect.Field, org.projectforge.common.anots.PropertyInfo, ExportColumn) */ @Override public void putFieldFormat(final ContentProvider sheetProvider, final Field field, final PropertyInfo propInfo, final ExportColumn exportColumn) { if ("month".equals(field.getName()) == true) { sheetProvider.putFormat(exportColumn, "mmm"); exportColumn.setWidth(6); } else if ("year".equals(field.getName()) == true) { sheetProvider.putFormat(exportColumn, "#"); exportColumn.setWidth(6); } else { super.putFieldFormat(sheetProvider, field, propInfo, exportColumn); } }
if (type == PropertyType.DATE) { sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE)); exportColumn.setWidth(10); } else if (type == PropertyType.DATE_TIME) { sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE_TIME_MINUTES)); exportColumn.setWidth(10); } else if (type == PropertyType.DATE_TIME_SECONDS) { sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE_TIME_SECONDS)); exportColumn.setWidth(16); } else if (type == PropertyType.DATE_TIME_MILLIS) { sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE_TIME_MILLIS)); exportColumn.setWidth(18); } else if (type == PropertyType.UNSPECIFIED) { if (java.sql.Date.class.isAssignableFrom(field.getType()) == true) { sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE)); exportColumn.setWidth(10); } else if (java.util.Date.class.isAssignableFrom(field.getType()) == true) { sheetProvider.putFormat(exportColumn, DateFormats.getExcelFormatString(DateFormatType.DATE_TIME_MINUTES)); exportColumn.setWidth(16); } else { super.putFieldFormat(sheetProvider, field, propInfo, exportColumn);