@Test
public void test(){
SBook book = SBooks.createBook("book1");
book.getBookSeries().setAutoFormulaCacheClean(true);
SSheet sheet1 = book.createSheet("Sheet1");
book.createName("Test").setRefersToFormula("A1:B2");
SRanges.range(sheet1,"A1").setValue(1);
SRanges.range(sheet1,"B1").setValue(2);
SRanges.range(sheet1,"C3").setEditText("=SUM(Test)");
Assert.assertEquals(3D, sheet1.getCell("C3").getValue());
SRanges.range(sheet1,"B1").setValue(3);
Assert.assertEquals(4D, sheet1.getCell("C3").getValue());
}