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 <[EMAIL PROTECTED]> 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:[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 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] --------------------------------- Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
