Insert range issue

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.