http://jakarta.apache.org/poi/apidocs/org/apache/poi/hssf/usermodel/HSSFWorkbook.html#setPrintArea(int, int, int, int, int)
It was committed around the March/April timeframe. 2.0pre?
Shawn hit it on the head, the following 2 bytes in the Horizontal/Vertical Page break records are the Column/Row offsets (start/end). The Excel SDK book is a handy reference when mucking in HSSF (even though it's not 100% right!).
danny
Brett Knights wrote:
-----Original Message----- From: Danny Mui [mailto:[EMAIL PROTECTED] Sent: Thursday, May 29, 2003 10:00 AM To: POI Users List Subject: Re: Page Breaks/Print Area [was:REPOST: Page Breaks]
What do you mean by "making printarea work"? Does it not function correctly for you? Let me know as I was only able to test the simplest of test cases.
I mean being able to set the print area for a worksheet. I am using a copy of the 1.10 sources. I can't find anything that sets a print area. There isn't anything in the sources that matches /print.*area/.
Do you have Microsoft Excel's SDK book? It describes more/less the record layout, I'll summarize the layout for you guys when I get home.No. I have the excelfileformat.pdf from OpenOffice.org though.
--------------------------------------------------------------------- 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]
