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 test-case.zip (93.1 KB)