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/ -- To unsubscribe, e-mail: <mailto:poi-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:poi-user-help@;jakarta.apache.org>
