I want the excel print to fit in 1 page wide by multiple pages high as needed.
The code I have is:
- Code: Select all
var printSetup = scopes.svyExcelUtils.createPrintSetup();
printSetup.setLandscape(true);
printSetup.setPaperSize(scopes.svyExcelUtils.PAPER_SIZE.LETTER_PAPERSIZE);
// printSetup.setFitHeight(1);// do not set - multiple pages high
printSetup.setFitWidth(1);// one page wide
scopes.svyExcelUtils.setDefaultPrintSetup(printSetup);
then later after creating a sheet:
- Code: Select all
var sheet = workbook.createSheet(sheet_title);
sheet.setPrintSetup(printSetup);//ensures that the sheet is correctly setup
But the resultant excel file appears to not be one page wide when I print it out.
Is this a bug or do I need something else in set up?