You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by Òscar Álvarez Vilaplana <gr...@gmail.com> on 2007/02/27 10:53:21 UTC

HSSF: setPrintArea not working?

Hello,

I have set the print area of a worksheet using wb.setPrintArea but
when I open the resulting file in Excel the print area is not set.

I have tried both cell references and rows/cols:

wb.setPrintArea(wb.getNumberOfSheets()-1, 1, 1, 10, 10);

wb.setPrintArea(wb.getNumberOfSheets()-1, "$A$1,$P$30");

Any clues on what may be wrong? There are no merged cells on the
sheet. I am using POI-3.0-alpha3.

Thanks,

Òscar

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/