The code is exactly the same with poi hssf quick guide on this site: http://poi.apache.org/spreadsheet/quick-guide.html#PrintArea2
After searching the bugzilla, I've found out that this problem already submitted as a bug since February 2009: https://issues.apache.org/bugzilla/show_bug.cgi?id=46664 This bug is happened since poi 3.5. This problem doesn't appear on poi-3.2-final. Hope somebody will fixed it :) For instant solution, I would fallback using poi-3.2. I'm looking at the source code and it looks like the source code for setPrintArea on poi 3.2 and poi 3.5/3.6 is quite different. Thanks... On Mon, Jun 7, 2010 at 10:38 PM, MSB <[email protected]> wrote: > > Hello, > > Can you post some code please so that we can see what you are trying to do. > You do not need to post everything, just the part where you are trying to > set the print area. While you are doing that, I will have a look through the > test code and play with some of my own to see if I can put together > something that will (hopefully, crosses fingers and toes) work. > > Yours > > Mark B > > > Yohan Yudanara-2 wrote: >> >> Hi, >> >> I'm trying to setprintarea in HSSF using wb.setPrintArea, which is >> mentioned in documentation. >> But I can't get it working. >> When I'm opening my workbook in Excel, the print area is not set. >> >> What am I doing wrong ? >> >> I'm asking the same problem with >> http://mail-archives.apache.org/mod_mbox/poi-user/200702.mbox/%[email protected]%3e >> and >> http://mail-archives.apache.org/mod_mbox/poi-user/200901.mbox/%3c1232033996.732.4.ca...@baldridgeec%3e >> >> Thanks in advance >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> >> > > -- > View this message in context: > http://old.nabble.com/setprintarea-not-working-tp28803698p28806939.html > Sent from the POI - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
