I am using Aspose Cells to copy rows from a template Excel file to a new workbook. In my template, one of the cells in a row contains a DataValidation list (drop down list of choices the user can select).
When I use code like:
worksheetReport.Cells.CopyRow(worksheetTemplate.Cells, curRowTemplate, curRowReport);
the row is copied fine but my cell with the DataValidation list just appears as a normal cell (there is no drop down validation list).
Is there a way I can bring the DataValidation list along with the copy?