Reading the javadoc again for the HSSFName class (always a good idea) and I have found mention of the setSheetIndex(0 method. Calling this method, and passing the index of the sheet to it, ensures that the name has sheet rather than workbook scope. Will play with the method tonight if I get the chnace nut it would appear that this will allow us to create cells with the same name on different sheets.
Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Same-named-cells-in-several-sheets-tp5683541p5688205.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
