-
Bug
-
Resolution: Fixed
-
Normal
-
3.5.0 RC
-
None
1. let C1:C3 all be 1
2. let A1 be =SUM(C1:C3)
3. delete B1:B2 and shift cells to left
4. A1 is still =SUM(C1:C3) but its value still is 3 not 1
inserting is the same problem
SBook book = SBooks.createBook("book1"); book.getBookSeries().setAutoFormulaCacheClean(true); SSheet sheet1 = book.createSheet("Sheet1"); sheet1.getCell("C1").setValue(1); sheet1.getCell("C2").setValue(2); sheet1.getCell("C3").setValue(3); sheet1.getCell("A1").setValue("=SUM(C1:C3)"); Assert.assertEquals(6D, sheet1.getCell("A1").getValue()); SRanges.range(sheet1,"B1:B2").delete(DeleteShift.LEFT); Assert.assertEquals(1D, sheet1.getCell("B1").getValue()); Assert.assertEquals(2D, sheet1.getCell("B2").getValue()); Assert.assertEquals(null, sheet1.getCell("C1").getValue()); Assert.assertEquals(null, sheet1.getCell("C2").getValue()); Assert.assertEquals(3D, sheet1.getCell("C3").getValue()); Assert.assertEquals(3D, sheet1.getCell("A1").getValue());