It turns out that this is a problem with a third-party's code. We're downloading the generated workbook via a servlet, and a bug that they had fixed in a previous version seems to have reappeared in a new version of their software. HSSF is generating the workbook correctly.
Thanks, -Mark --- Mark Shipley <[EMAIL PROTECTED]> wrote: > Date: Mon, 4 Nov 2002 14:49:48 -0800 (PST) > From: Mark Shipley <[EMAIL PROTECTED]> > Subject: Re: Certain generated rows not appearing in > correct location > To: POI Users List <[EMAIL PROTECTED]> > > Thanks Andy. I'll try to trim down my code and post > it to bugzilla hopefully tomorrow, but possibly not > until Wednesday. > > -Mark > --- "Andrew C. Oliver" <[EMAIL PROTECTED]> wrote: > > Okay, send us the minimum amount of code to > > replicate the error and post it > > to bugzilla, include output files. > > see: > > > http://jakarta.apache.org/poi/getinvolved/index.html > > for details. > > > > Mark Shipley wrote: > > > > >No, there is data in the row. For each new row, > I > > set > > >the first four cell values (the data is present > > when I > > >call setCellValue). However, whatever data I set > > in > > >the 142nd row, using createRow( 141 ), appears in > > the > > >64th row of the .xls file, and whatever was in > the > > >64th row is gone. There is also no data in the > > 142nd > > >row. > > > > > >--- "Andrew C. Oliver" <[EMAIL PROTECTED]> > wrote: > > > > > > > > >>I'm betting your confused between physical rows > > and > > >>logical rows. > > >>Rows with NO data (not physically represented in > > the > > >>file) do not get > > >>represented. So when you get the next physical > > >>row...its the next one that > > >>has some data associated with it. Get the row > > >>number, use that. > > >> > > >>-Andy > > >> > > >>Mark Shipley wrote: > > >> > > >> > > >> > > >>>I'm using HSSF 1.5.1 to generate a file > > containing > > >>>data stored in a database table where each row > of > > >>> > > >>> > > >>the > > >> > > >> > > >>>generated file corresponds to a row of the > > >>> > > >>> > > >>database. > > >> > > >> > > >>>However, the problem I'm facing is that row 142 > > >>> > > >>> > > >>(row > > >> > > >> > > >>>number in Excel, 1-based) of the generated > spread > > >>>sheet is blank and its data is in row 64. The > > same > > >>> > > >>> > > >>is > > >> > > >> > > >>>true for row 398 which overwrites row 320. No > > >>> > > >>> > > >>matter > > >> > > >> > > >>>the data set being printed, it is always the > same > > >>> > > >>> > > >>row > > >> > > >> > > >>>numbers that cause the problem. > > >>> > > >>>I'm just looping through the result set and > > calling > > >>>createRow( rowCtr++ ) repeatedly. Is this a > > known > > >>>HSSF problem, or might it be something that I'm > > >>> > > >>> > > >>doing? > > >> > > >> > > >>>Thanks, > > >>>-Mark > > >>> > > > >>>__________________________________________________ > > >>>Do you Yahoo!? > > >>>HotJobs - Search new jobs daily now > > >>>http://hotjobs.yahoo.com/ > > >>> > > >>>-- > > >>>To unsubscribe, e-mail: > > >>> > > >>> > > >><mailto:poi-user-unsubscribe@;jakarta.apache.org> > > >> > > >> > > >>>For additional commands, e-mail: > > >>> > > >>> > > >><mailto:poi-user-help@;jakarta.apache.org> > > >> > > >> > > >>> > > >>> > > >>> > > >>> > > >> > > >>-- > > >>To unsubscribe, e-mail: > > >><mailto:poi-user-unsubscribe@;jakarta.apache.org> > > >>For additional commands, e-mail: > > >><mailto:poi-user-help@;jakarta.apache.org> > > >> > > >> > > >> > > > > > > > > > >__________________________________________________ > > >Do you Yahoo!? > > >HotJobs - Search new jobs daily now > > >http://hotjobs.yahoo.com/ > > > > > >-- > > >To unsubscribe, e-mail: > > <mailto:poi-user-unsubscribe@;jakarta.apache.org> > > >For additional commands, e-mail: > > <mailto:poi-user-help@;jakarta.apache.org> > > > > > > > > > > > > > > > > > > > > -- > > To unsubscribe, e-mail: > > <mailto:poi-user-unsubscribe@;jakarta.apache.org> > > For additional commands, e-mail: > > <mailto:poi-user-help@;jakarta.apache.org> > > > > > __________________________________________________ > Do you Yahoo!? > HotJobs - Search new jobs daily now > http://hotjobs.yahoo.com/ > __________________________________________________ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 -- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
