HSSF - PrintSetUp

["Prevesh Kuni" <KuniP@xxxxxxxxxxxxx>]

Hi All,
 
I am using the HSSF to write Excel Spreadsheets and do the following to
set the print layout,
 
psetup     = HSSFSheet_getPrintSetup(sheet)               
HSSFPrintSetup_setLandscape(psetup:     *on)                      
HSSFPrintSetup_setPaperSize(psetup:     A4_PAPERSIZE)     
HSSFPrintSetup_setFitWidth(psetup:     1)                 
HSSFPrintSetup_setFitHeight(psetup:   999)                
 
All works except the fit to option, even though the values are populted
in the set width and height boxes the radio button to actually apply
these values is left unselected, the default is to have the scale radio
button selected.
Is there a way to select the 'fit to' option?
 
Thanks 
 
Prevesh Kuni
RPG Developer
Smollan Group SA (Pty) Ltd
(011) 640 8154 
kunip@xxxxxxxxxxxxx