Hi. We have update library version from 21.5 to 21.12 and found issue with range copying. Check out please following example:
@Test
void copyRange() throws Exception {
Workbook workbook = new Workbook("E://test1.xlsx");
Cells cells = workbook.getWorksheets().get(0).getCells();
try {
Range source = cells.createRange("J1:J17");
Range range = cells.createRange("K1:AK17");
PasteOptions options = new PasteOptions();
options.setPasteType(PasteType.ALL);
range.copy(source, options);
workbook.save("E://test_result.xlsx");
} catch (Exception e) {
throw new AsposeBookException(e);
}
}
So. I expect, that values of range J1:J17 will be copied to All cells K1:AK17 (horizontally copying). But result is very strange.
Also. There is two almost equally files. For test.xlsx code works correctly, but for test1.xlsx - code returns wrong file
There is source test.zip (42.8 KB)
Best regards. Alexey