Hi Patrick. I think it's not useless. It's just not an optimum efficiency (traversing via column numbers instead of the iterator and ignoring null cells). It's not invented by POI. All what they do is based on Microsoft behaviour. Regards, Karl-Heinz.
-----Urspr�ngliche Nachricht----- Von: Patrick Lightbody [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 25. M�rz 2004 15:26 An: POI Users List Betreff: RE: HSSFRow.cellIterator order That's a bummer -- seems to make POI almost completely useless for simple scanning of rows. Are there _any_ workarounds short of catching AIOOBE? Seems like a pretty nasty problem > -----Original Message----- > From: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 25, 2004 6:07 AM > To: 'POI Users List' > Subject: AW: HSSFRow.cellIterator order > > Hi Patrick. > You see exactly the similarity of the questions which I've also seen. In > that thread several reasons for that behaviour were mentioned. > Regards, Karl-Heinz. > > -----Urspr�ngliche Nachricht----- > Von: Patrick Lightbody [mailto:[EMAIL PROTECTED] > Gesendet: Donnerstag, 25. M�rz 2004 15:03 > An: POI Users List > Betreff: RE: HSSFRow.cellIterator order > > Karl, > Thanks for the heads up -- I hadn't been following the thread but I'll > take a look. I'm guessing also related to this is the fact that even > though the internal cells ArrayList is size 1, getLastCellNumber() > returns something larger, which causes problems even if I access by > column number. I end up having to catch AIOOBE :( > > Patrick > > > -----Original Message----- > > From: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED] > > Sent: Thursday, March 25, 2004 5:48 AM > > To: 'POI Users List' > > Subject: AW: HSSFRow.cellIterator order > > > > Hi Patrick. > > I posted the topic "phantom cells ...?" recently. For me it looks like > > that the iterator traverses in the internal order. If you don't use > the > > iterator > > But access the column by its number within the row you surely have the > > desired effect. > > Look at the last mails belonging to the topic above. I think there > > exactly your problem is also mentioned. > > Regards, Karl-Heinz. > > > > -----Urspr�ngliche Nachricht----- > > Von: Patrick Lightbody [mailto:[EMAIL PROTECTED] > > Gesendet: Donnerstag, 25. M�rz 2004 14:36 > > An: [EMAIL PROTECTED] > > Betreff: HSSFRow.cellIterator order > > > > I seem to be getting the order of my cell iterator in something that > is > > different from the right-to-left order as defined in my spreadsheet. > Why > > is that? > > > > Patrick > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
