You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Lior Shliechkorn <li...@yahoo.com> on 2004/01/15 18:07:26 UTC
BRAIN GLICK: RE: Is there a bug in the setPrintArea()?
Brian,
I tried to do that it wasn't working right either. I want to be able to fit a report that is 400 pages with 3 columns being cut off so that each page prints correctly without the remainder columns causing the print job to be 800 pages.
Once I set the printarea to be from A to N, I can see that there is a bounding box around that print area, however, I guess I'm trying to make it work more as a page break(?). How can I modify the page break?
Thanks,
Lior
Brian Glick <B....@Freightek.com> wrote:
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:liorshliech@yahoo.com]
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 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: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------
Do you Yahoo!?
Yahoo! Photos - Get your photo on the big screen in Times Square
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
Re: BRAIN GLICK: RE: Is there a bug in the setPrintArea()?
Posted by Lior Shliechkorn <li...@yahoo.com>.
How do I shrink the margins? That might help a bit. The font size is the smallest.
Danny Mui <da...@muibros.com> wrote:The pagebreak is automatic so I don't think you would be able to modify
them anyway.
You're trying to jam a lot of content into one page:
1) Shrink the margins
2) shrink the font size
3) Set the zoom % so things are smaller. (Adjust to 95% size..keep going
lower till it fits..)
Lior Shliechkorn wrote:
> Brian,
>
> I tried to do that it wasn't working right either. I want to be able to fit a report that is 400 pages with 3 columns being cut off so that each page prints correctly without the remainder columns causing the print job to be 800 pages.
>
> Once I set the printarea to be from A to N, I can see that there is a bounding box around that print area, however, I guess I'm trying to make it work more as a page break(?). How can I modify the page break?
>
> Thanks,
>
> Lior
>
> Brian Glick wrote:
> 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:liorshliech@yahoo.com]
> 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 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: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Photos - Get your photo on the big screen in Times Square
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
Re: BRAIN GLICK: RE: Is there a bug in the setPrintArea()?
Posted by Danny Mui <da...@muibros.com>.
The pagebreak is automatic so I don't think you would be able to modify
them anyway.
You're trying to jam a lot of content into one page:
1) Shrink the margins
2) shrink the font size
3) Set the zoom % so things are smaller. (Adjust to 95% size..keep going
lower till it fits..)
Lior Shliechkorn wrote:
> Brian,
>
> I tried to do that it wasn't working right either. I want to be able to fit a report that is 400 pages with 3 columns being cut off so that each page prints correctly without the remainder columns causing the print job to be 800 pages.
>
> Once I set the printarea to be from A to N, I can see that there is a bounding box around that print area, however, I guess I'm trying to make it work more as a page break(?). How can I modify the page break?
>
> Thanks,
>
> Lior
>
> Brian Glick <B....@Freightek.com> wrote:
> 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:liorshliech@yahoo.com]
> 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 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: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Photos - Get your photo on the big screen in Times Square
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org