Hi.
I have founded one issue, when insertRows works incorrectly. I have prepared independent test for you, but it works correctly.
1) i have a several rows with a function, that links to cell in row above.
2) i have inserted a several rows after first row
3) i assume, that all functions will affect inserting and move cell’s link, but in my case it fails.
@Test
public void insertRowsTest() throws Exception {
//Works
Workbook workbook = new Workbook(“D://in.xlsx”);
Cells cells = workbook.getWorksheets().get(0).getCells();
System.out.println(cells.get(“B3”).getFormula());
System.out.println(cells.get(“B4”).getFormula());
cells.insertRows(2, 4, true);
System.out.println(cells.get(“B7”).getFormula()); //Not affected because row 8 is above on inserted range
System.out.println(cells.get(“B8”).getFormula()); //Affected
workbook.save(“D://out.xlsx”);
assertEquals("=IF(C8<=$C$1,DATE(YEAR($B$1),C7+1,1),"")", cells.get(“B8”).getFormula());
System.out.println("");
//Fail
workbook = new Workbook(“D://in1.xls”);
cells = workbook.getWorksheets().get(1).getCells();
System.out.println(cells.get(“B9”).getFormula());
System.out.println(cells.get(“B10”).getFormula());
cells.insertRows(8, 4, true);
System.out.println(cells.get(“B13”).getFormula()); //Not affected because row 8 is above on inserted range
System.out.println(cells.get(“B14”).getFormula()); //Not affected
workbook.save(“D://out1.xls”);
assertEquals("=IF(C14<=$C$1,DATE(YEAR($B$1),C13+1,1),"")", cells.get(“B14”).getFormula());
}
As you can see in out.xlsx all is fine. All formulas was affected.
But in in.xls (probably format is important) Formulas for second sheet (“Скважины”), column B (starts with row 14) are not affected inserting rows.
Best regards. Alexey