switch(paperType){ case A0: printSetup.setPaperSize(HSSFPrintSetup.A4_EXTRA_PAPERSIZE); break; case A1: printSetup.setPaperSize(HSSFPrintSetup.A4_EXTRA_PAPERSIZE); break; case A2: printSetup.setPaperSize(HSSFPrintSetup.A4_EXTRA_PAPERSIZE); break; case A3: printSetup.setPaperSize(HSSFPrintSetup.A3_PAPERSIZE); setup=true; break; case A4: printSetup.setPaperSize(HSSFPrintSetup.A4_EXTRA_PAPERSIZE); setup=true; break; case A5: printSetup.setPaperSize(HSSFPrintSetup.A5_PAPERSIZE); setup=true; break; case A6: printSetup.setPaperSize(HSSFPrintSetup.A4_EXTRA_PAPERSIZE); break; case A7: printSetup.setPaperSize(HSSFPrintSetup.A4_EXTRA_PAPERSIZE); break; case A8:
/** * Gets the print setup object. * * @return The user model for the print setup object. */ @Override public HSSFPrintSetup getPrintSetup() { return new HSSFPrintSetup(_sheet.getPageSettings().getPrintSetup()); }
printSetup.setValidSettings(false); setActive(true);
@Override protected void addSeries(final HSSFSheet sheet, final Entity report) { sheet.getPrintSetup().setLandscape(true); sheet.getPrintSetup().setPaperSize(HSSFPrintSetup.A3_PAPERSIZE); sheet.getPrintSetup().setHResolution((short) 1); PPSReportXlsStyleContainer styleContainer = new PPSReportXlsStyleContainer(sheet); List<ReportColumn> columns = ppsReportColumnHelper.getReportColumns(); addSeriesOfReportAuthorAndDate(sheet, report, styleContainer); addSeriesOfProductionLine(sheet, report, styleContainer, columns); }
private void setPrintSetup(HSSFSheet sheet, String displayName) { // sheet style HSSFPrintSetup setup = sheet.getPrintSetup(); setup.setLandscape(true); setup.setPaperSize(HSSFPrintSetup.A4_PAPERSIZE); // header and footer HSSFHeader header = sheet.getHeader(); header.setCenter(displayName); HSSFFooter footer = sheet.getFooter(); footer.setRight(FOOTER_RIGHT); footer.setLeft(FOOTER_LEFT); }
private Sheet createSheet(HSSFWorkbook wb,Paper paper,String name){ Sheet sheet = null; if(name==null){ sheet=wb.createSheet(); }else{ sheet=wb.createSheet(name); } PaperType paperType=paper.getPaperType(); HSSFPrintSetup printSetup=(HSSFPrintSetup)sheet.getPrintSetup(); Orientation orientation=paper.getOrientation(); if(orientation.equals(Orientation.landscape)){ printSetup.setLandscape(true); } setupPaper(paperType, printSetup); int leftMargin=paper.getLeftMargin(); int rightMargin=paper.getRightMargin(); int topMargin=paper.getTopMargin(); int bottomMargin=paper.getBottomMargin(); sheet.setMargin(Sheet.LeftMargin, UnitUtils.pointToInche(leftMargin)); sheet.setMargin(Sheet.RightMargin, UnitUtils.pointToInche(rightMargin)); sheet.setMargin(Sheet.TopMargin, UnitUtils.pointToInche(topMargin)); sheet.setMargin(Sheet.BottomMargin, UnitUtils.pointToInche(bottomMargin)); return sheet; }
@Override protected void addSeries(HSSFSheet sheet, Entity palletBalance) { sheet.getPrintSetup().setLandscape(true); sheet.getPrintSetup().setPaperSize(HSSFPrintSetup.A3_PAPERSIZE); sheet.getPrintSetup().setHResolution((short) 1);
protected void createSheet(String name) { sheet = workbook.createSheet(name); patriarch = sheet.createDrawingPatriarch(); sheet.getPrintSetup().setLandscape(jasperPrint.getOrientation() == JRReport.ORIENTATION_LANDSCAPE); short paperSize = getSuitablePaperSize(jasperPrint); if(paperSize != -1) { sheet.getPrintSetup().setPaperSize(paperSize); } if(password != null) { sheet.protectSheet(password); } }
sheet.getPrintSetup().setLandscape(true); styles = loadStyles(rrDashRep, wb); } catch (IllegalArgumentException ex) { wb.write(xlsOut);xlsOut.flush();xlsOut.close();continue;} sheet.getPrintSetup().setLandscape(true);
private Sheet createSheet(HSSFWorkbook wb,Paper paper,String name){ Sheet sheet = null; if(name==null){ sheet=wb.createSheet(); }else{ sheet=wb.createSheet(name); } PaperType paperType=paper.getPaperType(); HSSFPrintSetup printSetup=(HSSFPrintSetup)sheet.getPrintSetup(); Orientation orientation=paper.getOrientation(); if(orientation.equals(Orientation.landscape)){ printSetup.setLandscape(true); } setupPaper(paperType, printSetup); int leftMargin=paper.getLeftMargin(); int rightMargin=paper.getRightMargin(); int topMargin=paper.getTopMargin(); int bottomMargin=paper.getBottomMargin(); sheet.setMargin(Sheet.LeftMargin, UnitUtils.pointToInche(leftMargin)); sheet.setMargin(Sheet.RightMargin, UnitUtils.pointToInche(rightMargin)); sheet.setMargin(Sheet.TopMargin, UnitUtils.pointToInche(topMargin)); sheet.setMargin(Sheet.BottomMargin, UnitUtils.pointToInche(bottomMargin)); return sheet; }
/** * Gets the print setup object. * @return The user model for the print setup object. */ public HSSFPrintSetup getPrintSetup() { return new HSSFPrintSetup(_sheet.getPageSettings().getPrintSetup()); }
printSetup.setValidSettings(false);
switch(paperType){ case A0: printSetup.setPaperSize(HSSFPrintSetup.A4_EXTRA_PAPERSIZE); break; case A1: printSetup.setPaperSize(HSSFPrintSetup.A4_EXTRA_PAPERSIZE); break; case A2: printSetup.setPaperSize(HSSFPrintSetup.A4_EXTRA_PAPERSIZE); break; case A3: printSetup.setPaperSize(HSSFPrintSetup.A3_PAPERSIZE); setup=true; break; case A4: printSetup.setPaperSize(HSSFPrintSetup.A4_EXTRA_PAPERSIZE); setup=true; break; case A5: printSetup.setPaperSize(HSSFPrintSetup.A5_PAPERSIZE); setup=true; break; case A6: printSetup.setPaperSize(HSSFPrintSetup.A4_EXTRA_PAPERSIZE); break; case A7: printSetup.setPaperSize(HSSFPrintSetup.A4_EXTRA_PAPERSIZE); break; case A8:
/** * Gets the print setup object. * * @return The user model for the print setup object. */ @Override public HSSFPrintSetup getPrintSetup() { return new HSSFPrintSetup(_sheet.getPageSettings().getPrintSetup()); }
printSetup.setValidSettings(false); setActive(true);
/** * Gets the print setup object. * * @return The user model for the print setup object. */ public HSSFPrintSetup getPrintSetup() { return new HSSFPrintSetup(_sheet.getPageSettings().getPrintSetup()); }
printSetup.setValidSettings(false); setActive(true);