Free Support Forum -

Copying rows which include dropdowns is incorrect

I got troubles trying to copy rows, which include dropdowns from one sheet to another - the rows are copied but dropdowns are not in the same places.

I am trying to do:

Worksheet tab1Sheet = workbook.getWorksheets().get("tab1");
Worksheet temporarySheet = workbook.getWorksheets().add("TEMP");
temporarySheet.getCells().copyRows(tab1Sheet.getCells(), 0, 0, 8);

with the excel file attached (there are four dropdowns in tab1 sheet: D1, C4, D4, E4), after performing copying i got three of them and not in correct places: C1, D1, E1.

I would be grateful if you could help with this issue (93.1 KB)


Thanks for the template file and sample code segment.

Please try using our latest version/fix: Aspose.Cells for Java v18.4.x, it should fix your issue as I tested your scenario/case a bit using your template file and sample code.

Let us know if you still find the issue you have described.

I confirm, it works :wink:
Thank you for a quick response


Good to know that your issue is sorted out by the latest version/fix. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.