In the Excel printer setup

[2006 IR Open Dicussion]

By: Seung-ho Yeom - yeomsh

In the Excel printer setup

2006-02-02 20:06

The print area of the jasper file which becomes to the A4 size is changed to the letter size from Excel in a conversion.

 

Manually, the print area has to be changed into A4 but the method for changing into the A4 size automatically does not have the print area?

 

 

 

 

 

By: JonHoover - jonhoover

RE: In the Excel printer setup

2006-02-07 01:58

Hi,

 

I´ve had the same Problem. And I was not able to find how to set the pagesize for a couple of days. So I decided to patch the code. I´ve added 2 lines in the JRXlsExporter:

 

protected void createSheet(String name) {

sheet = workbook.createSheet(name);

// added

HSSFPrintSetup ps = sheet.getPrintSetup();

ps.setPaperSize(HSSFPrintSetup.A4_PAPERSIZE);

}

 

This workaround is not the best one, but there was no time left.