Re: POI oh POI

Thank you, Scott. Worked like a charm. But Autobreaks? I never would've
thought it was related to the problem. There must be documentation I
haven't seen!

// create the sheet object
sheet = HSSF_newSheet(book: sht_name);
HSSFSheet_setAutobreaks(sheet: *ON);

Arthur J. Marino
Southern Container Corporation
(631) 297 - 2276



Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
04/02/2007 04:49 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: POI oh POI






Have you tried calling setAutoBreaks() for the Sheet?


Arthur.Marino@xxxxxxxxxxxxxxxx wrote:

Anybody see anything wrong with 'setFitHeight' and 'setFitWidth' below?
Did I overlook something?

// create the sheet object
sheet = HSSF_newSheet(book: sht_name);

// set paper size to letter
// set print orientation to landscape
// set fit height/width to 1
ps = HSSFSheet_getPrintSetup(sheet);
HSSFPrintSetup_setPaperSize(ps: LETTER_PAPERSIZE);
HSSFPrintSetup_setLandscape(ps: *ON);
HSSFPrintSetup_setFitHeight(ps: 1);
HSSFPrintSetup_setFitWidth(ps: 1);

Arthur J. Marino
Southern Container Corporation
(631) 297 - 2276