Thanks Avik. So also getLastCellNum() is often a value greater than that what intuition tells (and never lower).
I've already corrected such things. Regards, Karl-Heinz. -----Urspr�ngliche Nachricht----- Von: Avik Sengupta [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 24. M�rz 2004 12:03 An: POI Users List Betreff: Re: AW: phantom cells? Lord Tennyson wrote this 1854, but it applies to working with Excel as well ;) Theirs not to make reply, Theirs not to reason why, ...... But seriously, there are entries for many empty cells in an Excel file. Dont ask why, but history of operations could be one reason. So you cant depend on the index of a record in the file.. you can only go by the row and col numbers inside the record. On Wed, 2004-03-24 at 16:27, Karl-Heinz Zengerle wrote: > Hi world. > > In a row containing 12 elements getLastCellNum() returns 12 also I�ld > expect 11 (because of being 0-based). Also there a phantom cell seems to > be counted. > > Regards, Karl-Heinz. > > > -----Urspr�ngliche Nachricht----- > Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 24. M�rz 2004 11:49 > An: [EMAIL PROTECTED] > Betreff: phantom cells? > > Hi world. > > In a row containing text in column A and column C and having explicitly > deleted the other cells in the line the cell table for the row (in the > debugger) shows me an entry for index 0 (which should be according to > column A) and an entry for index 14 (according to the content > corresponding to column C � intuitively I�ld expect this at index 2). > > How can that be interpreted? Is the history of manipulation operations > performed on that Excel file the reason for such a strange situation? > > MfG > Karl-Heinz Zengerle > ___________________________________________________ > More than competence in Document Management > ___________________________________________________ > > SAW AG > Waldm�nchenerstr. 12 > 81549 M�nchen > Tel.: ++49-89-68088368 > Fax: ++49-89-68088389 > www.sawag.com > > ___________________________________________________ > --------------------------------------------------------------------- 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]
