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]>
