protected void applyOptions(Workbook wb, DataTable table, Sheet sheet, ExporterOptions options) { facetStyle = wb.createCellStyle(); facetStyle.setAlignment(HorizontalAlignment.CENTER); facetStyle.setVerticalAlignment(VerticalAlignment.CENTER); facetStyle.setWrapText(true); applyFacetOptions(wb, options, facetStyle); cellStyle = wb.createCellStyle(); cellStyle.setAlignment(HorizontalAlignment.LEFT); applyCellOptions(wb, options, cellStyle); PrintSetup printSetup = sheet.getPrintSetup(); printSetup.setLandscape(true); printSetup.setPaperSize(PrintSetup.A4_PAPERSIZE); sheet.setPrintGridlines(true); }
/** * Performs the page setup and searches a matching page format for the report. * * @param printSetup * the print setup object of the current sheet. * @param pageformat * the pageformat defined for the report. * @param paperdef * the excel paper size property (may be null). * @param paperOrientation * the paper orientation, either "Landscape" or "Portrait" */ public static void performPageSetup( final PrintSetup printSetup, final PhysicalPageBox pageformat, final String paperdef, final String paperOrientation ) { short pageCode = ExcelPrintSetupFactory.parsePaperSizeProperty( paperdef ); if ( pageCode == -1 ) { pageCode = ExcelPrintSetupFactory.computePaperSize( pageformat ); } if ( pageCode != -1 ) { printSetup.setPaperSize( pageCode ); } if ( paperOrientation != null && paperOrientation.equals( "auto" ) == false ) { printSetup.setLandscape( "Landscape".equalsIgnoreCase( paperOrientation ) ); } else { final boolean landscape = pageformat.getWidth() > pageformat.getHeight(); printSetup.setLandscape( landscape ); } }
printSetup.setLandscape(true); sheet.setFitToPage(true); sheet.setHorizontallyCenter(true);
printSetup.setLandscape(true); sheet.setFitToPage(true); sheet.setHorizontallyCenter(true);
printSetup.setLandscape(true); sheet.setFitToPage(true); sheet.setHorizontallyCenter(true);
sheet.setHorizontallyCenter(true); PrintSetup printSetup = sheet.getPrintSetup(); printSetup.setLandscape(true);
sheet.setHorizontallyCenter(true); PrintSetup printSetup = sheet.getPrintSetup(); printSetup.setLandscape(true);
printSetup.setLandscape(true); sheet.setFitToPage(true); sheet.setHorizontallyCenter(true);
sh.trackAllColumnsForAutoSizing(); PrintSetup printSetup = sh.getPrintSetup(); printSetup.setLandscape(true);
sh.trackAllColumnsForAutoSizing(); PrintSetup printSetup = sh.getPrintSetup(); printSetup.setLandscape(true);
processColumnWidths(sheet, sortedListDistinctMetricNameStatisticNames.size() ); sheet.createFreezePane(0, 1, 0, 1); // freeze top row sheet.getPrintSetup().setLandscape(true); sheet.setAutobreaks(true); sheet.getPrintSetup().setFitWidth((short) 1);
protected void applyOptions(Workbook wb, DataTable table, Sheet sheet, ExporterOptions options) { facetStyle = wb.createCellStyle(); facetStyle.setAlignment(HorizontalAlignment.CENTER); facetStyle.setVerticalAlignment(VerticalAlignment.CENTER); facetStyle.setWrapText(true); applyFacetOptions(wb, options, facetStyle); cellStyle = wb.createCellStyle(); cellStyle.setAlignment(HorizontalAlignment.LEFT); applyCellOptions(wb, options, cellStyle); PrintSetup printSetup = sheet.getPrintSetup(); printSetup.setLandscape(true); printSetup.setPaperSize(PrintSetup.A4_PAPERSIZE); sheet.setPrintGridlines(true); }
printSetup.setLandscape(true); printSetup.setPaperSize(PrintSetup.A4_PAPERSIZE); sheet.setPrintGridlines(true);
public static void copyPrintSetup(Sheet destSheet, Sheet srcSheet) { PrintSetup setup = srcSheet.getPrintSetup(); if (setup != null) { destSheet.getPrintSetup().setLandscape(setup.getLandscape()); destSheet.getPrintSetup().setPaperSize(setup.getPaperSize()); destSheet.getPrintSetup().setScale(setup.getScale()); destSheet.getPrintSetup().setFitWidth(setup.getFitWidth()); destSheet.getPrintSetup().setFitHeight(setup.getFitHeight()); destSheet.getPrintSetup().setFooterMargin(setup.getFooterMargin()); destSheet.getPrintSetup().setHeaderMargin(setup.getHeaderMargin()); destSheet.getPrintSetup().setPaperSize(setup.getPaperSize()); destSheet.getPrintSetup().setPageStart(setup.getPageStart()); } }
public static void copyPrintSetup(Sheet destSheet, Sheet srcSheet) { PrintSetup setup = srcSheet.getPrintSetup(); if (setup != null) { destSheet.getPrintSetup().setLandscape(setup.getLandscape()); destSheet.getPrintSetup().setPaperSize(setup.getPaperSize()); destSheet.getPrintSetup().setScale(setup.getScale()); destSheet.getPrintSetup().setFitWidth(setup.getFitWidth()); destSheet.getPrintSetup().setFitHeight(setup.getFitHeight()); destSheet.getPrintSetup().setFooterMargin(setup.getFooterMargin()); destSheet.getPrintSetup().setHeaderMargin(setup.getHeaderMargin()); destSheet.getPrintSetup().setPaperSize(setup.getPaperSize()); destSheet.getPrintSetup().setPageStart(setup.getPageStart()); } }
private static void copyPrintSetup(Sheet src, Sheet dest) { PrintSetup srcPrintSetup = src.getPrintSetup(); PrintSetup destPrintSetup = dest.getPrintSetup(); destPrintSetup.setCopies(srcPrintSetup.getCopies()); destPrintSetup.setDraft(srcPrintSetup.getDraft()); destPrintSetup.setFitHeight(srcPrintSetup.getFitHeight()); destPrintSetup.setFitWidth(srcPrintSetup.getFitWidth()); destPrintSetup.setFooterMargin(srcPrintSetup.getFooterMargin()); destPrintSetup.setHeaderMargin(srcPrintSetup.getHeaderMargin()); destPrintSetup.setHResolution(srcPrintSetup.getHResolution()); destPrintSetup.setLandscape(srcPrintSetup.getLandscape()); destPrintSetup.setLeftToRight(srcPrintSetup.getLeftToRight()); destPrintSetup.setNoColor(srcPrintSetup.getNoColor()); destPrintSetup.setNoOrientation(srcPrintSetup.getNoOrientation()); destPrintSetup.setNotes(srcPrintSetup.getNotes()); destPrintSetup.setPageStart(srcPrintSetup.getPageStart()); destPrintSetup.setPaperSize(srcPrintSetup.getPaperSize()); destPrintSetup.setScale(srcPrintSetup.getScale()); destPrintSetup.setUsePage(srcPrintSetup.getUsePage()); destPrintSetup.setValidSettings(srcPrintSetup.getValidSettings()); destPrintSetup.setVResolution( srcPrintSetup.getVResolution() ); }