The correct SIDS are 0x1b (horizontal page breaks) and 0x1a. short with num of page breaks plus x sub structures containing rows in the case of horizontal or startcol/startrow/endrow (6 bytes) for vertical.
easy stuff. On Tue, 2002-10-08 at 14:20, Yanker, Mark wrote: > 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]> > -- 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]>
