* ------------------------------------------------------------
*
*/
public void testPrinterSettings(WorkBookHandle book) {
WorkSheetHandle sheet = null;
PrinterSettingsHandle printersetup = null;
try{
sheet = book.getWorkSheet(0);
for(int x=0;x<10;x++){
for(int t=0;t<10;t++){
sheet.add("Hello World " + t,t,x);
}
}
printersetup = sheet.getPrinterSettings();
}catch(Exception e){
Logger.logErr("testPrinterSettings failed: " + e.toString());
}
// fit width
printersetup.setFitWidth(3);
// fit height
printersetup.setFitHeight(5);
// header margin
printersetup.setHeaderMargin(1.025);
// footer margin
printersetup.setFooterMargin(1.025);
// number of copies
printersetup.setCopies(10);
// Paper Size
printersetup.setPaperSize(PrinterSettingsHandle.PAPER_SIZE_LEDGER_17x11);
// Scaling
printersetup.setScale(125);
// resolution
printersetup.setResolution(300);
// GRBIT settings:
// left to right printing
printersetup.setLeftToRight(true);
// print as draft quality
printersetup.setDraft(true);
// black and white
printersetup.setNoColor(true);
// landscape / portrait
printersetup.setLandscape(true);
// write it out
testWrite(book, "PrinterSettings_out.xls");
// read it in
book = new WorkBookHandle(this.outputdir + "PrinterSettings_out.xls");
try{
sheet = book.getWorkSheet(0);
printersetup = sheet.getPrinterSettings();
}catch(Exception e){
Logger.logErr("testPrinterSettings failed: " + e.toString());
}
// header margin
Logger.logInfo("Header Margin: " + printersetup.getHeaderMargin());
// footer margin
Logger.logInfo("Header Margin: " + printersetup.getFooterMargin());
// assertions
// fit width
assertEquals((short)3, printersetup.getFitWidth());
// fit height
assertEquals((short)5, printersetup.getFitHeight());
// number of copies
assertEquals((short)10, printersetup.getCopies());
// Paper Size
assertEquals((short)PrinterSettingsHandle.PAPER_SIZE_LEDGER_17x11, printersetup.getPaperSize()); // TODO: find out what these are
// Scaling
assertEquals((short)125, printersetup.getScale());
// resolution
assertEquals((short)300, printersetup.getResolution());
// left to right printing
assertEquals(true, printersetup.getLeftToRight());
// print as draft quality
assertEquals(true, printersetup.getDraft());
// No color
assertEquals(true, printersetup.getNoColor());
// landscape / portrait
assertEquals(true, printersetup.getLandscape());
}