You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Brett Knights <kn...@tanner.com> on 2003/05/29 20:31:19 UTC
RE: Page Breaks/Print Area
> -----Original Message-----
> From: Danny Mui [mailto:danny@muibros.com]
> 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.
Re: Page Breaks/Print Area
Posted by Danny Mui <da...@muibros.com>.
Well this should have been in 1.10,
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:danny@muibros.com]
>>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: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
>