Return-Path: Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org Received: (qmail 35512 invoked from network); 19 Dec 2003 16:00:21 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 19 Dec 2003 16:00:21 -0000 Received: (qmail 52656 invoked by uid 500); 19 Dec 2003 16:00:13 -0000 Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org Received: (qmail 52643 invoked by uid 500); 19 Dec 2003 16:00:13 -0000 Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "POI Users List" Reply-To: "POI Users List" Delivered-To: mailing list poi-user@jakarta.apache.org Received: (qmail 52630 invoked from network); 19 Dec 2003 16:00:13 -0000 Received: from unknown (HELO web40705.mail.yahoo.com) (66.218.78.162) by daedalus.apache.org with SMTP; 19 Dec 2003 16:00:13 -0000 Message-ID: <20031219160013.30936.qmail@web40705.mail.yahoo.com> Received: from [199.66.15.252] by web40705.mail.yahoo.com via HTTP; Fri, 19 Dec 2003 08:00:13 PST Date: Fri, 19 Dec 2003 08:00:13 -0800 (PST) From: Lior Shliechkorn Subject: Is there a bug in the setPrintArea()? To: poi-user@jakarta.apache.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-375917354-1071849613=:29710" X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N --0-375917354-1071849613=:29710 Content-Type: text/plain; charset=us-ascii Hi, I'm trying to set a print area so that my file can fit on one page. However, I'm not getting the results I need from the setPrintArea() - both methods. This is what I'm doing: wb.setPrintArea(0, "$A$1:$N$" + GLOBAL_ROW_COUNT); or wb.setPrintArea(0, 0, 15, 0, (int) GLOBAL_ROW_COUNT); The global_row_count just keeps track on which row I am on the page - pretty self-explanatory. The problem is that it's doing ok on the row side, but on the column side it's still cutting off around column J. Any ideas on how to get around this issue? Thank you very much, Lior Shliechkorn --------------------------------- Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing --0-375917354-1071849613=:29710--