Hi, I’m using Aspose Cells Java v18.7 and when I copy some rows to some newly added rows, the copied rows don’t have the row height expected.
loadAsposeCellsLicense();
final Workbook wb = new Workbook();
final Worksheet sheet = wb.getWorksheets().get(0);
sheet.getCells().get(0, 0).setValue("&open");
sheet.getCells().get(1, 0).setValue("#open");
sheet.getCells().get(2, 0).setValue(“Content”);
sheet.getCells().get(3, 0).setValue("#close");
sheet.getCells().get(4, 0).setValue("&close");
sheet.getCells().setRowHeightPixel(2, 120);
sheet.getCells().insertRows(4, 3);
final Range rangeFrom = sheet.getCells().createRange(1, 0, 3, 1);
final Range rangeToInsert = sheet.getCells().createRange(4, 0, 3, 1);
final PasteOptions opts = new PasteOptions();
opts.setPasteType(PasteType.ALL);
rangeToInsert.copy(rangeFrom, opts);
wb.save(“C:\Users\Hugo Freixo\Desktop\tests\test.xlsx”);
When I set the options PasteType to ALL, shouldn’t the rows format keep the height? (Copied Row “Content” should have 120px height)
How can I copy several rows to a newly added zone keeping the height property?
Regards,
Hugo Freixo