Hi world. getLastCellNum() is a better choice. getPhysicalNumberOfCells() is just the number of defined cells and thus non-interesting for the normal user in most situations.
Regards, Karl-Heinz. -----Ursprüngliche Nachricht----- Von: Karl-Heinz Zengerle [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 23. März 2004 17:43 An: [EMAIL PROTECTED] Betreff: known bug in POI? HSSFRow - getPhysicalNumberOfCells() Hi world. I've made a small tool which copies ranges from one Excel sheet (File A) to another Excel sheet (File B). I wondered why column L was left blank. When debugging I was seeing that in the desired lines getPhysicalNumberOfCells() returned 11. So the maximum allowed column would be 10 (because indexes start at 0) and that is column K. Then I've put text to all empty cells coming before. Just column K was always filled. The added texts where "T1" (column A) up to "T10" (column J). For that row getPhysicalNumberOfCells() was returning 12. Thus L was allowed. In the further lines I didn't change the contents and there still the wrong number of cells is returned. Is that a known bug? Is it already fixed? Regards, Karl-Heinz Zengerle --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
