-
Type:
Bug
-
Resolution: Fixed
-
Priority:
Normal
-
Affects Version/s: 3.5.0 RC
-
Component/s: ZSS Range & Model
-
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
-