Hi.
I have founded issue with insertRange method. It incorrectly works for merged cells. (Merged area did not shift)
There is sample code:
{code}
@Test
public void insertRangeTest() throws Exception {
Workbook workbook = new Workbook(“D://test.xlsx”);
Cells cells = workbook.getWorksheets().get(0).getCells();
cells.insertRange(CellArea.createCellArea(2, 2, 8, 8), ShiftType.RIGHT);
workbook.save(“D://out.xlsx”);
}
{code}
As you can see formatting was shifted, but merged area not shifted.
Best regards. Alexey
Hi Alexey,
Thanks for providing us template file and sample code.
After an initial test, I observed the issue as you mentioned. I found by using Cells.insertRange(), the merged area is not shifted fine. I am using the following sample code with your template file.
e.g Sample code: Workbook workbook = new Workbook(“test.xlsx”); Cells cells = workbook.getWorksheets().get(0).getCells(); cells.insertRange(CellArea.createCellArea(2, 2, 8, 8), ShiftType.RIGHT); workbook.save(“out1.xlsx”);
I have logged a ticket with an id “CELLSJAVA-41270” for your issue. We will look into it soon.
Once we have any update on it, we will let you know here.
Thank you.
Hi,
Please try our latest version/fix: Aspose.Cells for Java v8.4.0.7 (attached).
We have fixed your issue now.
Let us know your feedback.
Thank you.
The issues you have found earlier (filed as CELLSJAVA-41270) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.