yes, i'd like to know that too. it would also be nice to be able to copy cell comments. i know i can not set cell comments using poi, but can i copy it from one cell to another? another copying related question. i am also trying to copy a merged region and i am not very successful with that yet. has anyone done that? if so can you give me some pointers on it?
thanks a lot. nina. -----Original Message----- From: "Jean, Victor [IT]" <[EMAIL PROTECTED]> To: "'POI Users List'" <[EMAIL PROTECTED]> Date: Thu, 25 Sep 2003 17:01:29 -0400 Subject: Copying Data Validation Drop Down Question > > I'm using POI version 1.8.0. > > I would like to copy an existing cell to a different location > in a Excel spreadsheet. > > Currently, I have it succesfully copying everything (data format, > cell styles, font, font color, etc) except for the Data Validation dropdown > box. Does anyone know where or what function sets Data Validation > properties for a cell? > > This is my copying code below: > ___________________________________________________ > HSSFCell originalcell = firstrow.getCell(0); > HSSFCell newcell = nextrow.createCell(0); > > newcell.setCellStyle(originalcell.getCellStyle()); > newcell.setEncoding(originalcell.getEncoding()); > newcell.setCellValue(newcontent); > > ___________________________________________________ > > > I had assumed that the data validation drop down information was stored in > the HSSFCellStyle object, but it's not copying that part correctly. > > Any help would be appreciated. > > > -Victor > > > > --------------------------------------------------------------------- > 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]
