I don't know if you're trying to get the entire width of the spreadsheet
on the page, but if you are, try something like this:
//format sheet
HSSFSheet sht = wb.getSheetAt(i);
HSSFPrintSetup pSetup = sht.getPrintSetup();
sht.setAutobreaks(true);
pSetup.setFitWidth((short) 1);
pSetup.setFitHeight((short) 0);
pSetup.setLandscape(true);
Brian Glick
Freightek, Inc.
-----Original Message-----
From: Lior Shliechkorn [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 28, 2003 12:40 PM
To: POI Users List
Subject: Re: DANNY MUI: Re: Is there a bug in the setPrintArea()?
I have the page set as landscape actually, which is why I think I'm
getting cut off the way I am. I'm not sure what else I would be able to
do.
thanks,
Lior
Danny Mui <[EMAIL PROTECTED]> wrote:
Actually it gets cut off at I hehe. Switch to landscape and you see the
cutoff change to somewhat larger. We can't print 2 pages worth of stuff
onto 1 page can we? Might be able to squeeze more in by modifying
margins and the such but seems like "it's working as intended".
i hate that line ;)
danny
Lior Shliechkorn wrote:
>I can't really include more of a code segement than I already did...=\.
But the problem I'm having doesn't seem to come from the rows
themselves, which works fine for me as well, but the problem is in the
columns being cut off.
>
>I want to print up to column N, but I get cut off at J.
>
>Any ideas, or did this happen to you as well?
>
>Thanks
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Do you Yahoo!?
Yahoo! Photos - Get your photo on the big screen in Times Square
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
