-
Bug
-
Resolution: Fixed
-
Normal
-
3.5.0 RC
-
None
fail on last verification
SBook book = SBooks.createBook("book1"); book.getBookSeries().setAutoFormulaCacheClean(true); SSheet sheet1 = book.createSheet("Sheet1"); sheet1.getCell("E4").setValue("=E4"); Assert.assertEquals("#N/A", sheet1.getCell("E4").getErrorValue().getErrorString()); sheet1.getCell("E4").setValue("=A1"); Assert.assertEquals(0D, sheet1.getCell("E4").getValue()); SRanges.range(sheet1,"4").insert(InsertShift.DEFAULT, InsertCopyOrigin.FORMAT_NONE); sheet1.getCell("A1").setValue(20); Assert.assertEquals("A1", sheet1.getCell("E5").getFormulaValue()); Assert.assertEquals(20D, sheet1.getCell("E5").getValue()); Assert.assertTrue(sheet1.getCell("E4").isNull()); sheet1.getCell("E4").setValue("=E4"); Assert.assertEquals("#N/A", sheet1.getCell("E4").getErrorValue().getErrorString());
- relates to
-
ZSS-597 formula out update sync after insert/delete
- Closed