Here's the record I'm looking at as the page break, it does occur between bof/eof.
I'm not positive I have the right one, but other than offsets, this is the only
difference I found between the two documents(both blank, both with same cell selected,
one with a page break). The part that is strange is the mention of the printer,
although I guess that makes sense since a page break has to do with printing.-->
============================================
Offset 0x634 (1588)
recordid = 0x4d, size =782
[UNKNOWN RECORD]
.id = 4d
[/UNKNWON RECORD]
-----UNKNOWN----------------------------------
00000000 00 00 48 00 50 00 20 00 4C 00 61 00 73 00 65 00 ..H.P. .L.a.s.e.
00000010 72 00 4A 00 65 00 74 00 20 00 34 00 30 00 35 00 r.J.e.t. .4.0.5.
00000020 30 00 20 00 53 00 65 00 72 00 69 00 65 00 73 00 0. .S.e.r.i.e.s.
00000030 20 00 50 00 43 00 4C 00 00 00 00 00 00 00 00 00 .P.C.L.........
00000040 00 00 01 04 00 05 DC 00 30 02 43 FF 80 07 01 00 ........0.C.....
00000050 01 00 EA 0A 6F 08 64 00 01 00 0F 00 58 02 01 00 ....o.d.....X...
00000060 01 00 58 02 03 00 01 00 4C 00 65 00 74 00 74 00 ..X.....L.e.t.t.
00000070 65 00 72 00 00 00 00 00 00 00 00 00 00 00 00 00 e.r.............
00000080 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000090 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000000A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000000B0 00 00 00 00 00 00 01 00 00 00 00 00 00 00 01 00 ................
000000C0 00 00 02 00 00 00 0C 01 00 00 FF FF FF FF 00 00 ................
000000D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 44 49 ..............DI
000000E0 4E 55 22 00 00 00 30 02 00 00 EA 71 57 49 00 00 NU"...0....qWI..
000000F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000100 00 00 00 00 00 00 00 00 00 00 0D 00 00 00 01 00 ................
00000110 00 00 00 00 01 00 00 00 00 00 00 00 00 00 00 00 ................
00000120 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000130 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000140 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000150 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000160 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000170 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000180 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000190 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000001A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000001B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000001C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000001D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000001E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000001F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000200 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000210 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000220 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000230 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000240 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000250 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000260 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000270 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000280 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000290 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000002A0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000002B0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000002C0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000002D0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000002E0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
000002F0 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
00000300 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ..............
-----UNKNOWN----------------------------------
============================================
Mark
-----Original Message-----
From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002 2:00 PM
To: 'POI Users List'
Subject: RE: Page breaks
OOC, What's the sid?
I've never found the Excel book except on Amazon & similar services.
All you have to do is create the record, add it to the RecordFactory.
If it has to do with Sheets (meaning it occurs between the BOF/EOF for a
sheet as opposed to the Workbook), add it to oaph.model.Sheet as well as
methods to manipulate it. Add "user level" methods to
oaph.usermodel.HSSFSheet which call to the oaph.model.Sheet.
Thats about it roughly.
-Andy
On Tue, 2002-10-08 at 13:20, Yanker, Mark wrote:
> Ok, thanks Andy. I looked at the BiffViewer, and it looks like it is an unknown
>record, so I am going to have to look into it. I'm not even sure what I'd do if it
>was a known record other than creating that record class with that particular sid; I
>need to trace another example. Maybe I can find that book at a used bookstore this
>weekend. I'm going to try to find some time to implement that.
>
>
>
>
> Mark Yanker
> 404-586-4179
>
>
> -----Original Message-----
> From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 08, 2002 11:10 AM
> To: Poi (E-mail)
> Subject: Re: Page breaks
>
>
> On Tue, 2002-10-08 at 10:50, Yanker, Mark wrote:
> > Is anyone working on enabling page breaks for HSSF?
> >
> > I noticed there were a couple of posts back in May, but nothing since, AFAICT.
>Andy said(in one of those posts) that it shouldn't be too hard to implement,
> and I'd be willing to look at it. My concern is that I have a couple of years
>experience with java, but zero with the OLE side, and I need it for a project
> that's due to go into user testing at the end of October. Since I probably can't
>get it done before then, I need to look at some other hack to make page
> breaks with POI for right now.
> >
>
> When Marc and I started POI I had no "OLE side" experience (so far as
> the OLE 2 Compound Document format or Excel file format goes). Yet
> inside of 6 months we could write out spreadsheets. So take (6 / 2)*2
> (part time * 2 people). We were doing far more work than this
> particular feature so take 6 months and divide that by 100. You get .06
> months. .6 * 30 = 1.80 days. Assuming you haven't done anything
> remotely resembling this (our most productive point was from the middle
> to the end of the 6 months once we'd "taken it all in").. .1.8 *2 = 3.6
> days.
>
> (assuming 3/4 of the time is just figuring out how/what to do and the
> rest actually doing it).
>
> I'm not trying to be smart even if the above comes off that way. Thats
> basically how I estimate things ;-)
>
> > Can anyone give me an idea of the learning curve on this one? And how to start? I
>might be able to look at it and contrib something while we are in
> testing. Or if someone has looked at it and has something they can share, I'd be
>happy to help.
> >
>
> All you have to do is create a blank spreadsheet, run
> org.apache.poi.hssf.dev.BiffViewer on it, output it to a file. Then add
> a page break to it. Run org.apache.poi.hssf.dev.BiffViewer on that and
> output it to a file. run the unix diff command on the two output
> files. The difference is you page break. If its a "known" record it
> should be easy to adapt. If it is an unknown record you'll have to do
> some guess and checking but I doubt this will be very hard. Thats all
> we do really. If you have the "Microsoft Excel 97 Developer's kit"
> which is out of print but available from Amazon (used and cheap) it
> makes it easier.
>
> This is on my long list of things to do (and a very long list it is) but
> the time I'm able to devote to non-revenue producing efforts is somewhat
> low at the moment. So anything not in the vision for 2.0 probably won't
> be done by me till after 2.0.
>
> -Andy
>
> >
> > Mark Yanker
> >
> >
> >
> >
> > *****
> > "The information transmitted is intended only for the person or entity to which it
>is addressed and may contain confidential, proprietary, and/or privileged material.
>Any review, retransmission, dissemination or other use of, or taking of any action in
>reliance upon, this information by persons or entities other than the intended
>recipient is prohibited. If you received this in error, please contact the sender and
>delete the material from all computers."
> >
> > --
> > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
> >
> --
> http://www.superlinksoftware.com - software solutions for business
> http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in
> Java
> http://krysalis.sourceforge.net/centipede - the best build/project
> structure
> a guy/gal could have! - Make Ant simple on complex Projects!
> The avalanche has already started. It is too late for the pebbles to
> vote.
> -Ambassador Kosh
>
>
> --
> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
>
> *****
> "The information transmitted is intended only for the person or entity to which it
>is addressed and may contain confidential, proprietary, and/or privileged material.
>Any review, retransmission, dissemination or other use of, or taking of any action in
>reliance upon, this information by persons or entities other than the intended
>recipient is prohibited. If you received this in error, please contact the sender and
>delete the material from all computers."
>
> --
> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
>
--
http://www.superlinksoftware.com - software solutions for business
http://jakarta.apache.org/poi - Excel/Word/OLE 2 Compound Document in
Java
http://krysalis.sourceforge.net/centipede - the best build/project
structure
a guy/gal could have! - Make Ant simple on complex Projects!
The avalanche has already started. It is too late for the pebbles to
vote.
-Ambassador Kosh
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
*****
"The information transmitted is intended only for the person or entity to which it is
addressed and may contain confidential, proprietary, and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action in
reliance upon, this information by persons or entities other than the intended
recipient is prohibited. If you received this in error, please contact the sender and
delete the material from all computers."
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
