Copying Data Validation Drop Down Question

[Jean, Victor [IT]]

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]