Fwd: Need to setup Print option "Fit All Columns on One Page" in poi java code

[Raj Konds]

Please provide some assistance asap.
Thanks.


---------- Forwarded message ----------
From: Raj Konds <rajeshkond...@gmail.com>
Date: Wed, Aug 7, 2013 at 4:16 PM
Subject: Need to setup Print option "Fit All Columns on One Page" in poi
java code
To: user-i...@poi.apache.org, user-...@poi.apache.org


Hi all,

I know that following poi code will setup the print option "Fit Sheet on
One Page" by default

    Workbook wb = new HSSFWorkbook();
    Sheet sheet = wb.createSheet("format sheet");
    PrintSetup ps = sheet.getPrintSetup();

    sheet.setAutobreaks(true);

    ps.setFitHeight((short)1);
    ps.setFitWidth((short)1);


But my requirement is to setup Print Option "Fit All Columns on One
Page" by default. i.e. when the excel is generated and user presses
Ctrl+P it should show the Print dialog box with "Fit All Columns on
One Page" option by default.

I tried with

    ps.setFitHeight((short)2);
    ps.setFitWidth((short)2);

but it doesn't work.

Can somebody please help asap, need help urgently.

Thanks,

Rajesh