poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Danny Mui <da...@muibros.com>
Subject Re: Page Breaks/Print Area [was:REPOST: Page Breaks]
Date Thu, 29 May 2003 16:59:32 GMT

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.

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.

Brett Knights wrote:

>I don't think it currently does that but I may need it for my current
>project and have been looking at it. I have to put it aside for the moment
>so if someone else wants to pick up the ball here is what I have so far. I
>will get back to this in a couple of days if no one else gets it before
>then.
>
>It appears that row breaks are set in a record with recordId 0x1b. The
>structure contains a break count followed by the positions of all the
>breaks:
>
>offset value
>     0 Break count
>     2 first break row (zero based)
>     4 0's
>     6 FF (FF 00 little endian)
>    ----
>     8 2nd break row
>     A 0's
>     C FF 
>
>I haven't figured out what the 4 bytes following the row number do. They are
>always 00 00 FF 00 in my tests so far.
>
>The position of column breaks appears to be similar except the record id is
>0x1a.
>The structure is :
>offset value
>     0 Break count
>     2 first break col
>     4 0's
>     6 FF FF
>    ----
>     8 2nd break col
>     A 0's
>     C FF FF
>
>Similarly the 4 bytes following the position haven't varied from 00 00 FF FF
>so I can't figure out their function.
>
>I have just succeeded in setting the print area as I couldn't find anything
>that would let you do that before. My solution needs a change to HSSFName so
>it returns the underlying NameRecord. Has anyone else made Print Area work?
>
>Brett Knights
>
>  
>
>>-----Original Message-----
>>From: Nate [mailto:nmcminn@charter.net]
>>Sent: Wednesday, May 28, 2003 12:58 PM
>>To: POI Users List
>>Subject: REPOST: Page Breaks
>>
>>
>>I had posted this question a week or two ago, and thought I 
>>would give it
>>one more shot in case it slipped under the radar.  Does 
>>anyone know how to
>>manually insert a page break into an HSSFSheet?  Say, at a given row?
>>
>>--Nathan McMinn
>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>>
>>    
>>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>  
>



Mime
View raw message